>>>
>>>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?
>>
>
>
>You can still use your seek/scan/etc? on your cursors. Its just that the cursors will now come from selects on sql instead of using a dbf.
>
>Not much to change in that regard.
Thanks for all that - I'll get cracking next week
Colin
Specialist in Advertising, Marketing, especially Direct Marketing
I run courses in Business Management and Marketing