Subject | RE: [IBO] Locking rows |
---|---|
Author | Riho-Rene Ellermaa |
Post date | 2004-02-20T09:05:19Z |
//----------------------------------------------------------------------
-----
//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]
-----
//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]