Home » Developer & Programmer » Forms » How to validate salary regarding to its MIN and MAX value from another table?
How to validate salary regarding to its MIN and MAX value from another table? [message #557836] Sat, 16 June 2012 03:01 Go to next message
walson
Messages: 1
Registered: June 2012
Location: nairobi
Junior Member
hi i have a created data block using employees table so am trying to validate item salary using max_salary and min_salary from table jobs pliz show me how to do this kind of validation

[SPLIT from How can i validate input number into a Field of type char in oracle form? by LF]

[Updated on: Sat, 16 June 2012 03:51] by Moderator

Report message to a moderator

Re: how to validate item in oracle form? [message #557840 is a reply to message #557836] Sat, 16 June 2012 03:35 Go to previous message
cookiemonster
Messages: 9135
Registered: September 2008
Location: Rainy Manchester
Senior Member
Write code in the when-validate-item trigger that compares the value in the item to the min and max salary.
This is as simple as form code gets, what's the problem?

Report message to a moderator

Previous Topic: How to compare two text boxes with IN operator form
Next Topic: oracle forms output embedded in html file
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon May 20 02:24:18 CDT 2013

Total time taken to generate the page: 0.34609 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.