Subject | Re: [IBO] BDE to IBO |
---|---|
Author | Dmitry Beloshistov |
Post date | 2004-04-22T06:34:14Z |
Hello, peterchubby!
You wrote to <IBObjects@yahoogroups.com> on Thu, 22 Apr 2004 06:17:31 -0000:
p> Problem:- I update a TDBEdit, which in turn Starts a Transaction,
p> Executes a StoredProc and Commits, then closes and reopen the Query -
p> but the data does not refresh.
Hmm... May be this can help you:
Query.IB_Transaction.StartTransaction; // query transaction
//----
StartTransaction; // for stored proc
StoredProc.Execute;
Commit; // for stored proc transaction
//----
Query.IB_Transaction.Refresh(True); // <--- !!!!
Query.Refresh;
WBR, Dmitry Beloshistov AKA [-=BDS=-]
You wrote to <IBObjects@yahoogroups.com> on Thu, 22 Apr 2004 06:17:31 -0000:
p> Problem:- I update a TDBEdit, which in turn Starts a Transaction,
p> Executes a StoredProc and Commits, then closes and reopen the Query -
p> but the data does not refresh.
Hmm... May be this can help you:
Query.IB_Transaction.StartTransaction; // query transaction
//----
StartTransaction; // for stored proc
StoredProc.Execute;
Commit; // for stored proc transaction
//----
Query.IB_Transaction.Refresh(True); // <--- !!!!
Query.Refresh;
WBR, Dmitry Beloshistov AKA [-=BDS=-]