Bob

I'm familiar with using VFP SQL statements but the major part of the app is written as Use/Seek/Scan

If I understand you correctly - you are saying convert the app to use VFP SQL statements and THEN think about SQL Server

Thanks

Colin

>Assuming by individual calls, you are talking about VFP SQL calls rather than directly working with the tables (Use/Scan/Seek). If this is the case, the basic idea is to send that SQL command as a string to a single object so that object can interact with the backend. For the first pass the object would just execute the SQL command locally and return the cursor. Later, you can alter that one object to work with SQL Server (or MySql/Oracle)
>
>In my case, the SQL Object is on my baseclass form so the cursor ends up in the correct data session automatically. HTH
>
>Bob
>
>>>>I need to migrate to VFP9 first (yes I know not 100% necessary but desirable)
>>>>
>>>>Then I need to move to SQL server
>>>>
>>>>Then I need to move to .Net
>>>
>>>You don't need to go to vfp9 to use sql server. We have it here in both 6.0 and 7.0. Do you have to move to 9?
>>
>>John
>>
>>Now that's really helpful - no I don't need to move to VFP9
>>
>>Sadly all my table work in VFP6 is individual calls which means a hell of a lot of changes - any tips on putting SQL in as backend?
>>
>>Thanks
>>
>>Colin