DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2006

    how do i write my shape statement

    hi, can someone help me with this, it's my first time using shape statement and i'm confused. i'm using a vb6 program and access database

    i want to do a shape statement where the parent has a child and the child has another child, and there is parameters passed to the parent

    i had this done in dataenvirenment and now i'm converting it to a shape statment

    here is the parent sql statment i used in dataenvirement

    select * from tblCustomer, tblVisit where strVisitStatus <> 'Cancelled' and dtDate = ? and dtLastVisit =? and intTicketNum = intTicketNumb

    where i pass the date and a number to it

    the child sql statement is

    select * from tblVisit order by intVisitNum Desc
    the relation ship between the child and the parent is
    intticketNum to intTicketNumb

    the child of the child sql statment is

    select * from tblJobOrder
    relation ship between this child and the one before it is
    tblJobOrder.visitID to tblVisit.visitID

    i need to know how to set up this shape statment and how to execute it, and how do i pass the parameters to it, what i'm gonna pass to it is a values of text boxes. also how to connect it to the report afterwards

  2. #2
    Join Date
    Aug 2004
    Orange, California

Similar Threads

  1. Replies: 1
    Last Post: 02-14-2006, 07:04 AM
  2. Replies: 0
    Last Post: 02-12-2006, 06:27 PM
  3. Replies: 1
    Last Post: 08-23-2005, 11:23 PM
  4. Access And SQL date statement
    By Saiful in forum VB Classic
    Replies: 7
    Last Post: 11-24-2000, 05:21 AM
  5. Proper way to write this...
    By Saiful in forum Web
    Replies: 6
    Last Post: 08-06-2000, 01:29 AM

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