Article View: borland.public.cppbuilder.database.ado
Article #749Re: AdoQuery refresh
From: Yifei
Date: Mon, 04 Apr 2005 05:50
Date: Mon, 04 Apr 2005 05:50
70 lines
3555 bytes
3555 bytes
Yes you can download the MDAC and the JET4.0 SP8 from the website of
Microsoft.
Try it.
"Viatcheslav V. Vassiliev" <support@oledbdirect.com> д���ʼ�
news:4162957e$1@newsgroups.borland.com...
> Access uses lazy writes and waits some seconds (5 sec.) before flush data
> onto disk. But if ADOQuery is connected to the same TADOConnection and
> connection is not re-opened, you should see changes. Try to install latest
> Jet SP from http://www.microsoft.com/downloads .
>
> //------------------------------------------
> Regards,
> Vassiliev V. V.
> http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
> ADO.Net
> http://www.oledbdirect.com - The fastest way to access MS SQL Server,
> MS Jet (Access) and Interbase (through OLEDB)
>
> "Chri" <chrip@libero.it> ������?�������� ?�������� ��������?
> news:41628ad0@newsgroups.borland.com...
> > I use an Access database... i tried with TADOConnection without
> > improvements!
> >
> > "Viatcheslav V. Vassiliev" <support@oledbdirect.com> ha scritto nel
> > messaggio news:41627996$1@newsgroups.borland.com...
> > > What is your DBMS? Are you on server-side or client-side cursor?
> > >
> > > If you set ConnectionString, try to use TADOConnection.
> > >
> > > //------------------------------------------
> > > Regards,
> > > Vassiliev V. V.
> > > http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
> > > ADO.Net
> > > http://www.oledbdirect.com - The fastest way to access MS SQL Server,
> > > MS Jet (Access) and Interbase (through OLEDB)
> > >
> > > "Chri" <chrip@libero.it> ������?�������� ?�������� ��������?
> > > news:41624583@newsgroups.borland.com...
> > > > I've a problem with AdoQuery component taht is, if i have ADOQuery
the
> > > > component in my form:
> > > >
> > > > TADOQuery* pAdoQuery = (TADOQuery*) ADOQuery;
> > > > pAdoQuery->Close();
> > > > pAdoQuery->SQL->Clear();
> > > > pAdoQuery->SQL->Add("SELECT ...");
> > > > pAdoQuery->Open();
> > > >
> > > > pAdoQuery->Append();
> > > > pAdoQuery->FieldValues[".."] = ...;
> > > > pAdoQuery->Post();
> > > >
> > > > if i try to se immediatly the result of the append it doesn't work:
> > > > pAdoQuery->Close();
> > > > pAdoQuery->SQL->Clear();
> > > > pAdoQuery->SQL->Add("SELECT ...");
> > > > pAdoQuery->Open();
> > > >
> > > > it works only if i wait some seconds....!?!?!?!
> > > > How can i force the ADOQuery to store immedialtly the data?
> > > > Thanks, Chri.
> > > >
> > > >
> > >
> > >
> >
> >
>
>
Technical Details
Message-ID:
<4250d5b7$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mailReferences:
<41624583@newsgroups.borland.com> <41627996$1@newsgroups.borland.com> <41628ad0@newsgroups.borland.com> <4162957e$1@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Thread: 10698b,3b36c2cc94944aff X-Google-Attributes: gid10698b,public X-Google-Language: ENGLISH,ASCII From: "Yifei" <yinjiajun@gmail.com> Newsgroups: borland.public.cppbuilder.database.ado References: <41624583@newsgroups.borland.com> <41627996$1@newsgroups.borland.com> <41628ad0@newsgroups.borland.com> <4162957e$1@newsgroups.borland.com> Subject: Re: AdoQuery refresh Date: Mon, 4 Apr 2005 13:50:53 +0800 Lines: 72 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1437 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 NNTP-Posting-Host: 211.162.16.109 Message-ID: <4250d5b7$1@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1112593847 211.162.16.109 (3 Apr 2005 22:50:47 -0800) Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail