Home » Developer & Programmer » Forms » duplicate specific data in the same table (Oracle Forms 10g)
duplicate specific data in the same table [message #658425] Tue, 13 December 2016 15:03 Go to next message
mfmoody
Messages: 2
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 .
Re: duplicate specific data in the same table [message #658426 is a reply to message #658425] Tue, 13 December 2016 15:23 Go to previous messageGo to next message
BlackSwan
Messages: 26649
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
Re: duplicate specific data in the same table [message #658427 is a reply to message #658426] Tue, 13 December 2016 15:27 Go to previous messageGo to next message
mfmoody
Messages: 2
Registered: December 2016
Junior Member
Thanks for your quick reply,
I want to make another copy of specific rows in the same table.
Re: duplicate specific data in the same table [message #658428 is a reply to message #658427] Tue, 13 December 2016 15:38 Go to previous message
BlackSwan
Messages: 26649
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.
Previous Topic: Forms not running
Next Topic: Excell Report Genearation With Formula (merged by MC)
Goto Forum:
  


Current Time: Sun Jan 26 10:17:36 CST 2020