Data Env. Parameter (Command Object)


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Data Env. Parameter (Command Object)

  1. #1
    Join Date
    Aug 2004
    Posts
    43,023

    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
    Posts
    43,023

    Re:Data Env. Parameter (Command Object)

    [Originally posted by Sabir Mustafa]

    Hi!
    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.
    Regards

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
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

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