General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Using a class property when building an SQL statement
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only