Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Duplicate values
Message
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Duplicate values
Miscellaneous
Thread ID:
00655300
Message ID:
00655300
Views:
56
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
Map
View

Click here to load this message in the networking platform