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 ?