General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
I need to write validation code that will search for duplicate values within a field. The datatype of the field is c(1) and I have other code preventing users from entering anything other than "1", "2", or "3". Basically, I need to make sure only one "1" is entered, one "2", etc... for a set of records. I tried doing this by creating separate cursors that will hold each possible value (only up to three), scanning my view, and inserting the field values into the different cursors. If any of the cursors have reccount(csr) > 1, then error message. Unfortunately, this does not work.
Next
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