Home » Developer & Programmer » Forms » Problem with block based on a complex view (Patched Froms 6)
icon4.gif  Problem with block based on a complex view [message #431360] Tue, 17 November 2009 02:37 Go to next message
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
Re: Problem with block based on a complex view [message #431393 is a reply to message #431360] Tue, 17 November 2009 04:02 Go to previous messageGo to next message
Littlefoot
Messages: 20824
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.
Re: Problem with block based on a complex view [message #431422 is a reply to message #431360] Tue, 17 November 2009 05:12 Go to previous messageGo to next message
imedmy
Messages: 16
Registered: November 2009
Location: tunis
Junior Member
thunkx LittelFoot
Re: Problem with block based on a complex view [message #431425 is a reply to message #431360] Tue, 17 November 2009 05:14 Go to previous messageGo to next message
imedmy
Messages: 16
Registered: November 2009
Location: tunis
Junior Member
i forgot to ask how should i set DML data target
thunkx for reply
icon5.gif  Re: Problem with block based on a complex view [message #431476 is a reply to message #431425] Tue, 17 November 2009 09:28 Go to previous message
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
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:
  


Current Time: Sat Sep 24 23:09:19 CDT 2016

Total time taken to generate the page: 0.25910 seconds