Information générale
Titre:
SQL WHERE clause capacity: LAME! LAME! LAME!
I've been writing some code that writes, compiles, and executes SQL statements. I've found in VFP 5.0 that the length of the WHERE clause is extremelly limited relative to the alleged capacities of the product. For example, a WHERE clause with only 5 or 6 "BETWEEN" clauses, or an IN (...) clause with a few dozen entries, will generate an "SQL expression too complex" error. Please note that we are talking about a command that in its entirety is only a few hundred characters long, far less than the published limit.
My recommendation: If you are planning to use SQL with long WHERE clauses in your app (or have your app generate and execute them), use a different product than VFP.
Suivant
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