General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hi Amy. To prevent the problem from happening in the first place, your app could generate unique project numbers each time from a sequence. Whether or not this will work depends on how and who is currently generating your project numbers.
>We have a candidate index on the project field in our project table so no duplicate project numbers can be input. However, the users periodically save a blank record causing a uniqueness of index violation the next time they try to input information and append blank kicks in. I've tried establishing validation rules on the table itself, but I can not get any desired results. Any suggestions would be greatly appreciated.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only