Information générale
Catégorie:
Codage, syntaxe et commandes
Donald,
Here's a guess for you. . .
mail_date is a DATE-type field and your comparand is a string.
Good luck,
Jim N
>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.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement