🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.cppbuilder.database.multi-tier
Article #853

Re: Query problem - > how to catch raw query results

#853
From: Jan
Date: Fri, 26 Jan 2001 11:34
40 lines
2048 bytes
Yep, you're right, now everything workes fine with displaying query
results...

THX a lot,

Jan


Jerry Bloomfield (TeamB) schrieb in Nachricht ...
>On Mon, 22 Jan 2001 12:46:25 -0000, "Jan" <J.Pielhau@alphasoft-gmbh.de>
>wrote:
>
>>We do a query on a Sybase 6 .0 DB with the TQuery Component. Now we'd like
>>to display the result of the query in an Edit or Memo field. The only way
we
>>saw is using a grid...:-((
>>So we need to know how to catch the "raw - result" of the query.
>>THX for helping me
>
>Are you asking for something like:
>
>Query1->Open();
>
>Query1->First();
>while ( ! Query1->Eof )
>{
>    int f1 = Query1->FieldByName("FieldOne")->AsInteger;
> ...
>
> Query1->Next();
>}
>
>Which will allow you to move through each row of the results set and access
>the returned fields?
>
>Jerry Bloomfield (TeamB)
>--
>http://www.teamb.com                                      JersWork@wwa.com
>Please do *NOT* send private e-mail without prior permission (my anti-spam
>filters will probably just delete it anyway <g>)
Technical Details
Message-ID: <94rk11$34h1@bornews.inprise.com>
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!nntp-relay.ihug.net!ihug.co.nz!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!newsfeeds.belnet.be!naxos.belnet.be!news.belnet.be!bornews.borland.com!not-for-mail
References: <94h6ol$aba8@bornews.inprise.com> <jco17tsielgrlshtk95v43mgcf2dmhea6j@4ax.com>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: fcd2b,889449d07cdcaf9d
X-Google-Attributes: gidfcd2b,public
X-Google-ArrivalTime: 2001-01-26 02:40:07 PST
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!nntp-relay.ihug.net!ihug.co.nz!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!newsfeeds.belnet.be!naxos.belnet.be!news.belnet.be!bornews.borland.com!not-for-mail
From: "Jan" <J.Pielhau@alphasoft-gmbh.de>
Newsgroups: borland.public.cppbuilder.database.multi-tier
Subject: Re: Query problem - > how to catch raw query results
Date: Fri, 26 Jan 2001 11:34:12 -0000
Organization: Another Netscape Collabra Server User
Lines: 42
Message-ID: <94rk11$34h1@bornews.inprise.com>
References: <94h6ol$aba8@bornews.inprise.com> <jco17tsielgrlshtk95v43mgcf2dmhea6j@4ax.com>
NNTP-Posting-Host: dialin135-95.c7140-nt.frankfurt.nikoma.de
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3