Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Evaluating profile logic
Message
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01134150
Message ID:
01134164
Views:
23
>The first expression is only valid in SQL. You'll have to parse it in order to apply directly to a table. The query route may not be as bad as you think
>
lcExpr = 'Trans.cProduct_Line_Code between "100" and "200"'
>lnPK = Trans.pk
>SELECT * FROM Trans ;
>  WHERE Trans.pk = lnPK AND &lcExpr ;
>  TO SCREEN NOCONSOLE
>IF _TALLY > 0
>  * satisfied
>ENDIF
>
Right. For now we decided to rather fix all profiles. However, I believe my solution with evaluate is wrong and I may need to switch to SQL instead, though originally I wanted to avoid it.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform