DATA base

[Former Member]

Hi

in my program i am inserting same data to database 2 times, but when i look at the data base its taking only one entry.

am using this statement INSERT ZPORDER FROM LV_ORDER2.

how to correct this ,

[Former Member]

well a database has only UNIQUE entries. otherwise nothing would work.

NO database on the world will allow you to have duplicate records

[Former Member]

If the data in key fields of the table you are trying to insert is the same, then the data will be inserted only for the first insert. Subsequent inserts donot add the data in the database. Instead they give errors.

[Former Member]

Depending upon Key fields of Database table the record will be inserted. If you are inserting with the same Key fields then only 1 entry will be found.

[Former Member]

thanks to all.

[Former Member]

HI,

DUPLICATE RECORDS ARE NOT POPULATED INTO DATABASE TABLES. ATLEAST ALL PRIMARY KEY FIELDS SHOULD BE MODIFIED SO THAT NON PRIMARY KEYS HAVE SAME DATA.

IF HELPFUL REWARD SOME POINTS.

WITH REGARDS,

SURESH ALURI.