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

Thread: New record

  1. #1
    Join Date
    Nov 2000
    Posts
    29
    Developer2000

    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
    Location
    Ny
    Posts
    105
    Why don't you use sequance to do that?

  3. #3
    Join Date
    Nov 2000
    Posts
    29
    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