Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

set_block_property('emp',default_where,...) with variables

Eslam_ElbyalyApr 5 2013 — edited Apr 7 2013
db and dev 10g rel2 ,

i am trying to learn about this built-in with variables and the equal(=) operator , i can not use it with variables , so show me please how to use it with number , charachter and date variables .
1- working with number variables .
- i have the block 'scott.emp' , and a button 'search' .
- my variable 'v' holds the value 7788 , and i want to display the data based on this number of the 'empno' column .
how to do it with set_block_property ?


thanks in advance

Edited by: newbi_egy on Apr 5, 2013 3:11 PM

Edited by: newbi_egy on Apr 6, 2013 2:55 PM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 5 2013
Added on Apr 5 2013
10 comments
3,937 views