#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2006
    Posts
    2
    Rep Power
    0

    How to display row number?


    hello everyone, i am having troubles on displaying the row number of the records i retrieve when i execute query.... I'm using a tabular format... i want to display the corresponding row number per record... its just like this i have the row no, name, id... if my query retrieves 21 records, i want my row no column to display
    row no name id
    1 -------- -----
    2 -------- -----
    3
    *
    21


    just like that... can anyone help me on this case... i need an answer as soon as possible... pls. email me for your answers..
    kylevhan@yahoo.com
    thankssss.... god bless

    by the way, i am using oracle form builder for that...
  2. #2
  3. Modding: Oracle MsSQL Firebird
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jun 2001
    Location
    Outside US
    Posts
    8,527
    Rep Power
    539
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2006
    Posts
    2
    Rep Power
    0
    but where will i type that code???
    and can you explain it further more for me.. sorry but im a slow learner in this matter... sorry ... thanks for ur answer...
  6. #4
  7. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2006
    Posts
    5
    Rep Power
    0
    Originally Posted by pabloj
    Use Oracle's ROWNUM (Google for it) like
    sql Code:
    SELECT ROWNUM, col1, col2 FROM TABLE
    Add ROWNUM to your query as a new column.
  8. #5
  9. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2006
    Posts
    1
    Rep Power
    0

    ROWNUM in FORMS


    hi,

    You can achieve that by adding new item named 'ROWNUM'. in the Data Block you are working on.
    And it's 'BASE TABLE ITEM' property needs to be set as TRUE'.
  10. #6
  11. Contributing User
    Devshed Novice (500 - 999 posts)

    Join Date
    Sep 2006
    Posts
    859
    Rep Power
    388

    Thumbs down


    If you do not know the basics, maybe it's time you choose another line of work.

    Comments on this post

    • pabloj disagrees : Thanks for your kind words
    Last edited by pabloj; September 28th, 2006 at 03:08 AM. Reason: Clean up

IMN logo majestic logo threadwatch logo seochat tools logo