Re: Query problem - > how to catch raw query results - Article 852 - go-pugleaf

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

Article #852

Back to borland.public.cppbuilder.database.multi-tier Previous Next

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

#852

From: Jerry Bloomfield (TeamB)
Date: Fri, 26 Jan 2001 02:35

30 lines
1824 bytes

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: <jco17tsielgrlshtk95v43mgcf2dmhea6j@4ax.com>

Path:

arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!isdnet!fr.clara.net!heighliner.fr.clara.net!nntp1.njy.teleglobe.net!teleglobe.net!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!bornews.borland.com!not-for-mail

References: <94h6ol$aba8@bornews.inprise.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-25 18:37:17 PST
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!isdnet!fr.clara.net!heighliner.fr.clara.net!nntp1.njy.teleglobe.net!teleglobe.net!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!bornews.borland.com!not-for-mail
From: "Jerry Bloomfield (TeamB)" <JersWork@wwa.com>
Newsgroups: borland.public.cppbuilder.database.multi-tier
Subject: Re: Query problem - > how to catch raw query results
Date: Thu, 25 Jan 2001 20:35:35 -0600
Organization: LSVFA - Latest Software Version Freaks Anonomous
Lines: 30
Message-ID: <jco17tsielgrlshtk95v43mgcf2dmhea6j@4ax.com>
References: <94h6ol$aba8@bornews.inprise.com>
NNTP-Posting-Host: 157.238.74.124
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Newsreader: Forte Agent 1.8/32.548

Reply to Parent Message