Results 1 to 4 of 4

Thread: Crosstab view

  1. #1
    Join Date
    May 2006
    Posts
    4

    Red face Unanswered: Crosstab view

    Hi
    I'm trying to create a crosstab view in Pervasive.Sql
    Is anyone familiar with that or done that ?
    Thanks
    Akila

  2. #2
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    What exactly are you trying to do? If I understand about Crosstab queries, they are just joins.
    Mirtheil Software
    Certified Pervasive Developer
    Certified Pervasive Technician
    Custom Btrieve/VB development
    http://www.mirtheil.com
    I do not answer questions by email. Please post on the forum.

  3. #3
    Join Date
    May 2006
    Posts
    4
    I have a table TA ,

    ord Item
    104460 100-813
    104460 2010-0026
    104460 4020-0023


    I want to create a view to see this table TA as this
    Ord Item1 item2 item3
    104460 100-813 2010-0026 4020-0023

    I know that in MSQL the TRANSFORM function can do it

    Thanks

    Akila

  4. #4
    Join Date
    May 2006
    Posts
    4

    Crosstabb query in Pervasive

    I have a table TA ,

    ord Item
    104460 100-813
    104460 2010-0026
    104460 4020-0023


    I want to create a view to see this table TA as this
    Ord Item1 item2 item3
    104460 100-813 2010-0026 4020-0023

    I know that in MSQL the TRANSFORM function can do it

    Thanks

    Akila

Posting Permissions

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