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: 172
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.

Report message to a moderator

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.

Report message to a moderator

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: 21823
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).

Report message to a moderator

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: 557
Registered: August 2005
Senior Member
Best way is to disable INSERT_ALLOWED and UPDATED_ALLOWED properties...

Report message to a moderator

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: 172
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.

Report message to a moderator

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: 557
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

Report message to a moderator

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: 13963
Registered: September 2008
Location: Rainy Manchester
Senior Member
Don't you just want to make all these fields required?

Report message to a moderator

Re: Fill all fields [message #402464 is a reply to message #402268] Sun, 10 May 2009 22:28 Go to previous message
snsiddiqui
Messages: 172
Registered: December 2008
Senior Member
thanks cookiemonster

I have already done and it is better instead of writing code.

Report message to a moderator

Previous Topic: F10 trigger
Next Topic: Toolbar menu
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Feb 10 03:46:43 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.