Home » Developer & Programmer » Forms » Form 3.0
Form 3.0 [message #268553] Wed, 19 September 2007 01:29 Go to next message
sudh11482
Messages: 16
Registered: September 2007
Location: Lucknow
Junior Member

Hi all,
I m new to this group.
I have been developing application on Form 3.0 on Unix platform.
I have used Key-nxtfld trigger throught out the application and procedures.
Now I want to know what is best approach to Form 3.0 programming? Also when to key-nxtfld trigger and on-validate-field? Can not we use go_field('') in on-validate-field trigger?thnx in advance
Re: Form 3.0 [message #268557 is a reply to message #268553] Wed, 19 September 2007 01:35 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Sudhanshu,

Is it necessary for you to work in Forms 3.0?

Go to the Oracle Forms website and download the oldest erference manual you can find. You will find that the when-validate-item trigger can only use 'SELECT' statements, and 'unrestricted' built-ins. Unfortunately, go_field is a 'restricted' built-in.

David
Re: Form 3.0 [message #268662 is a reply to message #268557] Wed, 19 September 2007 05:09 Go to previous messageGo to next message
sudh11482
Messages: 16
Registered: September 2007
Location: Lucknow
Junior Member

Hi David ,

Yes it is necessary to work in Form 3.0 because the software is already on 40 sites for so many years.
Now it needs some more forms on thats why i need help on Form 3.0.
If u find anything then pls help.

thnx
Re: Form 3.0 [message #268823 is a reply to message #268662] Wed, 19 September 2007 19:17 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
In your 'on-validate-field' set a control item or global to the name of the field to which you wish to jump and in the 'key-nxtfld' test to see if that global is 'null'. If not 'null' then store it locally, remove the value from the global and then do a 'go_field' using the locally stored value.

David
Re: Form 3.0 [message #268888 is a reply to message #268823] Thu, 20 September 2007 00:28 Go to previous message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I've found SQL*Forms (version 3.0) Quick Designer's Reference book (printed copy). Now that you know it's name, perhaps Google will return something if you search for it.

[Updated on: Thu, 20 September 2007 00:28]

Report message to a moderator

Previous Topic: forms: can compile cannot run
Next Topic: Disable Save Changes Alert
Goto Forum:
  


Current Time: Fri Sep 27 04:22:32 CDT 2024