VFP - Parameterised Views - "sql: where clause is invalid" - Why?
Posted on 2014-09-11
trying to pass arbitrary filter code to a parameterised view. It's rejecting even simple obvious valid examples.
I have a global variable (startit.filt_expr) which holds the filter code and the parameter in the view is simply ?startit.filt_expr
I can manually perform "Select * from ADDRESS WHERE CUSTOMER INTO DBF WHATEVER" no problem
but if startit.filt_expr is set to "ADDRESS.CUSTOMER", or just "CUSTOMER" or "ADDRESS.CUSTOMER=.T." or just "CUSTOMER=.T." and I try
"USE ADDRESS_USER_QUERY" (the name of the parameterised view) it fails every time with the error message
"SQL: WHERE clause is invalid" despite the fact that I can see startit.filt_expr is still happily sitting there waiting to be used.
Looks like I'm missing a step of misunderstanding how the parameterised views work.
Kindly enlighten me!