General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Update SQL table from VFP table
Environment versions
Network:
Windows 2003 Server
Looking for a little bit of best practices, and a little bit of how to.
I need to update a SQL Server table with values from a VFP table.
Should I upload the VFP table to a temporary SQL cursor and SQLEXEC the update statement? How would upload the cursor and remove it when done?
Or should I download the SQL table to a VFP cursor,run the UPDATE statement in VFP, and post the results back to SQL? How would I post the updates back to SQL?
I know how to do this by SCANning the VFP table and updating a single record at a time, but I would prefer to avoid that overhead.
Chris.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only