Results 1 to 4 of 4

Thread: auto number

  1. #1
    Join Date
    Sep 2003
    Posts
    4

    Question Unanswered: auto number

    Hi

    How can I add auto number/ row number to a query

    Thanks
    Last edited by sbabu; 09-24-03 at 16:03.

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    What do you mean? A query returns a result set ... There is no autonumber capability in a query. As you iterate thru the recordset you may keep a record count that serves the same purpose.

  3. #3
    Join Date
    Sep 2003
    Posts
    4

    Lightbulb

    Originally posted by M Owen
    What do you mean? A query returns a result set ... There is no autonumber capability in a query. As you iterate thru the recordset you may keep a record count that serves the same purpose.
    Thanks for your reply.
    Since I am using this query in crystal reports, I can't use record set.

    My query should look like this.

    Select row number,a.coulmn1,b.column2
    from a,b
    where a.columnx = b.columnx

  4. #4
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Welllll .... Technically CR does use a recordset. They just DON'T LET YOU SEE IT ... That's besides the point ... You might be able to fake it out by querying from a table that has an autonumber column (i.e - grab the data from your primary table(s) and dump it into the "staging area" table that you run youe CR report off of) ...

Posting Permissions

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