Article View: borland.public.cppbuilder.database.multi-tier
Article #1568Re: RecordCount
From: Armands Gzibovskis
Date: Wed, 06 Oct 1999 00:00
Date: Wed, 06 Oct 1999 00:00
30 lines
1440 bytes
1440 bytes
Ok! It's nice, but I need it to write a component. And I want to connect to
server only through MIDAS. And if I write method on application server then
my component will be dependant from application server. May be anybody know
the tactics how to owerwrite Provider?
Thank you!
Armands.
Ingo Oellers <io@plum.de> wrote in message news:37FA0B6D.6531E144@plum.de...
> 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:
<7tep0s$nja1@forums.borland.com>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<7t9oav$ahf5@forums.borland.com> <37FA0B6D.6531E144@plum.de>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: fcd2b,9015cb93300d8baf X-Google-Attributes: gidfcd2b,public From: "Armands Gzibovskis" <armands.gzibovskis@isc.ldz.lv> Subject: Re: RecordCount Date: 1999/10/06 Message-ID: <7tep0s$nja1@forums.borland.com> X-Deja-AN: 533376775 References: <7t9oav$ahf5@forums.borland.com> <37FA0B6D.6531E144@plum.de> X-Priority: 3 X-Mimeole: Produced By Microsoft MimeOLE V5.00.2314.1300 Organization: Another Netscape Collabra Server User X-MSMail-Priority: Normal Newsgroups: borland.public.cppbuilder.database.multi-tier