Home » Developer & Programmer » Forms » Fill all fields (Forms 6i, Database 10g)
Fill all fields [message #402235] Fri, 08 May 2009 02:56 Go to next message
snsiddiqui
Messages: 168
Registered: December 2008
Senior Member
Dear All

How can I stop user at the time of insertion/updation to fill all fields in detail block.
Re: Fill all fields [message #402241 is a reply to message #402235] Fri, 08 May 2009 03:09 Go to previous messageGo to next message
klat
Messages: 87
Registered: May 2009
Location: Mumbai
Member

snsiddiqui wrote on Fri, 08 May 2009 13:26
Dear All

How can I stop user at the time of insertion/updation to fill all fields in detail block.



Explain your problem.

Re: Fill all fields [message #402248 is a reply to message #402235] Fri, 08 May 2009 03:28 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Disabling these items might be one way (check usage of the SET_ITEM_PROPERTY built-in).
icon11.gif  Re: Fill all fields [message #402254 is a reply to message #402235] Fri, 08 May 2009 03:59 Go to previous messageGo to next message
azamkhan
Messages: 548
Registered: August 2005
Senior Member
Best way is to disable INSERT_ALLOWED and UPDATED_ALLOWED properties...
Re: Fill all fields [message #402256 is a reply to message #402248] Fri, 08 May 2009 04:09 Go to previous messageGo to next message
snsiddiqui
Messages: 168
Registered: December 2008
Senior Member
Let me explain

suppose I have these fields in my form

products, structure, unit, qty, date, rate


after filling of all fields in master block user move to detail block, first he will insert product then he doesn't insert other remaining fields or he doesn't insert rate and save this record.

I want to stop user for these type of activities.
icon11.gif  Re: Fill all fields [message #402257 is a reply to message #402235] Fri, 08 May 2009 04:12 Go to previous messageGo to next message
azamkhan
Messages: 548
Registered: August 2005
Senior Member
Then check your conditions on trigger KEY-COMMIT. If records are according to your criteria then issue commit or else message the user to enter correct information
Re: Fill all fields [message #402268 is a reply to message #402235] Fri, 08 May 2009 05:30 Go to previous messageGo to next message
cookiemonster
Messages: 12403
Registered: September 2008
Location: Rainy Manchester
Senior Member
Don't you just want to make all these fields required?
Re: Fill all fields [message #402464 is a reply to message #402268] Sun, 10 May 2009 22:28 Go to previous message
snsiddiqui
Messages: 168
Registered: December 2008
Senior Member
thanks cookiemonster

I have already done and it is better instead of writing code.
Previous Topic: F10 trigger
Next Topic: Toolbar menu
Goto Forum:
  


Current Time: Sun Dec 04 18:32:29 CST 2016

Total time taken to generate the page: 0.04550 seconds