>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.


older versions of fp had problems w/ between and in. you may need to 'spell it out' to get it to work