when-timer-expired hit the cursor position
Some of our forms sometimes have timers running, to monitor
progress of this and that. We've found that if the timer
expires when you're typing in a form field, there's a tendency
for the cursor to momentarily move to the beginning of the field
then jump back to roughly where it had been. If you're just
typing away without paying attention, this can be messy.
Specifically, I put a few '0' characters at the beginning of a
large field, then hit '1' and let it go to autorepeat. When the
trigger fires, the insert cursor goes to a wait cursor for a
bit, then back. I'll find a few '1' characters at the beginning
of the field, and the insert cursor is now pointing the same
number of characters from the end of the field. My testing
indicates that the more time spent in the trigger, the more
likely the problem is to occur. Also, it happens more if
you're in a different form than the one with the timer.
does anyone know how to handle this situation
i m using when_timer_expired trigger with folllowing code
declare
v_timer varchar2(40);
begin
v_timer:=get_application_Property(timer_name);
if v_timer='TIMER_TIME' then
:CONTROL.onscreen:=to_char(sysdate,'HH12:mi:ss AM');
end if;
end;