Home » Developer & Programmer » Forms » Form navigat to the blank records - Strange (Forms 6i, Oracle 9i)
Form navigat to the blank records - Strange [message #326710] Thu, 12 June 2008 06:18 Go to next message
mrkamran
Messages: 9
Registered: May 2007
Junior Member
Hi,
I m getting an error in master detail form that when i press down button i show new blank record and again press down button then another blank record shows and similarly it increase even no record exist. I got this error in only one form whereas other master detail forms are working properly.
What should i do to prevent scrolling blank records
Thanks
Bye
Re: Form navigat to the blank records - Strange [message #326763 is a reply to message #326710] Thu, 12 June 2008 09:18 Go to previous messageGo to next message
mandeepmandy
Messages: 79
Registered: May 2008
Location: USA
Member

Set insert property of block to NO.Actually it is trying to insert.

Thanks
Mandeep
Re: Form navigat to the blank records - Strange [message #326876 is a reply to message #326710] Thu, 12 June 2008 22:50 Go to previous messageGo to next message
urnikhil
Messages: 42
Registered: March 2008
Member
If you don't want to set the insert property of block to NO then you can create a KEY-DOWN trigger on the block and include NULL statement in it...

- Nik

[Updated on: Thu, 12 June 2008 22:50]

Report message to a moderator

Re: Form navigat to the blank records - Strange [message #326903 is a reply to message #326876] Fri, 13 June 2008 00:49 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Your users won't really like it if you disable the navigation keys!
Re: Form navigat to the blank records - Strange [message #326945 is a reply to message #326710] Fri, 13 June 2008 02:54 Go to previous message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Quote:
when i press down button i show new blank record and again press down button then another blank record shows and similarly it increase even no record exist.

So, you are, actually, scrolling down through empty records? Right?

If so, WRONG! There must be an invisible item (or items) populated in a trigger (such as WHEN-CREATE-RECORD or WHEN-NEW-RECORD-INSTANCE, or even KEY-DOWN; who can tell, but you?). Visible items are not "required" so it enables "scrolling" through "empty" records.

Check block-level triggers. There *must* be something that enables this "phenomenon".
Previous Topic: Trying to navigate using first_record, next_record
Next Topic: Query Records in forms 6i
Goto Forum:
  


Current Time: Sat Dec 03 20:27:59 CST 2016

Total time taken to generate the page: 0.21356 seconds