Dominic Burford wrote:
Hi
I need some way of executing SQL statements, where the WHERE clause may be very
long. I am trying to get the following to work:
Local lcWhereClause
lcWhereClause = <various conditions>
SELECT * FROM <Table> WHERE &lcWhereClause INTO CURSOR curTemp
Where the length of lcWhereClause exceeds 1024 it produces an error. Even when
I break the statement into two smaller statements, it still errors:
Local lcWhereClause1, lcWhereClause2
lcWhereClause1 = <various conditions>
lcWhereClause2 = <more conditions>
SELECT * FROM <Table> WHERE &lcWhereClause1 AND &lcWhereClause2 INTO CURSOR
curTemp
How can I get round this?
Isn't there a SYS() command to allow longer SQLs?
--
Michael J. Babcock, MCP
MB Software Solutions, LLC
http://mbsoftwaresolutions.com
http://fabmate.com
"Work smarter, not harder, with MBSS custom software solutions!"
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
