Thanks
I can't do that because I'm working inside someone else program
and they set the parameters. I need to figure out ways to do it
without relying on stored procedures.

>You may call stored procedure passing there parameters only.
>
>>So the only option is to do multiple SQLEXEC() to cursors then
>>combine the cursor in an SQLEXEC() statement.
>>I tried using this type of construct but it errored out as a syntax error.
>>
>>lcSQLCmd=[SELECT ....] total of 256 characters
>>
>>SQLEXEC(lnconnect,lcSQLCmd,'wips')
>>
>>I never got to the SQLEXEC()
>>the lcSQLCmd=[SELECT ] caused the syntax error when over 255 characters
>>
>>
>>>Yes, the pass-through method only allows upto 255 chars...
>>>I have been working on a possible solution but have been coming up blank. My latest solution is to try doing a create view as ... in a local VFP .dbc if the limit is over the 255 length. Then use the view... Apparently that will allow for longer view and VFP will handle it in some other fashion which I am not quite sure of yet...
>>>
>>>
>>>>Is there a limit to the character string that can be used in SQLEXEC()?
>>>>