topic Re: DATA base in Application Development and Automation Discussions

DATA base

Former Member — Mon, 23 Jul 2007 09:54:14 GMT

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 ,

Re: DATA base

Former Member — Mon, 23 Jul 2007 09:57:02 GMT

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

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

Re: DATA base

Former Member — Mon, 23 Jul 2007 09:57:42 GMT

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.

Re: DATA base

Former Member — Mon, 23 Jul 2007 09:58:16 GMT

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.

Re: DATA base

Former Member — Mon, 23 Jul 2007 10:03:13 GMT

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.

Re: DATA base

Former Member — Mon, 23 Jul 2007 10:04:44 GMT

thanks to all.