Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Need some help with macro-substitutions in SQL-statement
Message
From
15/06/2001 04:40:27
 
 
To
15/06/2001 03:32:24
Eugene Kolmakov
Millennium Technologies
Vladivostok, Russia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00519841
Message ID:
00519846
Views:
14
Eugene,
There are different ways to do this:
cond1 = [ MyField1 = MyCond1 ]
cond2 = [ AND MyField2 = MyCond2 ]
condn = [ AND MyField3 = MyCond3 ]

SELECT * FROM < My Table > WHERE &cond1 &cond2 &condn
or
lcWhere = [ WHERE MyField1 = MyCond1 ]+;
          [ AND MyField2 = MyCond2 ]+;
          [ AND MyField3 = MyCond3 ]

SELECT * FROM < My Table > &lcWhere
HTH

>I need to build SQL-statement and the problem is that I have too many conditions in WHERE-clause. I try to store them in some variables and then use the "&a1.a2.a3..." expression to append conditions in a query. But it generates error message during execution. Maybe anybody knows the way to solve this problem ?
Daniel
Previous
Reply
Map
View

Click here to load this message in the networking platform