Page 1 of 1

lock record on server when uniquery.localupdate =true ?

Posted: Fri 14 Aug 2009 14:28
by mvictor
Hi!

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;
so should be?
thanks.

Posted: Mon 17 Aug 2009 07:08
by Plash
Set the LockMode property of TUniQuery to lmNone. In this case locking should not be performed.