🚀 go-pugleaf

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