David,
You may want to open the connection at the beginning and leave it open the whole time, just making the updates as needed.
Another possibility is to write to a holding file and update in batch mode later, if, of course, it fits with your needs.
>before I take the dive.
>
>I need to update a SQL 7 database with the same information from a FoxPro form that updates a FoxPro database. Look at it as a replication effort.
>
>My strategy is to use SQL passthru to open up a connection, and add a record to the SQL database behind the scenes, so the user is not aware of this extra update.
>
>The question I have is what do I do in the case of an update? It's not like I can SEEK and REPLACE here. Any ideas?
>
>DP
Previous
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