Re: How to get the result "select count(*) from ..."

Article View: borland.public.cppbuilder.database.ado

Article #3565

Back to borland.public.cppbuilder.database.ado Previous Next

#3565

From: Frost Sheila
Date: Wed, 10 Jul 2002 15:53

18 lines
1483 bytes

Hallo,

the fields in an live dataset are editable.
since you arent going to change the recordcount directly, the Request 
live option  of TQuery's isnt needed.

try:
TQuery->SQL->Text = "select i_reakt,count( * ) as reakCount from 
T_Output group by i_Reakt";
TQuery->requestLive = false;
TQuery->Open();
while( ! TQuery->Eof ){
	Memo1->Lines->Add( TQuery->FieldByName("i_reakt")->AsString
		+ "-" + TQuery->FieldByName("reakCount")->AsString );
}
TQuery->Close();

Frosty

Technical Details

Message-ID: <3D2C586D.4030206@gmx.de>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-05!sn-xit-01!sn-xit-08!supernews.com!priapus.visi.com!news-out.visi.com!hermes.visi.com!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnews

References: <3d2c4602_1@dnews>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,bcad3e0669853dd8
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2002-07-10 10:21:09 PST
Message-ID: <3D2C586D.4030206@gmx.de>
Date: Wed, 10 Jul 2002 17:53:17 +0200
From: Frost Sheila <OldMaster@gmx.de>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.1a) Gecko/20020611
X-Accept-Language: en-us, zh, zh-cn, zh-tw, ja, ko
MIME-Version: 1.0
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Re: How to get the result "select count(*) from ..."
References: <3d2c4602_1@dnews>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 213.23.64.48
X-Trace: dnews 1026316486 213.23.64.48 (10 Jul 2002 08:54:46 -0700)
Lines: 19
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-05!sn-xit-01!sn-xit-08!supernews.com!priapus.visi.com!news-out.visi.com!hermes.visi.com!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnews

Reply to Parent Message