Prevent update on field value if no changes [message #284845] |
Sat, 01 December 2007 14:14  |
kensington
Messages: 2 Registered: December 2007
|
Junior Member |
|
|
I need to check if an update on an Oracle 9i field value is a duplicate of what is already there.
If there is nothing there or if there is data there I need to make sure the record is not updated if nothing has been changed.
For example the field (called infoField) value has this in it:
id infoField
34 Here is the current information.
The update form input infoField value (located in a JSP) will show the current database value for id = 34:
Here is the current information.
The database should not allow an update on the record if the user tries to update and didnt change or update the infoField value in the database.
Are there any contraints or a good way to do this??
[Updated on: Sat, 01 December 2007 14:43] Report message to a moderator
|
|
|
|
|
|