OraFAQ Forum: Forms » duplicate specific data in the same table

Home » Developer & Programmer » Forms » duplicate specific data in the same table (Oracle Forms 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

duplicate specific data in the same table [message #658425]

Tue, 13 December 2016 15:03

mfmoody
Messages: 3
Registered: December 2016

Junior Member

hello,
I have a tabular form which display 10 of records for each column.

I want to re-insert specific data in the same table after some change I will make.

but it does not work because of primary key .

Report message to a moderator

Re: duplicate specific data in the same table [message #658426 is a reply to message #658425]

Tue, 13 December 2016 15:23

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

mfmoody wrote on Tue, 13 December 2016 13:03

hello,
I have a tabular form which display 10 of records for each column.

I want to re-insert specific data in the same table after some change I will make.

but it does not work because of primary key .

INSERT pushes new rows into a table.
If you insist upon doing another INSERT, then first you must DELETE the rows.
Otherwise to change existing rows you must use UPDATE instead of INSERT.

Welcome to this forum

Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide
How to use {code} tags and make your code easier to read

Report message to a moderator

Re: duplicate specific data in the same table [message #658427 is a reply to message #658426]

Tue, 13 December 2016 15:27

mfmoody
Messages: 3
Registered: December 2016

Junior Member

Thanks for your quick reply,
I want to make another copy of specific rows in the same table.

Report message to a moderator

Re: duplicate specific data in the same table [message #658428 is a reply to message #658427]

Tue, 13 December 2016 15:38

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

mfmoody wrote on Tue, 13 December 2016 13:27

Thanks for your quick reply,
I want to make another copy of specific rows in the same table.

You can want to fly like a bird.
You don't always get what you want.

Primary Key exists to prevent duplicates.
Either disable or drop the PK, OR provide a new & different PK value.

Report message to a moderator

Previous Topic:	Forms not running
Next Topic:	Excell Report Genearation With Formula (merged by MC)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 15 15:49:29 CST 2025