We have a medium sized application that was a Fox 2.x converted to VFP, now on verion 6. We are considering consolidating the 40 remote sites into a single central site that would be accessed with Citrix.

My immediate thought is my manager's desire to replace the VFP free tables with SQL Server. Because we are an old Fox application we have many BROWSE windows, GO TOP, SKIP, SCAN, SEEK, SCATTER, GATHER, embedded in the code. We do not go to a central routine for any table handling. How much of this would have to change?? Are all the Fox table handling commands not recognized in SQL Server? Rarly do we use an SQL statement, except for creating cursors used in the reporting. In the forms we use the old Fox commands to populate the forms and update the tables.

Any thoughts are appreciated.

Brenda