Home » Developer & Programmer » Forms » primary key and alpha character set.
primary key and alpha character set. [message #211333] Thu, 28 December 2006 00:28 Go to next message
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..
Re: primary key and alpha character set. [message #211337 is a reply to message #211333] Thu, 28 December 2006 00:46 Go to previous messageGo to next message
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'
Re: primary key and alpha character set. [message #211338 is a reply to message #211337] Thu, 28 December 2006 01:03 Go to previous messageGo to next message
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
Re: primary key and alpha character set. [message #211344 is a reply to message #211333] Thu, 28 December 2006 01:45 Go to previous messageGo to next message
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
Re: primary key and alpha character set. [message #211349 is a reply to message #211333] Thu, 28 December 2006 02:49 Go to previous message
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
Previous Topic: frm-40401 :i want to save more then one records .
Next Topic: DS Form Runtime Error
Goto Forum:
  


Current Time: Fri Dec 09 17:16:02 CST 2016

Total time taken to generate the page: 0.16414 seconds