General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Network:
Windows 2003 Server
>I can always APPEND BLANK one record to the cursor without an error. I then populate that record with values, in particular with GroupID and VisitID. If GroupID = 1, I can append additional records, populating each one before appending the next one without errors. However, if GroupID = 2, I can APPEND one record. When I attempt the next APPEND BLANK it triggers the index uniqueness violation error.
Jim - try putting the index key expression into the Watch window and see what the value is when you succeed and when you fail.
Tamar
Previous
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