Print Thread
TParams in ClientDataSet
#1721 02/26/01 11:54 PM
Joined: Feb 2001
Posts: 15
Atlanta, GA, USA
M
mwlang Offline OP
Member
OP Offline
Member
M
Joined: Feb 2001
Posts: 15
Atlanta, GA, USA
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?

Re: TParams in ClientDataSet
#1722 02/28/01 08:41 PM
Joined: Aug 1999
Posts: 22,217
Member
Offline
Member
Joined: Aug 1999
Posts: 22,217
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


Marco Kalter
Allround Automations
Re: TParams in ClientDataSet
#1723 03/01/01 01:45 AM
Joined: Feb 2001
Posts: 15
Atlanta, GA, USA
M
mwlang Offline OP
Member
OP Offline
Member
M
Joined: Feb 2001
Posts: 15
Atlanta, GA, USA
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.


Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.025s Queries: 13 (0.007s) Memory: 2.5030 MB (Peak: 3.0421 MB) Data Comp: Off Server Time: 2024-05-14 05:56:59 UTC
Valid HTML 5 and Valid CSS