DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: New record

Hybrid View

  1. #1
    Join Date
    Nov 2000

    I insert new record in detail block
    The key(id) of this record is autonumber field
    I press commit but this key field is still null
    (It will become valid value if i execute_query but i don't
    want to do it)
    After that i go to another block, i must use
    those key field (id) , but i don't know it.
    Can you solve this problem?

  2. #2
    Join Date
    Aug 2000
    Why don't you use sequance to do that?

  3. #3
    Join Date
    Nov 2000
    I found new solvation
    I lock table,find last record,take its id in my block
    Then table unlocks after commit

    Am i correct?

    p.s. is there unlock table statement in sql or
    it unlocks automatically allways after commit or rollback?

Posting Permissions

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

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.