Flemming
February 8th, 2000, 10:28 AM
My problem is: How do I put values into parameterfields of an sql-statement in a child command in a Data Environment at run-time.
I'm trying to fight my way through my first attempt with DataEnvironment and a Data Report. I'm using Jet 4.0.
In the DataEnvironment I have created a command called 'Group' with a child command called 'Detail' referring two different tables.
In both commands I have typed in Select-statements with questionmarks (?) in the Where-clauses.
At run-time I can assign values to the 'Group'-command by this line of code: Dataenvironment1.Group (intGroupId)
How do I do something similar with parameters for my child-command 'Detail'?
(Everything works perfect if I have hard-coded values in my select-statement's.)
Flemming
I'm trying to fight my way through my first attempt with DataEnvironment and a Data Report. I'm using Jet 4.0.
In the DataEnvironment I have created a command called 'Group' with a child command called 'Detail' referring two different tables.
In both commands I have typed in Select-statements with questionmarks (?) in the Where-clauses.
At run-time I can assign values to the 'Group'-command by this line of code: Dataenvironment1.Group (intGroupId)
How do I do something similar with parameters for my child-command 'Detail'?
(Everything works perfect if I have hard-coded values in my select-statement's.)
Flemming