OraFAQ Forum: Forms » Problem in Oracle Forms 6i

Home » Developer & Programmer » Forms » Problem in Oracle Forms 6i

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

Problem in Oracle Forms 6i [message #646399]

Wed, 30 December 2015 00:51

haider_1pk
Messages: 135
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

Littlefoot
Messages: 21808
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.

Report message to a moderator

Re: Problem in oracle forums 6i [message #646401 is a reply to message #646400]

Wed, 30 December 2015 01:10

haider_1pk
Messages: 135
Registered: March 2009
Location: PAKISTAN

Senior Member

No .

but forms have 10 row.

Report message to a moderator

Re: Problem in oracle forums 6i [message #646403 is a reply to message #646401]

Wed, 30 December 2015 01:20

Littlefoot
Messages: 21808
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?

Report message to a moderator

Re: Problem in oracle forums 6i [message #646404 is a reply to message #646403]

Wed, 30 December 2015 01:25

haider_1pk
Messages: 135
Registered: March 2009
Location: PAKISTAN

Senior Member

Thanks

I try

Report message to a moderator

Re: Problem in oracle forums 6i [message #646588 is a reply to message #646404]

Tue, 05 January 2016 03:41

shahzaib_4vip@hotmail.com
Messages: 410
Registered: December 2008
Location: karachi

Senior Member

Show you FMB attached file so it can help to understand your question

Regards

Shahzaib

Report message to a moderator

Re: Problem in oracle forums 6i [message #646784 is a reply to message #646588]

Fri, 08 January 2016 11:44

haider_1pk
Messages: 135
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

Report message to a moderator

Re: Problem in oracle forums 6i [message #646803 is a reply to message #646784]

Sat, 09 January 2016 13:42

Littlefoot
Messages: 21808
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.

Report message to a moderator

Re: Problem in oracle forums 6i [message #646811 is a reply to message #646803]

Sun, 10 January 2016 01:34

haider_1pk
Messages: 135
Registered: March 2009
Location: PAKISTAN

Senior Member

Sir which kind of trigger is on.and every records is not inseting double

Report message to a moderator

Re: Problem in oracle forums 6i [message #646820 is a reply to message #646811]

Sun, 10 January 2016 20:23

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 18:28:14 CDT 2024