I am migrating to SQL Server as backend. I will be using VFP 9 in future. At the moment I have VFP 6 & 8 available, but the application is in VFP 6.

I tried run a long sql statement using SqlExec function. VFP Error "Expression too long- String length > 255 characters" is shown. I use complex VFP SQL statements for reporting. The only way I figured was to migrate these to SQL Server format & run using SQLEXEC. I read something about Cursor Adapter, but have not used it.

1) Is there any other method / technique to run long queries?
2) Does Cursor Adapter retrive one table at a time? or can it be used for complex querries?

Aman