var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: serach and redisplay form
I have a form displaying the table scott.emp
Then there exist two Text Items
where you enter the dates (format: dd.mm.yyyy)
and another Button named Go_And_Search.
If I press the Button Go_And_Search,
I'd like to clear the form scott.emp
and display in this form only the records
with a hiredate between Hiredate_start
If the Go_And_Search Button is pressed a
WHEN-BUTTON-PRESSED Trigger is started,
containing the name of a procedure call_hiredate_search.
In this Procedure I:
...but then ..... I'm helpless
then you need to do a set_block_property and change the default_where attribute for the block and then execute the form by execute_query. I am not sure of the exact syntax but you get the idea right?
Last edited by da_coolestofall; 05-25-04 at 18:56.
Thanx for the fast reply, I got the idea, and in a first test it seems to work (with table dept).
PROCEDURE call_search IS
SET_BLOCK_PROPERTY('DEPT', DEFAULT_WHERE, 'deptno BETWEEN :search.dept_start AND :search.dept_stop');