General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Freeze during requery
I have the following problem:
I have a remote view to SQL Server Database. This view works syncronously.
I have a second Connection used to execute commands via SPT. This second connection works asyncronously.
I have the view loaded with a set of records from the database.
I execute an asyncronous update via the SPT connection to a column in the same records.
During the asyncronous execution I issue a requery() on the remote view to reload these same records.
This requery() totally freezes indefenitely VFP. Only way out: end process
The asyncronous update is not completed in the server until i quit the vfp process.
Any clue ?
Thanks.
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