Subject RE: [IBO] Locking rows
Author Riho-Rene Ellermaa
//----------------------------------------------------------------------
-----
//QMaster query Before Open event.
void __fastcall TConvDM::QMasterBeforeOpen(TIB_Dataset *IB_Dataset)
{
TDataModule2::QMasterBeforeOpen(IB_Dataset);
//SQL to lock updatabale record
IB_Dataset->LockSQL->Clear();
IB_Dataset->LockSQL->Add("update CONVERSION set CURRENCY=CURRENCY where
ID=:OLD_ID ");//notr
}



Riho Ellermaa




_____

From: skander_sp [mailto:skander@...]
Sent: Thursday, February 19, 2004 7:15 PM
To: IBObjects@yahoogroups.com
Subject: [IBO] Locking rows


May be a begginer question, but...

what it's the most prefered way to "autolock" a record in IBO to
not
let another user edit while is editing?

what component? what property?

Tks




________________________________________________________________________
___
IB Objects - direct, complete, custom connectivity to Firebird
or InterBase
without the need for BDE, ODBC or any other layer.

________________________________________________________________________
___
http://www.ibobjects.com - your IBO community resource for Tech
Info papers,
keyword-searchable FAQ, community code contributions and more !




_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/IBObjects/

* To unsubscribe from this group, send an email to:
IBObjects-unsubscribe@yahoogroups.com
<mailto:IBObjects-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms
of Service <http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]