>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

If this isn't a typo, there is a missing ; here.

> 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