General information
Category:
Coding, syntax & commands
>hello all
>
>I have a grid based on a view and i get this error message when i updated a duplicate record,
>
>Warning The key defined by the keyfield property for table mydbc!table1 is not unique.
>
>Here is a sample data , key field is SSN
>
>Table1
>SSN
>123456789
>123456789
>987654321
>323552345
>
>Second record is a complete duplicate,so users selects it to delete.i just issue =tableupdate(.t.)
>
>but i get this error message.how to avoid this,any workarounds ???
>
>Txs for any help.
You need to use another key_field, which is unique and cannot be duplicated. Or add code to prevent adding records if they contain SSN already in the table.
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