OraFAQ Forum: Forms » problem in retrieving record

Home » Developer & Programmer » Forms » problem in retrieving record (oracle 10G forms)

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

problem in retrieving record [message #565673]

Thu, 06 September 2012 02:24

poojamunj
Messages: 64
Registered: May 2011
Location: MUMBAI

Member

Hello,

Sir, I have two blocks on which I am having relation based on booking number and employee code. As I am doing a query, booking number is getting fetched in employee code's field and employee code is getting fetched in booking number's feild. Because of this, I am not able to update the form. It is giving me error unable to update record unique contraint voilated for primary key which is quite obivious. But why the data could get shuffled in each others field though during inserting its going properly.
Please help...

Report message to a moderator

Re: problem in retrieving record [message #565674 is a reply to message #565673]

Thu, 06 September 2012 02:29

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

Senior Member
Account Moderator

How exactly do you perform QUERY operation? Do you enter query mode, enter search criteria, execute query (i.e. you let the Forms engine do the job)? Or do you populate items manually (SELECT ... INTO ...)?

Report message to a moderator

Re: problem in retrieving record [message #565678 is a reply to message #565674]

Thu, 06 September 2012 03:48

poojamunj
Messages: 64
Registered: May 2011
Location: MUMBAI

Member

Sir the problem of shuffling the data in diferent items go sorted out. Now during execute query(i.e through form engine) the exact data is getting fetched in respected fields. But still its throwing me an error as unable to update unique contraint violated for primary key.According to my knowledge it is trying to insert the record rather than to update. Why its happening so though I hv given relation on two blocks.

Report message to a moderator

Re: problem in retrieving record [message #565681 is a reply to message #565678]

Thu, 06 September 2012 04:05

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

Senior Member
Account Moderator

How do you perform updates and inserts? Did you write your own code for that (i.e. INSERT INTO and UPDATE statements)?

Report message to a moderator

Re: problem in retrieving record [message #565683 is a reply to message #565681]

Thu, 06 September 2012 04:27

poojamunj
Messages: 64
Registered: May 2011
Location: MUMBAI

Member

I am inserting and updating through form itself.Since I have already maintained relations between two blocks I need not write an update statement. It should get automatically updated as I am saving the form.

Report message to a moderator

Re: problem in retrieving record [message #565685 is a reply to message #565683]

Thu, 06 September 2012 04:35

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

Senior Member
Account Moderator

That seems to be OK (I was afraid that you might have done it manually).

OK then: there are two blocks (master-detail). Unique constraint is being violated in the detail block, right? If that's so, what is detail block's underlying table's primary key set to? Is it just a single column? If so, no wonder that uniqueness is violated because every new record in the detail block keeps the same primary key value (inherited from the master block). Maybe you should modify the primary key so that it contains additional column(s) or, possibly, distinguish detail table's primary key from its foreign key (which makes a relation between master and detail table).

Report message to a moderator

Re: problem in retrieving record [message #565703 is a reply to message #565685]

Thu, 06 September 2012 06:02

poojamunj
Messages: 64
Registered: May 2011
Location: MUMBAI

Member

Sir I'll explain you the entire scenario.
I am working on travel module system in which i have three blocks.
In first block i.e. header block the booking number comes.
In second block i.e. Employee detail block, the names of employees and there details come
and in third block i.e. Travel detail block, the respected travel details come.
In third block, the primary key comprises of three columns i.e. booking number+employee code+travel number.
Now I am maintaining realtions from header block to employee detail by inheriting booking number,
from employee detail to travel detail by inheriting booking number and employee code.
It is thowing me error on third block during modify process wherin it is not allowing me to update travel detail
under given booking number for selected employee.

Report message to a moderator

Re: problem in retrieving record [message #565709 is a reply to message #565703]

Thu, 06 September 2012 06:35

cookiemonster
Messages: 13925
Registered: September 2008
Location: Rainy Manchester

Senior Member

Well you've set something up wrong, but we can't really tell what with the information provided.
When you get the error select 'display error' from the help menu. That'll show what exact statement forms is issuing to get the error.

Report message to a moderator

Previous Topic:	Forms 6i Key-help not fired under application
Next Topic:	Forms calling mapviewer

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 03 10:39:32 CDT 2024