Re: updateValuesInRowDescribedByQualifier - Exception
Re: updateValuesInRowDescribedByQualifier - Exception
- Subject: Re: updateValuesInRowDescribedByQualifier - Exception
- From: Art Isbell <email@hidden>
- Date: Thu, 22 May 2003 12:36:21 -1000
On Thursday, May 22, 2003, at 11:46 AM, Rui Dias wrote:
i agre with your point, but the problem is that when you execute one
update,
the table as an update trigger associated, we use this trigger to be
able to
syncronize tables, and the problem is that not only one row would be
afected
but 3, any ideas how i can change the number of rows affected.
I think this exception is thrown because the qualifier selected more
than one row prior to any update occurring. Does the "where" clause in
the SQL generated select more than one row?
EOF knows nothing about triggers. Triggers can cause problems with
EOF because database changes are occurring outside of EOF, so EOF's
snapshots may no longer be synchronized with the database data. It
would be better to implement these triggers in EOF and remove them from
the database, but this would work only if other non-EOF processes
aren't modifying the database.
If you must use triggers, you could refetch all rows updated by the
trigger with refreshing refetched data enabled. That would keep EOF
synchronized with the database.
An update trigger shouldn't fire until the update completes, and I
don't think the update will occur in this case because of the
exception. Thus, I don't think the trigger is involved at all with
this exception.
Aloha,
Art
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.