this code is lock record on server (firebird)
Code: Select all
myuniquery.localupdate:=true;
myuniquery.sql.clear;
myuniquery.sql.add('select *, cast(0 as integer) as add_fld from table1');
myuniquery.open;
myuniquery.fieldbyname('add_fld').readonly:=false;
myuniquery.edit;
myuniquery.fieldbyname('add_fld').value:=1;
myuniquery.post;
thanks.