OraFAQ Forum: Forms » Detail Block Problem

Home » Developer & Programmer » Forms » Detail Block Problem (Forms 6i)

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

Detail Block Problem [message #336844]

Tue, 29 July 2008 03:33

astaputra
Messages: 11
Registered: July 2008

Junior Member

Hello,

I have one control block, in that 3 text boxes and LOVs are attached and a button to populate details. I will select any one and press submit button, then it will populate related detail records and show it in detailed block. In that user has chance to change or update Received Order and press save, then it has to update only received order for that particular Order No.

if i have 3 rows in detail table, then it is creating 3 more rows same as existing.

I dont need to create new rows i need to only update.
Can any one help me in this issue please.

Thanks
Akash

[Updated on: Tue, 29 July 2008 04:50]

Report message to a moderator

Re: Detail Block Problem [message #336875 is a reply to message #336844]

Tue, 29 July 2008 04:52

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Regarding information you've provided, it is difficult to guess what might be wrong. I suspect that there's INSERT INTO statement somewhere which creates the same records as the ones that exist in the database. As "storing changes" is Forms default behaviour, there's no need for additional INSERT INTO statement.

Furthermore, if there was a primary key on the table, you'd probably get DUP-VAL-ON-INDEX error.

However, if that's not the case, I have no idea.

Report message to a moderator

Re: Detail Block Problem [message #336879 is a reply to message #336844]

Tue, 29 July 2008 05:00

rakesh.oracle
Messages: 4
Registered: July 2008

Junior Member

if u send to me .fmb file for that i can help u

[Updated on: Tue, 29 July 2008 05:07]

Report message to a moderator

Re: Detail Block Problem [message #336909 is a reply to message #336879]

Tue, 29 July 2008 05:48

astaputra
Messages: 11
Registered: July 2008

Junior Member

Hi Rakesh and Littlefoot,
thanks for your suggestion. Sure rakesh i will definetly send you the fmb. Please give me some time. Right now i am in meeting. Once i am back, i will send it to you.

Once again thanks for your guidance guys.

Take care

Bye
Akash

Report message to a moderator

Re: Detail Block Problem [message #337562 is a reply to message #336909]

Thu, 31 July 2008 04:31

astaputra
Messages: 11
Registered: July 2008

Junior Member

Hi Rakesh and Littlefoot,
First of all very very sorry for deley in reply. Problem was solved. I didnt used any high fundas. Just i made control blocks and in the key_commit, i am directly updating the column which i need to update by taking that particular po number thats all.

once again thanks for your valuable suggestions.

Thanks and take care

Akash

Report message to a moderator

Previous Topic:	D2K Report not run
Next Topic:	Leading Zeros when exporting from forms

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Sep 23 08:57:31 CDT 2025