Frank,

What specific error are you getting? One from VFP or one from sql server?

Remember that in VFP no single string constant can be longer that 254 characters, string memvars are limited by available memory, SPT strings have like an 8k limit but I think there's a sys() function call that increases that buffer size.

Since constants are limited in size you typically have to add several constants together:

lcSQL = "select <i>(no more than 254 characters)</i> " + ;
   " from TheTable" + ;
   " where ... "

SQLExec( lnHandle, lcSQL )

>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