General information
Title:
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.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only