> From: "Dominic Burford" <[EMAIL PROTECTED]> > > 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?
Just keep building the lcWhereClause untill your done, that includes "Where". Sql = "SELECT * FROM <Table> "+ lcWhereClause1 + " INTO CURSOR curTemp" &SQL _______________________________________________ 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.
