Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Parameter List in View Designer
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00635142
Message ID:
00635233
Views:
20
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform