TIBQuery Open

Thread View: borland.public.cppbuilder.database.dbexpress

3 messages

[T] Back to Threads [V] Tree View [G] Group Articles

3 total messages Started by Julian Lliteras Thu, 23 Sep 2004 11:37

#108

Author: Julian Lliteras
Date: Thu, 23 Sep 2004 11:37

18 lines
1438 bytes

Hi,

 I've a form with a TIBQuery and TDataSource linked to a TDBGrid.

 In OnShow event of the form there are
    * TIBQuery->SQL->Clear();
    * TIBQuery->SQL->Insert(0,'select....');
    * TIBQuery->Open();
In OnClose event of the form:
    * TIBQuery->Close();

When I open the form the first time, I saw all data correctly. But with
IBConsole also running , I insert news records to verify that form refreshed
data ok, but the form didn't. I must exit application and run again to full
refresh data. Did Open method not refresh data at runtime? I thought that
closing and reopening queries did.

Thanks.

Re: TIBQuery Open

#109

Author: Yoann chaigneau
Date: Thu, 07 Oct 2004 10:47

34 lines
1873 bytes

Hi julian,

I had exactly the same problem and the solution was int the parameters of
the transaction used. I don't remenber exactly wich parameter to change in
the transaction but look at the isolation level.

Good luck.



"Julian Lliteras" <yartax@hotmail.com> a �crit dans le message de
news:4152b586@newsgroups.borland.com...
> Hi,
>
>  I've a form with a TIBQuery and TDataSource linked to a TDBGrid.
>
>  In OnShow event of the form there are
>     * TIBQuery->SQL->Clear();
>     * TIBQuery->SQL->Insert(0,'select....');
>     * TIBQuery->Open();
> In OnClose event of the form:
>     * TIBQuery->Close();
>
> When I open the form the first time, I saw all data correctly. But with
> IBConsole also running , I insert news records to verify that form
refreshed
> data ok, but the form didn't. I must exit application and run again to
full
> refresh data. Did Open method not refresh data at runtime? I thought that
> closing and reopening queries did.
>
> Thanks.
>
>

Re: TIBQuery Open

#112

Author: Richard L.
Date: Tue, 19 Oct 2004 16:19

7 lines
1187 bytes

Hi Julian,

Set the (TIB)Transaction property AutoStopAction to saCommit. By default 
it's saNone leaving the transaction active, even after closing the Query.


Richard

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads