OraFAQ Forum: Forms » primary key and alpha character set.

Home » Developer & Programmer » Forms » primary key and alpha character set.

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

primary key and alpha character set. [message #211333]

Thu, 28 December 2006 00:28

ataufique
Messages: 79
Registered: November 2006

Member

1. how can i check the primary key violation at item level.
say when user enters empno and if this exists in the table the
cursor should not go to next field..and error pop ups

2. how can i set the ename to have only alpha characters..
say when user enters ename and if this is other then alphabets then cursor should not go to next field..

Report message to a moderator

Re: primary key and alpha character set. [message #211337 is a reply to message #211333]

Thu, 28 December 2006 00:46

wency
Messages: 450
Registered: April 2006
Location: Philippines

Senior Member

1. on when-validate-item, check the input against the table.
2. data type must be 'Alpha'

Report message to a moderator

Re: primary key and alpha character set. [message #211338 is a reply to message #211337]

Thu, 28 December 2006 01:03

ataufique
Messages: 79
Registered: November 2006

Member

Thanks for the revert..
1.can i have a sample code to check the input .
2.making Alpha allows the space input,my field is primary key
but i want to validate at item level..

please...Thanks

Report message to a moderator

Re: primary key and alpha character set. [message #211344 is a reply to message #211333]

Thu, 28 December 2006 01:45

ataufique
Messages: 79
Registered: November 2006

Member

Thanks again for prompt reply.
1. Issue close, I have written the code at when-validate-item
as you said...
2. Ename field was just an example..sorry for this..
here my requirement is a 5 char service code field which can have only A-Z values and not space / Null

Report message to a moderator

Re: primary key and alpha character set. [message #211349 is a reply to message #211333]

Thu, 28 December 2006 02:49

wency
Messages: 450
Registered: April 2006
Location: Philippines

Senior Member

Set property to required = YES, this will not accept null and spaces input, but alpha and spaces will be accepted. I don't know if there is a mask to reject spaces, but you can trap this on validation. have a look at this: http://www.orafaq.com/forum/m/173919/67467/?srch=rtrim?SQ=&S=0d9303a459a0f5f94bf4efa084f075dd#msg_173919

Report message to a moderator

Previous Topic:	frm-40401 :i want to save more then one records .
Next Topic:	DS Form Runtime Error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 15:35:02 CDT 2024