I am making a new entry into table T015Z,I have 4 fields to fill data with,I created one entry without mentioning the primary keys EINH & ZIFF.If I now try to create a new record without mentioning the primary keys,it gives me a message : A data record with specified key fields already exists.
Thus not allowing me to create a new entry.
Is it mandatory to mention all the key fields data while creating a new record? If so,then how will I get the values for the other two key fields,which contain data for Unit & Figure.
Please let me know,what will be the best possible solution for my problem.
As I said u earlier, primary key entries are a must to any table as they cannot be NULL.
Now u have to delete the previous entries in the table and again insert new records into the table with Primary key field entries..
this will solve ur problem.
pls reward if helpful.
Primary Keys are to be entered for inserting or modifying database records. Primary Keys can be used to identify a recored uniquely.
For example you need name/id in a telephone directory to find a number.
The first record you saved was entered with space. ie., a telephone number was saved against the guy 'SPACE'. Now for the second time when you try to create without mentioning Primary Key, an entry 'SPACE' already exists. That is why it is not allowing.
So you can delete the previous entries and give entries with all primary keys specified.