topic Re: Data is overwritting in database in Application Development and Automation Discussions

Data is overwritting in database

former_member659396 — Fri, 23 Jan 2009 08:03:17 GMT

Dear friends

I am saving data in database table through screen.but problem is that it should allow duplicate entry

without overwriting,

wa_ordtyp-txt = T003p-AUART.

WA_ORDTYP-AUART = T003P-AUART.

WA_ORDTYP-ZRD_FIELD = ZRD_FIELD.

WA_ORDTYP-ZRD_FLHDR = ZRD_FLHDR.

WA_ORDTYP-ZRB_SLB_PARA1 = ZRB_SLB_PARA1.

WA_ORDTYP-ZRB_SLB_PARA2 = ZRB_SLB_PARA2.

WA_ORDTYP-ZRB_SLB_PARA3 = ZRB_SLB_PARA3.

WA_ORDTYP-ZRB_SLB_PARA4 = ZRB_SLB_PARA4.

WA_ORDTYP-ZRB_CLSS = ZRB_CLSS.

MODIFY ZRD_ORDTYP FROM WA_ORDTYP.

clear wa.

Re: Data is overwritting in database

Former Member — Fri, 23 Jan 2009 08:07:55 GMT

Hi,

The MODIFY statement inserts one or several lines specified in source in the database table specified in target if those records does not exist in DB, or overwrites existing lines.

Re: Data is overwritting in database

Former Member — Fri, 23 Jan 2009 08:08:07 GMT

Hi,

I don't get your problem. Why do you want duplicate entries in a database table?

Best regards,

Alex.

Re: Data is overwritting in database

Former Member — Fri, 23 Jan 2009 08:17:46 GMT

Hello Pramod,

i think in your data base table the relation between the field is in composite PRIMARY KEY.

composite primary key can be in realtion of two field or more than two field.

the concept of composite primary key is. it check the record with whole primary key Example if you have a three key together in your data base table.than it will compare all three key.if he find any value different in any of the three field than it will allow to enter new record.instead of modifying.

so check your data base table .

hope it will help you to make your concept again.

Thanks

-Arun kayal

Re: Data is overwritting in database

Former Member — Fri, 23 Jan 2009 08:27:24 GMT

Instead of MODIFY , you can use UPDATE to insert tha data in databse table.

UPDATE will add duplicate entries in table but MODIFY will not.

Regards,

Anuja dhondge

Re: Data is overwritting in database

JozsefSzikszai — Fri, 23 Jan 2009 08:30:47 GMT


> I am saving data in database table through screen.but problem is that it should allow duplicate entry
> without overwriting,

According to the design of relational databases (i. e. primary keys), this is not possible at all

Re: Data is overwritting in database

Former Member — Fri, 23 Jan 2009 08:32:25 GMT

UPDATE will just ignore,but will not add duplicates..

Re: Data is overwritting in database

matt — Fri, 23 Jan 2009 08:32:58 GMT


> UPDATE will add duplicate entries in table but MODIFY will not.

No, it won't.

Re: Data is overwritting in database

former_member659396 — Fri, 23 Jan 2009 10:21:15 GMT

hi arun

can u tel me the solution for the same as AUART is my key field in this

please help me.

regards

Rohan

Re: Data is overwritting in database

rainer_hbenthal — Fri, 23 Jan 2009 10:33:03 GMT


UPDATE will add duplicate entries in table

Absolute nonsense!

Re: Data is overwritting in database

rainer_hbenthal — Fri, 23 Jan 2009 10:34:36 GMT


UPDATE will add duplicate entries in table

Absolute nonsense!

Re: Data is overwritting in database

kamesh_g — Fri, 23 Jan 2009 11:23:41 GMT

ITS not advisable to use modify for standard tables ..

its better to use UPDATE or INSERT ...

Re: Data is overwritting in database

Former Member — Fri, 23 Jan 2009 11:32:07 GMT

Hello.

You can research with the type of data that you are going to have in your table and then should deciede how many key fields you need to have to have such kind of data.

In your case you can have more than 1 key field if you want to maintain number of entries for same AUART or you should not have any key field at all.

Hope it helps.

Thanks,

Jayant Sahu.

Re: Data is overwritting in database

former_member659396 — Fri, 30 Jan 2009 10:20:57 GMT