>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.
what are you issuing the command against? VFP? Oracle? SQL Server? Does the backend accept dates in that format?
Mark McCasland
Midlothian, TX USA