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?