Article View: borland.public.cppbuilder.database.ado
Article #4137Re: Stack Overflow problem when Creating Recordset through ADOConnection.
From: Vassiliev V.V.
Date: Mon, 25 Mar 2002 07:54
Date: Mon, 25 Mar 2002 07:54
54 lines
2475 bytes
2475 bytes
Try remove eoAsyncExecute - if you want to execute asyncronous, then you
cycle should be executed only when all records are fetched.
Regards,
Vassiliev V.V.
http://www.oledbdirect.com
"Johnnie Lann" <mortalpain@mortalpain.net> �������/�������� � ��������
���������: news:3c9c9a99_2@dnews...
> hi all
>
> as title I create recordset through TADOConnection.
>
> No Error, Warning.
>
> But wow there is Stack overflow problem.
>
> problem code is following this.
>
> objConn->CursorLocation = clUseClient;
> objRsTitles->Recordset = objConn->Execute(WideString("select * from
> titles"),
> cmdText,
> TExecuteOptions() <<
> eoAsyncExecute);
>
> while (!objRsTitles->Eof)
> {
> Ls->Items->Add(objRsTitles->FieldByName("title_id")->AsString);
> objRsTitles->Next();
> }
>
> I don't know what problem is. help me.
>
> And then
>
> if above code is
>
> while (!objRsTitles->Recordset->Eof)
> {
> Ls->Items->Add(objRsTitles->FieldByName("title_id")->AsString);
> // I Suppose this is wrong. but How do I retrieve data of field and
> append it in listbox?
> objRsTitles->Recordset->MoveNext();
> }
>
> ,
>
> How Ls->Items->Add(objRsTitles->FieldByName("title_id")->AsString); does
> change?
>
> Nice Programming and All Happiness~
>
>
Technical Details
Message-ID:
<3c9edd8f_2@dnews>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!supernews.com!telocity-west!TELOCITY!hub1.nntpserver.com!xmission!news-hog.berkeley.edu!ucberkeley!nntp-relay.ihug.net!out.nntp.be!propagator-SanJose!in.nntp.be!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnewsReferences:
<3c9c9a99_2@dnews>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII X-Google-Thread: 10698b,56f076f7e286e9cc X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2002-03-25 00:27:30 PST From: "Vassiliev V.V." <vv_vas@iname.com> Newsgroups: borland.public.cppbuilder.database.ado References: <3c9c9a99_2@dnews> Subject: Re: Stack Overflow problem when Creating Recordset through ADOConnection. Date: Mon, 25 Mar 2002 10:54:06 +0300 Lines: 56 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 NNTP-Posting-Host: 62.118.131.32 Message-ID: <3c9edd8f_2@dnews> X-Trace: dnews 1017044367 62.118.131.32 (25 Mar 2002 00:19:27 -0800) Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!supernews.com!telocity-west!TELOCITY!hub1.nntpserver.com!xmission!news-hog.berkeley.edu!ucberkeley!nntp-relay.ihug.net!out.nntp.be!propagator-SanJose!in.nntp.be!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews