frm-41050 update's but say's cannot update???

[doomtheflame]

Im wondering something...

I had a colleague who made a form (master block and a detail block)
that does an update ((plsql) on a record of the detail) on the previous
record's ending date minus a day of beginning date of a new record
created... Block update property set to no item update property set to
no and then does execute_query to refresh the visual there would be no
problem...

I did the same thing and I have a frm-41050 error message cannot update
when I execute_query. I tried to set the block update property to yes
and the item to no so that i can use a when_validate on the block an
create my items with set_item_instance_property as a new record is
needed everything works fine on the update side when i execute_query.
The problem now is I get an (do you want to save the changes you have
made) when I go to next record in the master block even if i didnt
change nothing. Because the update property on the block sets the
status to changed...

But the real problem is that my colleague did it without changing the
block update property...

HOW DID HE DO IT

You will say ask him = the answer is he don't work here no more...

thanks in advanced for those who can enlighten me on the problem...
[Updated on: Mon, 21 March 2005 15:54]

[Daniel Morgan]

doomtheflame wrote:
Im wondering something...

I am too. Why did you feel compelled to post the exact same thng 4 times
using two different subjects? Think the internet has too much bandwidth? ;-)

The version number and code snippet would help.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)

[doomtheflame]

I am sorry I was new to this group and when I posted i didnt see my
message appear so i reposted...
As for the multiple quotes in this post i dont know how it happened...

SORRY...

Version 6i developper...

For code snippet i wouldnt say it would be that since I copied my
triggers in his form...

Its the propertie settings... I think but i am not sure...