>I'm preparing to do anapp coversion where I will convert from DBF to SQL Server and begin using SqlExec(). I have lots of SQL strings in my app already that run fine against local DBF tables, so I'm wanting to see if there is a list somewehere or if you can give me advice on what syntax and stuff that works fine on DBF, but that will need to be modified to run on SQL server. This way I can scan my SQL strings and look for areas that I need to change.
Any reason you want to use SQLEXEC() instead of remote views? Might want to consider this approach:
1. Make all your DBF tables SQL compaitable (i.e., no date fields, no time fiels, just datetime fields). If you do this properly the the tables should be able to be upsized to SQL with zero modifications.
2. Create anothor DBC. This DBC will hold only remote views and a connection string.
3. Now, make your application use nothing but remote views. Initially your remote views will point to the DBC that has your VFP tables.
4. When that's all done, all you have to do is upsize the VFP tables to SQL, and change the connection string in the DBC with the remote views to point to the SQL Server instead of the VFP DBC with the tables.
The beauty of this is you can switch between VFP and SQL anytime you want just by changing one connection string in your remote-views DBC.
I've used this approach quite a few times ......
ICQ 10556 (ya), 254117