Hi!

In addition to what is already said, you can reduce the length of the query sting by several ways. For example, use 1-letter aliases for tables in query. Use '?' parameters in the query to pass values for query conditions etc.

Examples:

lcFilt = 'Jo%'
SQLEXEC(nHandle, "SELECT a.Key, a.Name, a.Sum, ... FROM Customers a ... WHERE a.FirstName LIKE ?lcFilt")

lcLT = "Very very long text for very very long updating command"
SQLEXEC(nHandle,"UPDATE Customers a SET a.Notes = ?lcLT")

HTH.

>to all
>i am sending query stings to sql server to bring back cursors for my reports. when the string is 254 characters or less it runs fine but otherwise it bombs out. has anyone else had this problem, and/or is their a workaround for it
>tia
>frank