Scrolling up the query data [message #676779] |
Tue, 16 July 2019 03:18 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/9d0b7b073eb0a9ef4ec0c87c9c076996?s=64&d=mm&r=g) |
vraghul86@gmail.com
Messages: 11 Registered: December 2017
|
Junior Member |
|
|
i want scrolling up details like, DOno, name, salesman, qty from cursor on oracle form as like:
when i open a new form then cursor details move up like scrolling up.when cursor last record then repeat again this process.
how it can possible using when timer expired trigger. can any one help me please. i hope all of you understood my requirement.
|
|
|
|
|
|
|
Re: Scrolling up the query data [message #676802 is a reply to message #676792] |
Wed, 17 July 2019 10:31 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
cookiemonster
Messages: 13937 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
Warning - untested
In when-new-form-instance:
DECLARE
v_timer TIMER;
BEGIN
-- Initialize the block
go_block('do_sample');
execute_query;
first_record;
v_timer := Create_Timer('MYTIMER', 1000, REPEAT); --runs every second, change as appropriate
END;
In when-timer-expired:
DECLARE
v_timer TIMER;
BEGIN
v_timer := Find_Timer('MYTIMER');
If NOT ID_NULL(v_timer) THEN
IF :system.last_record = 'TRUE' THEN
first_record;
ELSE
next_record;
END IF;
synchronize; -- without it, you won't see anything happen
END IF;
END;
|
|
|
|
Re: Scrolling up the query data [message #676831 is a reply to message #676802] |
Sat, 20 July 2019 06:37 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/9d0b7b073eb0a9ef4ec0c87c9c076996?s=64&d=mm&r=g) |
vraghul86@gmail.com
Messages: 11 Registered: December 2017
|
Junior Member |
|
|
Dear Cookiemonster,
I have one more doubt how to change the back ground color only cursor_record rows.I had tried it in When-New-Record-instance trigger with the following query.
I have tabular block with 15 records displaying.
----------------
BEGIN
--if :System.Cursor_record=2 then
--message(:System.Cursor_record);pause;
--Set_Item_Instance_Property( :System.Cursor_record,CURRENT_RECORD_ATTRIBUTE, VISUAL_ATTRIBUTE,'v1');
set_item_property ('slno',CURRENT_RECORD_ATTRIBUTE,'v1');
--set_item_property ('slno',CURRENT_RECORD_ATTRIBUTE,'v1');
set_item_property ('dono',CURRENT_RECORD_ATTRIBUTE,'v1');
set_item_property ('vesl',CURRENT_RECORD_ATTRIBUTE,'v1');
set_item_property ('cust_name',CURRENT_RECORD_ATTRIBUTE,'v1');
set_item_property ('salman',CURRENT_RECORD_ATTRIBUTE,'v1');
set_item_property ('etadt',CURRENT_RECORD_ATTRIBUTE,'v1');
set_item_property ('port',CURRENT_RECORD_ATTRIBUTE,'v1');
set_item_property ('dis_status',CURRENT_RECORD_ATTRIBUTE,'v1');
--end if;
END;
|
|
|
|
|
|