DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2004

    Data Env. Parameter (Command Object)

    [Originally posted by veetian]

    I have this scenario:
    A table named customer, another one named transaction. The transaction table is used to record transaction made by the customers.

    A data report was created, was bound to the data environment commmand object called FromCustomers. The command object has a child command called TheTransactions.

    The data report displays successfully when I have only one parameter, which is TheID, a string to indicate which customer's report to print.

    However, I would also need a parameter (of integer) to indicate which month's transaction report is indicated to print, and this is used in the child's command text (SELECT * FROM `Transaction` WHERE (Month(trnsDate) = TheMonth) )

    It was valid when i run it in the form, but when put into as a child's command object, it requires me to enable a relation to the parent object, and i wasn't able to pass the parameter value to the query when i entered DataEnvironment1.Connection.FromCustomers <-- (it only prompted me for the customerID, but not theMonth)

    Please help me, i'm stuck at here ^__^

  2. #2
    Join Date
    Aug 2004

    Re:Data Env. Parameter (Command Object)

    [Originally posted by Sabir Mustafa]

    Another friend on the forum had encountered the same problem and I solved it for him. Please send me the query or the part of your project on my email, I will make it working for you.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
HTML5 Development Center
Latest Articles
Questions? Contact us.
Web Development
Latest Tips
Open Source

   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center