OraFAQ Forum: Forms » need helps plz on how to set the cursor?

Home » Developer & Programmer » Forms » need helps plz on how to set the cursor?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

need helps plz on how to set the cursor? [message #86160]

Sun, 05 September 2004 18:51

Dhalan
Messages: 15
Registered: August 2004

Junior Member

hai

can anyone teach me on how to set the cursor into a field called ALASAN. below is my example.

- start_am -
- 07:50:00 -

- End_am -
- -

- REMARKS -
- -

declare

x char;

begin

x:=to_char(sysdate, '07:45:00');

......

end;

:DATANG.start_am := substr(:system.current_datetime, instr(:system.current_datetime,' ')+1); ----[>] i used this codding for start_am

my question is, i want to compare the start_am with x. if start_am is more than x then i want to set the cursor automatically into�REMARKS textitem. can anyone teach me the coding on set the cursor automatically into�REMARKS coz i'm begginer in oracle and is the format correct for X coz i want to set x permanently which is 07:45:00.

thanks for helping me

regards

eboy

Report message to a moderator

Re: need helps plz on how to set the cursor? [message #86165 is a reply to message #86160]

Mon, 06 September 2004 06:56

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

hi eboy,
write a trigger when-new-block-instance on DATING.

if start_am = x then
go_item('REMARKS');
end if;

i think i have answered ur question.

by
vamsi

Report message to a moderator

Re: need helps plz on how to set the cursor? [message #86171 is a reply to message #86165]

Mon, 06 September 2004 15:57

eboy
Messages: 17
Registered: August 2004

Junior Member

thanks vamsi but is the format on declare x is correct. i mean to store 07:45:00 into x permanently.
thanks once again

Report message to a moderator

Re: need helps plz on how to set the cursor? [message #86175 is a reply to message #86171]

Mon, 06 September 2004 22:02

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

try this,

declare
x varchar2(8) := '07:45:00';
begin
:dating.start_am := substr(:system.current_datetime, instr(:system.current_datetime,' ')+1);
if x = :dating.start_am then
go_item('REMARKS');
end if;
end;

by
vamsi

Report message to a moderator

thanks vamsi for ur helping [message #86176 is a reply to message #86175]

Tue, 07 September 2004 00:05

eboy
Messages: 17
Registered: August 2004

Junior Member

thanks vamsi for ur helping
it works.

Report message to a moderator

Previous Topic:	!Urgent !Updating the table in Hierarchical Tree
Next Topic:	How to invoke third part OCX into D2k Forms

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 19 07:47:28 CDT 2024