TParams in ClientDataSet

[mwlang]

Am I missing a step with populating a TOracleDataSet's variables on an AppServer from a TClientDataSet's Params property?

The TQuery automatically populated it's Params with whatever was populated in the TClientDataSet, but switching over to the TOracleDataset is complaining that all variables were not set.

What's the trick?

 

[Marco Kalter]

In Delphi 4 you have to make sure that the Variables on the server match the Params on the client. In Delphi 5 you can declare the Params on the client and automatically get the corresponding Variables declared on the server, or vice versa.

------------------
Marco Kalter
Allround Automations

 

[mwlang]

It took me a bit to figure that out...I've just gotten too used to the TQuery component auto-generating the Params whenever you type an SQL statement with binding variables in it. With the OracleDataSets, I have learned to make a series of DeclareVariable calls following assigning SQL text to the component and, as you pointed out, this solved the problem.