OraFAQ Forum: Forms » Trying to navigate using first_record, next

Home » Developer & Programmer » Forms » Trying to navigate using first_record, next_record (Forms 6i Unix , LInux)

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

Trying to navigate using first_record, next_record [message #325713]

Sat, 07 June 2008 21:33

wrwelden
Messages: 7
Registered: November 2004

Junior Member

I am trying to navigate thru all records on a multi-record form using first record, next_record in order to load the rows into an array so I can sum(items on the screen that are not in the database. I am using on_key_commit trigger to call a program unit. I have tried to use when_timer_expired to accomplish the navigation but no success. When I use show_message to find out the values from the data block they appear null. Any advice would be appreciated.

Report message to a moderator

Re: Trying to navigate using first_record, next_record [message #325721 is a reply to message #325713]

Sun, 08 June 2008 02:27

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

NULL + something = NULL.

So, if you believe that code you've used is correctly written (i.e. navigation is OK), would use of NVL(something, 0) help while adding values?

Report message to a moderator

Re: Trying to navigate using first_record, next_record [message #325793 is a reply to message #325713]

Sun, 08 June 2008 22:56

azamkhan
Messages: 557
Registered: August 2005

Senior Member

You can use POST-RECORD to check and populate your record in your array.

When every the post-record is fired you check your reocrd status and if it is INSERT then populate it in your array.

Regards,
Azam Khan

Report message to a moderator

Re: Trying to navigate using first_record, next_record [message #326144 is a reply to message #325713]

Tue, 10 June 2008 05:39

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

Member

could you please tell us why you are not using the forms
calculated items, they are powerful and do the trick most of the time without writing triggers to accomplish the same thing

if you haven't tried them before please have a go

Report message to a moderator

Re: Trying to navigate using first_record, next_record [message #326872 is a reply to message #326144]

Thu, 12 June 2008 22:35

wrwelden
Messages: 7
Registered: November 2004

Junior Member

Thanks for the info. Most of my troubles, I caused myself. Some of the difficulty comes from the the design spec provided. But, I realize now that the navigation using first record next record was not needed. Thanks again.

Report message to a moderator

Previous Topic:	How to populate a form blcok through cursor
Next Topic:	Form navigat to the blank records - Strange

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 03 06:45:53 CST 2025