RecordCount

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

3 messages

[T] Back to Threads [V] Tree View [G] Group Articles

3 total messages Started by Armands Gzibovskis Mon, 04 Oct 1999 00:00

#1565

Author: Armands Gzibovskis
Date: Mon, 04 Oct 1999 00:00

6 lines
665 bytes

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.

Re: RecordCount

#1566

Author: 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;

Re: RecordCount

#1568

Author: Armands Gzibovskis
Date: Wed, 06 Oct 1999 00:00

30 lines
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;

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads