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()?
>
>I had a query give me an error message if I used the tables names but if I didn't the query worked
>
>
>Example of working:
>
>SQLEXEC(,gnconnect,"SELECT ljob, closedate, cogsdate,;
> invno, indate;
> FROM bbjthead, arjob, arjobhd;
> WHERE bbjthead.ljob=arjob.ljob
> AND closedate in null;
> AND cancldate is null;
> AND arjob.invno=arjobhd.invno;
> ORDER by ljob",;
> "wips")
>
>Example of nonworking:
>
>SQLEXEC(,gnconnect,"SELECT bbjthead.ljob, bbjthead.closedate, bbjthead.cogsdate,;
> invno, indate;
> FROM bbjthead, arjob, arjobhd;
> WHERE bbjthead.ljob=arjob.ljob
> AND bbjthead.closedate in null;
> AND bbjthead.cancldate is null;
> AND arjob.invno=arjobhd.invno;
> ORDER by ljob",;
> "wips")
>
>It errored out on the "wips") line.
>unrecognized comman/phrase