Wait for update to finish before refresh...

[bugzy]

Hi,

My application sends an update to the database then does the refresh of the data, the problem is for users in a remote location, the refresh hits the database before the update does... what is the best way to solve this???

Thanks.

 

[chiph]

How are you doing the update? Bound objects, or SQL Command objects?

Chip H.


____________________________________________________________________
If you want to get the best response to a question, please read FAQ222-2244 first

 

[bugzy]

SQL Command

 

[chiph]

If the update and the select are both using the same connection object, this shouldn't happen, as the commands are serialized per connection to preserve order.

You can see this is so by adding a new row to a table that uses an Indentity column, and issuing a Select to return the new value. If they happened out of order the Select would fail.

Chip H.


____________________________________________________________________
If you want to get the best response to a question, please read FAQ222-2244 first