Click to See Complete Forum and Search --> : How to pass parameter to a ADODC.Command


July 20th, 1999, 11:03 AM
I'm using Data Environment to develop my application. In doing some reports, i have to pass parameters to a Commnad object, so that i can specific the range of report. How can i do that ???

Lothar Haensler
July 20th, 1999, 11:09 AM
let's assume that you have created Command1 based on an SQL statement like "select * from Application where path = ?".
Then, when you execute that command, you write
DataEnvironment1.Command1 "your param goes here"

i.e. you just call your command as if it were a method of the Dataenvironment object and pass the parameters as in any other method call.

July 21st, 1999, 05:34 AM
I still don't understand. Can you give me a small example ?? Besides, I now, i don't have to do a DataEnvironment.Command1.xxxxx directly. I only do a rptProductionList.Show ( rptProductionList is the datareport ), so how can i pass the parameters ???