SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Enthusiast hombre_de_las_ca's Avatar
    Join Date
    Apr 2005
    Location
    Bangalore, India
    Posts
    90
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question Creating table from recordset having data from a "SHAPE" SQL statement

    well, i ahve a recordset which takes data from a database using the shape command in a SQL statement. now i want it to show the data in a tabular fom such that the parent field has to it's right the child fields with out repeating the parent field again and again. And this done, the child field in the table should have the grandchild fields to is right and as before without repetition of the child field. and all of this in a tabular form!!!

    i use a similar sql statement as below:
    SQLTRY = "SHAPE {SELECT * FROM A} APPEND ( ( SHAPE {SELECT * FROM B} APPEND ({SELECT * FROM C} RELATE MachineNum TO MachineNum) AS rsparts) RELATECategoryNum TO CategoryNum)"

    the record set gives the output but i require it it in the above said format...any help!!!!

  2. #2
    SitePoint Enthusiast hombre_de_las_ca's Avatar
    Join Date
    Apr 2005
    Location
    Bangalore, India
    Posts
    90
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    is there any one who can help with this???
    :/


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •