I want to ensure that a value entered does not already exist, like a primary key test but it is not a primary key. I know I can set it in the database but that would give a messy result to the user. Is there a way that the datagrid handles it, or if not, can you add this in?
For example, I have a record that consists of a location id, and each location is assigned a unique id via the autoincrement, but they are assigned a value to another field called point_id before they get to the database. (Sure the database should have been designed better but it's way too late to fix that up). The point_id must be checked to ensure it does not already exist before saving the record. |
|
|