Home » Developer & Programmer » Forms » Problem in Oracle Forms 6i
Problem in Oracle Forms 6i [message #646399] Wed, 30 December 2015 00:51 Go to next message
haider_1pk
Messages: 111
Registered: March 2009
Location: PAKISTAN
Senior Member
Hello Friends ,


I am facing the problem in oracle`s forums.
I am inserting one record but when I saved record, automatically saved same record in two times.


Example


Customer id customer name address
1 abc xzy
After saved

Customer id customer name address
1 abc xzy
1 abc xzy

Kindly guide me .

Regards,

Haider Ali


[EDITED by LF: fixed topic title typo; was "forums"]

[Updated on: Wed, 30 December 2015 02:38] by Moderator

Report message to a moderator

Re: Problem in oracle forums 6i [message #646400 is a reply to message #646399] Wed, 30 December 2015 00:57 Go to previous messageGo to next message
Littlefoot
Messages: 21575
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Did you write any code by yourself? In other words, is there any INSERT INTO statement you wrote? If so, remove it.
Re: Problem in oracle forums 6i [message #646401 is a reply to message #646400] Wed, 30 December 2015 01:10 Go to previous messageGo to next message
haider_1pk
Messages: 111
Registered: March 2009
Location: PAKISTAN
Senior Member
No .

but forms have 10 row.
Re: Problem in oracle forums 6i [message #646403 is a reply to message #646401] Wed, 30 December 2015 01:20 Go to previous messageGo to next message
Littlefoot
Messages: 21575
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
It is a tabular form with 10 rows, then? Well, it doesn't matter. Default Forms processing knows how to handle it.

As it seems to be a simple form, I'd suggest you to create it once again (i.e. create a brand new form). Use the Data Block wizard and follow its instructions. Once you're done, you'll have a new tabular form. Run it and enter the same "1 abc xzy" values and save it. What happens?
Re: Problem in oracle forums 6i [message #646404 is a reply to message #646403] Wed, 30 December 2015 01:25 Go to previous messageGo to next message
haider_1pk
Messages: 111
Registered: March 2009
Location: PAKISTAN
Senior Member
Thanks


I try
Re: Problem in oracle forums 6i [message #646588 is a reply to message #646404] Tue, 05 January 2016 03:41 Go to previous messageGo to next message
shahzaib_4vip@hotmail.com
Messages: 400
Registered: December 2008
Location: karachi
Senior Member
Show you FMB attached file so it can help to understand your question

Regards

Shahzaib
Re: Problem in oracle forums 6i [message #646784 is a reply to message #646588] Fri, 08 January 2016 11:44 Go to previous messageGo to next message
haider_1pk
Messages: 111
Registered: March 2009
Location: PAKISTAN
Senior Member
Hello Friends

I did every thing but could not able to success . Even that i try to insert record in sql but same inserting double records.Kindly help me.

I wana tell u that first i made in oracle 9i . And DMP file update in oracle 10 G
Re: Problem in oracle forums 6i [message #646803 is a reply to message #646784] Sat, 09 January 2016 13:42 Go to previous messageGo to next message
Littlefoot
Messages: 21575
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
If inserting through SQL*Plus results in two records, check whether there's a database trigger on that table.
Re: Problem in oracle forums 6i [message #646811 is a reply to message #646803] Sun, 10 January 2016 01:34 Go to previous messageGo to next message
haider_1pk
Messages: 111
Registered: March 2009
Location: PAKISTAN
Senior Member
Sir which kind of trigger is on.and every records is not inseting double
Re: Problem in oracle forums 6i [message #646820 is a reply to message #646811] Sun, 10 January 2016 20:23 Go to previous message
garan
Messages: 27
Registered: January 2016
Junior Member
Hi

Please check USER_TRIGGERS or DBA_TRIGGERS what are the triggers associated to the customer table and then check the logic inside that trigger

SELECT TRIGGER_NAME FROM USER_TRIGGERS WHERE TABLE_NAME=<CUSTOMER_TABLE>


garan

Previous Topic: VALIDATING QTY
Next Topic: Add (+/-) Button Number Increment
Goto Forum:
  


Current Time: Mon Jul 13 07:42:49 CDT 2020