Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using a class property when building an SQL statement
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Using a class property when building an SQL statement
Miscellaneous
Thread ID:
00291715
Message ID:
00291715
Views:
56
I am trying to use a class property as the where clause in an SQL statement. Something like...

********
class property
myclass.property = "mytable.field = 'Georgia'"
*******************

select * ;
from mytable;
where myclass.property

I have tried to use the & and eval() but I either get a syntax error with the & and 0 records with eval. Eval() always equals .f. in the command window.

I know I can assign a variable the contents of the class property and then macro it in the where clause, but was just wondering if I was overlooking something.

thanks,
Ron
Next
Reply
Map
View

Click here to load this message in the networking platform