Results 1 to 5 of 5

Thread: Record count

  1. #1
    Join Date
    Aug 2002
    Posts
    121

    Question Unanswered: Record count

    Hello,
    Is there a record built-in that returns the numbers of records inserted after a commit? I have a form which inserts a number of records into a table.

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Talking


    After insert you could use SQL%ROWCOUNT

    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  3. #3
    Join Date
    Aug 2002
    Posts
    121
    thank LK.... for some reason, I didn't think that
    SQL%ROWCOUNT could be used in forms

  4. #4
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Talking

    Quote Originally Posted by tmalone
    thank LK.... for some reason, I didn't think that
    SQL%ROWCOUNT could be used in forms
    Don't know much about forms, but did it work?
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  5. #5
    Join Date
    Aug 2002
    Posts
    121
    Yes, it worked. Thank you

Posting Permissions

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