Hi, Bill!
The VFP help file says:
>>
The format for the parameters is "ParameterName1, 'Type1'; ParameterName2, 'Type2'; ..."
<<
But youre dealing only with "," as separators instead of using ";" as parameter separator - is this the problem?
Some anothers hints:
- Your lcList variable starts with a "," - may be this confuses VFP a little bit!
- Is it ok to deal with "vartype(lcExpression)"? IMO you have to use "TYPE(lcExpression)".
- What about all parts of lcexpression - do all parts exist in the moment of firing of "dbc_AfterModifyView"?
- No possibility of having question marks in any string constants which could confusing the "occurs('?',lcSQL)" statement?
- I think
lcExpression =
lcParameters =
is to restrictive! What about expressions like "WHERE MyField = ALLTRIM( ?lcParameter )"?
Summary: It will be a hard job to make this work in all possible circumstances!
BTW: I never took care of this ParameterList - what is this usefull for?
SeBaFlu