OraFAQ Forum: Forms » Mandatory Field problem

Home » Developer & Programmer » Forms » Mandatory Field problem

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

Mandatory Field problem [message #392209]

Tue, 17 March 2009 01:00

h_jitendras
Messages: 36
Registered: October 2006

Member

hi,
i have a composite primary key of which Date is one component.
In the form,i'm displaying 2 columns - the date as well as the amount in a multi-record block.
I enter the date and the amount for the 1st record,dont save it and proceed to the next record.Here again I enter only the date but then decide to wipe off the date and try to save the 1st entered record.It gives me an error "This field must be entered"..I guess this might be due to the date being a part of the primary key and it is displaying its default behaviour.

any thoughts on how to handle this?

thanks.

Report message to a moderator

Re: Mandatory Field problem [message #392220 is a reply to message #392209]

Tue, 17 March 2009 01:30

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Don't "wipe off the date", but remove (delete) the whole record.

Report message to a moderator

Re: Mandatory Field problem [message #392233 is a reply to message #392209]

Tue, 17 March 2009 02:10

azamkhan
Messages: 557
Registered: August 2005

Senior Member

Dear Friend,

When you declare a column as a Primary Key (Pk) that means it will be Unique and Not Null.

So you have created a composite PK so you can't just give one value and not the other one. You have to give both value because its a composite Pk.

Regards,
Azam Khan

Report message to a moderator

Previous Topic:	Summary Field Validation!
Next Topic:	database not updating

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 03 20:53:17 CST 2025