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: 10926
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?
Previous Topic: How to compare two text boxes with IN operator form
Next Topic: oracle forms output embedded in html file
Goto Forum:
  


Current Time: Fri Aug 29 03:17:46 CDT 2014

Total time taken to generate the page: 0.11312 seconds