OraFAQ Forum: Forms » Validation Problem in Forms and problem in tabula form (merged)

Home » Developer & Programmer » Forms » Validation Problem in Forms and problem in tabula form (merged)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Validation Problem in Forms and problem in tabula form (merged) [message #169900]

Sun, 30 April 2006 04:45

sweetkhaliq
Messages: 200
Registered: April 2006

Senior Member

i am genereating auto number in when-new-recoed-instance for lot# field. and i have used when-validate-trigger for all other items but i hv a buttin quit that has the code exit_form(no_validate), when i press the quit button it still check items for validation.
i want that when i press the quit button it should not ask for validation and form must exit.

Report message to a moderator

problem in tabula form [message #169901 is a reply to message #169900]

Sun, 30 April 2006 04:53

sweetkhaliq
Messages: 200
Registered: April 2006

Senior Member

i am generating auto number for item_id in when-new-record-instance trigger. when i save the record it goes to the next recod and new number is assigned to item_id but when i come down with down arrow without saving the recoed the same number for item_id is coming. i want that without saving it should not come down in new record that is empty;

Report message to a moderator

Re: Validation Problem in Forms [message #169957 is a reply to message #169900]

Mon, 01 May 2006 00:30

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Put the auto-generate in the When-Create-Record trigger NOT the WNRI trigger. Put a "message('i am here'); pause;" pair before and after your 'exit_form' command to prove that your form is exiting via this code.

David

Report message to a moderator

Re: Validation Problem in Forms [message #169958 is a reply to message #169957]

Mon, 01 May 2006 00:33

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Please post the code that you are using to populate your field.

David

Report message to a moderator

Re: Validation Problem in Forms [message #170006 is a reply to message #169958]

Mon, 01 May 2006 12:57

sweetkhaliq
Messages: 200
Registered: April 2006

Senior Member

Thanks David my problem has solved by using when-create-record trigger which you have suggested for me. if in future any problem will come i will discuss with you. once again thanks for you reply.

Report message to a moderator

Previous Topic:	when kye pressed
Next Topic:	"update record" does not updates. why?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 09:58:26 CDT 2024