πŸš€ go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.cppbuilder.database.dbexpress
Article #109

Re: TIBQuery Open

#109
From: 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.
>
>
Technical Details
Message-ID: <41651e8e$1@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail
References: <4152b586@newsgroups.borland.com>

Show Full Headers
Complete Article Headers
X-Google-Thread: fb4e2,895a28869e6cacef
X-Google-Attributes: gidfb4e2,public
X-Google-Language: ENGLISH,ASCII
From: "Yoann chaigneau" <yoann.chaigneau@statigest.fr>
Newsgroups: borland.public.cppbuilder.database.dbexpress
References: <4152b586@newsgroups.borland.com>
Subject: Re: TIBQuery Open
Date: Thu, 7 Oct 2004 12:47:53 +0200
Lines: 36
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1409
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
NNTP-Posting-Host: 195.68.33.211
Message-ID: <41651e8e$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1097145998 195.68.33.211 (7 Oct 2004 03:46:38 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail