Home » Developer & Programmer » Forms » RE: Insert Number Only
RE: Insert Number Only [message #261039] Tue, 21 August 2007 10:00 Go to next message
marsguy85
Messages: 14
Registered: August 2007
Junior Member
Hello All,
I am new to pl/sql , and stuck with the following problem.

I have 50 ids in which user needs to put in result for each in results coloum. BUT for id's from 10 to 30 user can only put in a decimal number.
I have a LOV for the results coloum haveing (pass,fail,yes,no,na)
so that when user types in 'p' and press enter ..... automatically a 'pass' is put in. and so on....

Now for id's from 10 to 30 only a decimal number will be accepted and nothing else.

please help me out .

cheers
Ash

Report message to a moderator

Re: RE: Insert Number Only [message #261109 is a reply to message #261039] Tue, 21 August 2007 19:23 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Use the 'set_item_property' to change the 'validate_from_list' to 'property_false' and the 'lov_name' to 'null' (I think that works to turn lov 'off'). Then in the 'when-validate-item', if the 'id' is between 10 and 30 check to make sure the field is numeric. Look at http://www.orafaq.com/forum/m/168856/67467/?srch=rtrim+david#msg_168856 and http://www.orafaq.com/forum/m/173919/67467/?srch=rtrim#msg_173919
for a method to test that an item is all alphabetic or numeric.

David

Report message to a moderator

Re: RE: Insert Number Only [message #261781 is a reply to message #261039] Thu, 23 August 2007 10:30 Go to previous messageGo to next message
marsguy85
Messages: 14
Registered: August 2007
Junior Member
Hiya,
Thanks for that but where do I put the property_false thing ? I mean does it go in the code beside the one where i have the set_item_property for LOV ? or do i create a new set_item for the validate item?

Also I want to have numeric only for few id's not all , rest of them will have to be a char which i have put in lov .

Sorry but i am new and learing it on my own .

cheers

Report message to a moderator

Re: RE: Insert Number Only [message #261893 is a reply to message #261781] Fri, 24 August 2007 00:00 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Have you found a copy of the Forms reference manual yet?

Have you worked through a demonstration Form from the Forms web site yet?

David

Report message to a moderator

Previous Topic: report does not open via we.show_document from forms
Next Topic: Can win_api_dialouge be used to open file dialuge box in web using forms 10g?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Feb 09 01:16:08 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.