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
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 ?

Sign In or Register to comment.

Howdy, Stranger!

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