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?