Getting a block's rowid [message #80461] |
Tue, 24 September 2002 16:47 |
fokker
Messages: 18 Registered: March 2002
|
Junior Member |
|
|
I want to get the current block's rowid. However, i don't know the blocks name until runtime. For instance, if I had two blocks, myblock1, and myblock2, then I can get the name of the current block using :system.current_block. However, the only way to get the current block's id that i know of is to use :myblock1.rowid. So I would have to do something like this:
IF :system.current_block = 'MYBLOCK1' THEN
row_id := :myblock1.rowid;
ELSIF :system.current_block = 'MYBLOCK2' THEN
row_id := :myblock2.rowid;
END IF;
I want to eliminate this redundant code. Is there a way that i could get the current block's rowid without using some kind of long IF THEN statement?
|
|
|
|
|