Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP SQL vs SQL server
Message
From
18/10/2001 14:45:54
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
VFP SQL vs SQL server
Miscellaneous
Thread ID:
00570446
Message ID:
00570446
Views:
60
I'm currently using VFP database, but would like to convert to SQL server soon. I do a lot of coding using the VFP SQL statements. Will I need to change these VFP SQL statements to be useable for SQL server database? How should I code database access now in VFP using VFP databases so that when I am ready to convert, not much code change is needed?

Here is a sample of my VFP select statement as I have it now (with VFP table):
SELECT * FROM table1 WHERE field1='DONE'

How would this be changed to work with SQL server table?
Thank you all!
Next
Reply
Map
View

Click here to load this message in the networking platform