Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

TQuery.Refresh

W2LDW2LD Member Posts: 1
How to execute TQuery.Refresh to refresh Single record ?

In case I have query that return a result-set :

select m.PrimaryKey, m.Status, m.Other_Fields
from mytable m
where
m.Status = :Status

Before edit a record, I should cek the status field whenever that record can edited or not, so I need to refresh the value in case other user change it.

I can't close and open the query because the result-set may not be same as previous result.
If I using TIBQuery, I can implement Refresh Query using TIBUpdateSQL, then how to implement in TQuery-TUpdateSQL ?

TIA,
Agus
Sign In or Register to comment.