Hi,

We have an existing system which was developed in traditional native foxpro syntax, Appending, deleting and modifying records.

I created a system to that will serve as a tool to modify certain records in the old system. I used sqlpassthrough commands to query a certain table. The problem is if a user added a record in the old system, the query in the new system does not include the latest record that was created in the old system.

I discovered that by closing the new system and reopening it again then executing the query will then have the correct set of data or records needed.

Is there a way on how to refresh the DSN connection? programmatically?