>>>>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
>
>You can change the local sql operations on vfp tables to access the analogous sql tables by setting up a connection string, creating your connection then issuing sql passthrough and getting the return set into a cursor for use in vfp. Not sure its going to be terribly difficult but will involve some changes ....
But I need to get more VFP SQL statements into my apps as opposed to scan/seek/ etc? - once I've worked that out then I can start playing with SQL Server - is that a logical progression path in your mind?
Colin
Specialist in Advertising, Marketing, especially Direct Marketing
I run courses in Business Management and Marketing