General information
Category:
Coding, syntax & commands
>i have a table with a primary key. i use it in a form so i can make a new record and delete it. the problem is there is an error, with the primary key, if i make a new record after i delete one record in that table. anyway, i won't be able to 'PACK' the table coz i use a grid in the form to browse all data/record. i've tried using 'SET DELE ON' & 'SET FILTER TO NET DELETED()' but it doesn't work.
>what should i do?
Gloria, to go a little further with what Craig said, your primary key should be an automatically generated number that has nothing to do with the data. It's main purpose is to help with table joins. If there is a number that your users will enter that should be unique, then you should check for the existence of that particular number before allowing the user to save the record, and then ask the user what to do - whether to recall the old record or blank it out except for the number.
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