>Hi
>
>I'm looking to convert a number of Foxpro 6 applications into SQL Server based apps, would be grateful if someone could point out some useful literature or resources in this regard.
>
>Regards
>
>
Hi Omran
It will be better to upgrade to VFP8.0/9.0 and to use CursorAdapter class, which will let you to use as SQLServer aswell DBFs.
You should REMOVE all USE commands from your code.
You will need to change your cursor objects in the forms' Data Environment with CA instances.
(It is good practice to create your own underlaying CA class and to use it further in the application. In this way you will be ableto control data access by only changinf settings of this base class.)
Keep in mind that writting select commands to retrieve data, you must comform T-SQL syntax and you cannot use VFP functions.
You can visit
GermanDevCon after a month and to take a few session in English about this :-)