🚀 go-pugleaf

Method 1:
on the server side
Query->SQL="select * from Table1 where (0=:chk1 or (1=:chk1 and
Field1=:Field1))
and (0=:chk2 or (1=:chk2 and Field2=:Field2)) ..."

Method 2:
on the Server side
TDataSetProvider->Options->poAllowCommandText=true;
On the Client Side
TClientDataSet->CommandText="Select * from Table1 where....."

In fact I have phoned to Borland HK Limited , they claim that Borland give
up to develop SocketServer now
so, no further support in mult-tier,
they advance us to use .NET now
It make me very very angry!!!!!!!


"billaras" <billaras1234@hotmail.com> д���ʼ�
news:41db4890@newsgroups.borland.com...
> HI ALL,I AM WORKING ON A PROJECT ..WELL HERE IT GOES...
> I MUST USE BORLAND C++ BUILDER TO CREATE A SERVER/CLIENT APPLICATION TO
> ACCESS A DATABASE...SO WE HAVE 2 PCs .ON THE FIRST WE RUN SQL SERVER 2000
> AND A SERVER APPLICATION CREATED WITH BUILDER USING DATASNAP WITH ADO
> CONNECTION.ON THE SECOND WE HAVE A CLIENT APPLICATION .I CAN EASILY TAKE
> DATASETS USING CLIENTDATASET-DATASETPROVIDER BUT THERE IS THE BIG
> PROBLEM....I WANT TO CREATE A QUERY ON A TABLE FROM THE CLIENT
> APPLICATION...HOW WILL I CONNECT THE QUERY WITH THE..(I DONT KNOW
WHAT).HOW
> CAN I PERFORM DYNAMIC QUERIES SO I CAN RETRIEVE SPECIFIC DATA ALWAYS
> DYNAMIC!IS THERE A WAY DOING THAT?THANK YOU ALL IN ADVANCE FOR YOUR HELP
>
>