Visual Basic&database, Changing SQL in a child command at run time

Changing SQL in a child command at run time

Author	Message
Matthew Robinso #1 / 3	Changing SQL in a child command at run time Is it possible to change the SQL of a child command at run time? I have a command in the Data Environment called rsBranch, with a child command called rsVehicles. I can access DataEnvironment.rsBranch, but I cannot access DataEnvironment.rsVehicles. If there are 6 different fields in rsBranch (including rsVehicles), I can access the first record in each by using: DataEnv.rsReplacement.Fields(6)("vehicleName") However, I can only access the first vehicle, even if a branch has more than one vehicle. How do I access all vehicles? Is there an easier way to do this? I appreciate your help.
Sat, 10 Nov 2001 03:00:00 GMT

Matthew Robinso #2 / 3	Changing SQL in a child command at run time Is it possible to change the SQL of a child command at run time? I have a command in the Data Environment called rsBranch, with a child command called rsVehicles. I can access DataEnvironment.rsBranch, but I cannot access DataEnvironment.rsVehicles. If there are 6 different fields in rsBranch (including rsVehicles), I can access the first record in each by using: DataEnv.rsReplacement.Fields(6)("vehicleName") However, I can only access the first vehicle, even if a branch has more than one vehicle. How do I access all vehicles? Is there an easier way to do this? I appreciate your help.
Sat, 10 Nov 2001 03:00:00 GMT

Latitud #3 / 3	Changing SQL in a child command at run time I had similar Problem. You can't pass a variable to a child command in the DE. MS said oops! I have started using the "Shape" You can do anything w/ this at runtime. I learned to use it by playing w/ the Master/Detail selection of the Data Form Wizard. Quote: >Is it possible to change the SQL of a child command at run time? I have a >command in the Data Environment called rsBranch, with a child command called >rsVehicles. I can access DataEnvironment.rsBranch, but I cannot access >DataEnvironment.rsVehicles. If there are 6 different fields in rsBranch >(including rsVehicles), I can access the first record in each by using: >DataEnv.rsReplacement.Fields(6)("vehicleName") >However, I can only access the first vehicle, even if a branch has more than >one vehicle. How do I access all vehicles? Is there an easier way to do >this? I appreciate your help.
Sat, 10 Nov 2001 03:00:00 GMT

Page 1 of 1

[ 3 post ]