Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Parameter List in View Designer
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00635142
Message ID:
00635233
Vues:
19
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform