>Wait a minute!! I though that you can work around the limit by
>concatenating the passthrough with variables. I seem to remember being
>able to generate a SQLEXEC statement that was well over 500 characters.
>
>If you guys think I'm wrong, then I'll go check some of my old code.
>
>Matt McDonnell

You're correct. But when I do that it still doesn't work. The SQL server supports an INSERT INTO statement that instead of specifying VALUES, a SELECT statement is used. VFP 5.0 doesn't like it for some reason, not even if it is in an SQLEXEC command.

I haven't tried SQLPREPARE() yet though....


jeff