-
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?
-
Why don't you use sequance to do that?
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|