Issuing a SQL->Text in a multi tier app

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 Rocky Castaneda Wed, 09 Oct 2002 07:18

#286

Author: Rocky Castaneda
Date: Wed, 09 Oct 2002 07:18

17 lines
1304 bytes

Hi All,

Is there a way by which we can issue SQL Statements to a ClientDataSet?

ie. . .

ClientDataSet1->Close();
ClientDataSet1->CommandText = "select * from WhateverTable";
ClientDataSet1->Open();

Is this thing possible on a multi tier application.

if Yes, how? if No, any workaround?

Thanks in advance,

-rocky

Re: Issuing a SQL->Text in a multi tier app

#287

Author: vavan
Date: Thu, 10 Oct 2002 06:10

19 lines
1518 bytes

On Wed, 9 Oct 2002 15:18:50 +0800, "Rocky Castaneda"
<rcastaneda@ecommsite.com> wrote:

>Is there a way by which we can issue SQL Statements to a ClientDataSet?
>
>ie. . .
>
>ClientDataSet1->Close();
>ClientDataSet1->CommandText = "select * from WhateverTable";
>ClientDataSet1->Open();
>
>Is this thing possible on a multi tier application.
>
>if Yes, how? if No, any workaround?

Yes, it is possible just exactly as you wrote above

--
Vladimir Ulchenko aka vavan

Re: Issuing a SQL->Text in a multi tier app

#288

Author: Rocky Castaneda
Date: Thu, 10 Oct 2002 08:32

41 lines
2143 bytes

Hi Max,

I got it!!!!

I was able to display the result of my SQL Command Text =).

I just have another question though, Whenever I delete a record from one
client, the other client would not be able to see the changes.

This means that the record deleted is still visible on the other client even
if I click a button on the client program that would open/close just to
refresh the result set.

The update would only reflect when I terminate the program and run it again.

Thanks in advance,

-rocky

"vavan" <vavan@santel.ru> wrote in message
news:jd6aqu8elmtqnsjq5ldiikop1np6ge9vav@4ax.com...
> On Wed, 9 Oct 2002 15:18:50 +0800, "Rocky Castaneda"
> <rcastaneda@ecommsite.com> wrote:
>
> >Is there a way by which we can issue SQL Statements to a ClientDataSet?
> >
> >ie. . .
> >
> >ClientDataSet1->Close();
> >ClientDataSet1->CommandText = "select * from WhateverTable";
> >ClientDataSet1->Open();
> >
> >Is this thing possible on a multi tier application.
> >
> >if Yes, how? if No, any workaround?
>
> Yes, it is possible just exactly as you wrote above
>
> --
> Vladimir Ulchenko aka vavan

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