Data Shaping

Results 1 to 3 of 3

Thread: Data Shaping

  1. #1
    Damian Edgeworth Guest

    Default Data Shaping

    I'm using data shaping in my application and it works a treat but I tried to impose some conditions on my "Select" statement but it doesn't accept them - is there any way around this?

  2. #2
    Join Date
    Dec 1969

    Default RE: Data Shaping

    Show me the code baby, yeah.

  3. #3
    Join Date
    Dec 1969

    Default RE: Data Shaping

    SQLGenBet = "SHAPE {SELECT SubCatgID From staSubCatg}" & _<BR>"APPEND((SHAPE {Select EventClassID, EventClass From staEventClass} AS Class" & _<BR> "APPEND(Select EventTypeID, Name, Note From prcEventType} AS Type" & _<BR> "RELATE EventClassID TO EventClassID))" & _<BR>"RELATE SubCatgID TO SubCatgID)"<BR><BR><BR>I want to SELECT SubCatgID From staSubCatg where SubCatgID = 56<BR>but it doesn&#039;t seem to work!

Posting Permissions

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