🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: RecordCount

#1566
From: Ingo Oellers
Date: Tue, 05 Oct 1999 00:00
19 lines
1047 bytes
Armands Gzibovskis schrieb:
> 
> Is it possible to get RecordCount from server application through IProvider.
> I'm interested in not to write a method on to sever.
> 
> Thank you!
> 
> Armands.

Send a simple TQuery to the server 

Query1->Close(),
Query1->SQL->Clear();
Query1->SQL->Add("SELECT COUNT(*) AS RecordCount FROM TheTable");


int recordcount;
Query1->Open();
recordcount = Query1->FieldByName("RecordCount")->AsInteger;
Technical Details
Message-ID: <37FA0B6D.6531E144@plum.de>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail
References: <7t9oav$ahf5@forums.borland.com>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: fcd2b,9015cb93300d8baf
X-Google-Attributes: gidfcd2b,public
From: Ingo Oellers <io@plum.de>
Subject: Re: RecordCount
Date: 1999/10/05
Message-ID: <37FA0B6D.6531E144@plum.de>
X-Deja-AN: 533087184
Content-Transfer-Encoding: 7bit
References: <7t9oav$ahf5@forums.borland.com>
To: Armands Gzibovskis <armands.gzibovskis@isc.ldz.lv>
X-Accept-Language: de
Content-Type: text/plain; charset=us-ascii
Organization: Another Netscape Collabra Server User
Mime-Version: 1.0
Newsgroups: borland.public.cppbuilder.database.multi-tier