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