OraFAQ Forum: Forms » How does one make next_record built-in working automatic?

Home » Developer & Programmer » Forms » How does one make next_record built-in working automatic? (database 10g , forms 6i , XP SP2)

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

How does one make next_record built-in working automatic? [message #324662]

Tue, 03 June 2008 10:15

Hany Freedom
Messages: 256
Registered: May 2007
Location: Egypt

Senior Member

I made that table :-

CREATE TABLE DT
(DD  DATE DEFAULT sysdate NOT NULL);

and in forms 6i , I made simple form to it , and it's working correctly , but I want after I post the date in the text item go automatic to the second record to post in it the second date , and so on ......
I tried next_record in WHEN-VALIDATE-ITEM but didn't work Sad

so ....... is there anyway to make this idea working Question

PS : I upload the fmb file to test it if you would.

Attachment: INSERT_THEN_CLEAR.fmb
(Size: 48.00KB, Downloaded 1048 times)

Report message to a moderator

Re: How does one make next_record built-in working automatic? [message #324677 is a reply to message #324662]

Tue, 03 June 2008 12:11

Martin Eysackers
Messages: 80
Registered: October 2005
Location: Belgium

Member

for your DT datablock, change navigation style to :
change record

for your DD text item set Automatic skip to Yes

or if you want to go to a new record each time the user saves the changes (commit) you could write a Key-Commit trigger :

commit_form;
if not form_success then
	raise form_trigger_failure;
end if;
next_record;

you can not navigate in a when-validate-item that's why next_record did not work

Report message to a moderator

Re: How does one make next_record built-in working automatic? [message #324714 is a reply to message #324662]

Tue, 03 June 2008 14:20

Hany Freedom
Messages: 256
Registered: May 2007
Location: Egypt

Senior Member

your way is true , thanks a lot Very Happy

Report message to a moderator

Re: How does one make next_record built-in working automatic? [message #426864 is a reply to message #324714]

Tue, 20 October 2009 02:34

samit_gandhi
Messages: 226
Registered: July 2005
Location: Hong Kong

Senior Member

it works for me too

thank you

Report message to a moderator

Previous Topic:	system.record_status
Next Topic:	raise form_trigger_failure in WHEN-VALIDATE-RECORD still saves data

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 14:14:04 CDT 2024