Check if edit is valid for database ms-access
- by twodayslate
I want to be able to check if I can edit a cell in a database with a new object
Example method declaration:
something.isValid(Object newObject, row, column);
Example cases:
If the editing cell stores an Number
and I give it a String, the method
will return false...
If the editing
cell has to be different than every
other entry and the new object is the
same as something else, the method
will also return false....
My main goal...
I want to check a whole row, and if everything is valid, I will edit the whole row.
Right now, the only way I can find out if I can actually edit something is by actually editing it and seeing if I get an error.