Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Parsing Long SQL Statements
Message
From
22/01/1999 11:53:46
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Parsing Long SQL Statements
Miscellaneous
Thread ID:
00178997
Message ID:
00178997
Views:
61
What's the best way to parse a long SQL statement into a string variable?

For example:

cquery = "select mastddup.location, mastddup.census, ;
mastddup.name,mastddup.addr1, mastddup.city, mastddup.state, mastddup.zip,;
mastddup.zip4,bs_arch.location, bs_arch.mail_date,bs_arch.mail_code from mastddup,;
bs_arch where mastddup.location=bs_arch.location and bs_arch.mail_date >= '19981201' "

The problem I've got with this particular string is the last "and" clause. I keep getting syntax errors.
Next
Reply
Map
View

Click here to load this message in the networking platform