Home » Developer & Programmer » Forms » Trying to navigate using first_record, next_record (Forms 6i Unix , LInux)
Trying to navigate using first_record, next_record [message #325713] Sat, 07 June 2008 21:33 Go to next message
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.
Re: Trying to navigate using first_record, next_record [message #325721 is a reply to message #325713] Sun, 08 June 2008 02:27 Go to previous messageGo to next message
Littlefoot
Messages: 20901
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?
Re: Trying to navigate using first_record, next_record [message #325793 is a reply to message #325713] Sun, 08 June 2008 22:56 Go to previous messageGo to next message
azamkhan
Messages: 548
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
Re: Trying to navigate using first_record, next_record [message #326144 is a reply to message #325713] Tue, 10 June 2008 05:39 Go to previous messageGo to next message
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
Re: Trying to navigate using first_record, next_record [message #326872 is a reply to message #326144] Thu, 12 June 2008 22:35 Go to previous message
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.
Previous Topic: How to populate a form blcok through cursor
Next Topic: Form navigat to the blank records - Strange
Goto Forum:
  


Current Time: Sun Dec 11 08:21:20 CST 2016

Total time taken to generate the page: 0.07440 seconds