Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

Advice on how to handle Queries between SOAP client and server

Avatar of rfwoolf
rfwoolfFlag for South Africa asked on
Delphi
4 Comments1 Solution684 ViewsLast Modified:
I am converting an existing client-server app into a SOAP client-server app.
The old app has a bunch of TADOQuerys.
So I found a way of replacing each TADOQuery on the CLIENT with a TClientDataSet and TSoapConnection
and getting it to fetch records from a TClientDataSet and TDataSetProvider on the SERVER.

But the problem comes in with 2 things:
1: I need a way to execute dynamic 'once-off' queries where I supply the SQL in my CLIENT, it gets executed on the SOAP Server side, and somehow on my client I get back the result set in a dataset. I tried to think this through but came into some hitches so it would be good if a pro could assist on this.

2: I think it would be crazy to create a TClientDataSet (and TDataSetProvider) in the *SERVER* SOAP data module for every TADOQuery in my *CLIENT* app because that wouldn't be good practise -- I should only be creating the 'standard' queries that clients would want to use, and for everything else using dynamic queries. Or should I do all?
ASKER CERTIFIED SOLUTION
Avatar of aflarin
Commented:
This problem has been solved!
Unlock 1 Answer and 4 Comments.
See Answers