OraFAQ Forum: Forms » Problem with block based on a complex view

Home » Developer & Programmer » Forms » Problem with block based on a complex view (Patched Froms 6)

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

Problem with block based on a complex view [message #431360]

Tue, 17 November 2009 02:37

imedmy
Messages: 16
Registered: November 2009
Location: tunis

Junior Member

hi all
i try to built a block based on a complex view that select data from tow table Embarassed

( NB trigger instead of insert update work perfectly ok)
the problem that facing me is that when i open form i can insert record work fine but after query i try to insert i get alert that i can't insert record into view
So i do message to check system form status block status and record status
i get this result :
before query :
Query NEW NEW
On query
Query Query Query
After query && on new record instance
Query Query NEW

please help me to get a solution

best regards
imed

Report message to a moderator

Re: Problem with block based on a complex view [message #431393 is a reply to message #431360]

Tue, 17 November 2009 04:02

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

Senior Member
Account Moderator

You'll need to "simulate" insert/update/delete by writing your own code for these actions; put it into ON-INSERT, ON-UPDATE, ON-DELETE triggers.

Report message to a moderator

Re: Problem with block based on a complex view [message #431422 is a reply to message #431360]

Tue, 17 November 2009 05:12

imedmy
Messages: 16
Registered: November 2009
Location: tunis

Junior Member

thunkx LittelFoot

Report message to a moderator

Re: Problem with block based on a complex view [message #431425 is a reply to message #431360]

Tue, 17 November 2009 05:14

imedmy
Messages: 16
Registered: November 2009
Location: tunis

Junior Member

i forgot to ask how should i set DML data target
thunkx for reply

Report message to a moderator

Re: Problem with block based on a complex view [message #431476 is a reply to message #431425]

Tue, 17 November 2009 09:28

javed.khan
Messages: 340
Registered: November 2006
Location: Banglore

Senior Member

I guess there is a block property "DML Target" in advance database section. Thought u have to specify a data target there.

Jak

Report message to a moderator

Previous Topic:	Form Personalization using custom.pll - LOV to be deleted from the existing record group.
Next Topic:	Forms MDI windows maximized but Status line hidden, using separateFrame=True

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 06:43:03 CDT 2024