|
-
Pinakin
get_block_property(BLOCK_NAME, default_where);
you DO need the block name if you are concatenating a value from an item in another block:
set_block_property('PEOPLE',default_where,'name like ''%'||:control_block.text_item6||'%''');
go_block('PEOPLE');
execute_query;
This code DOES WORK - I JUST TRIED IT.
Oracle DBA and Developer
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
|