> At 12:11 PM 18/11/2003 +0100, you wrote:
>
>>Hello,

<snip>

>>Now when I create a new record via the application, I get tis message:
>> "[10259] Couldn't perform the edit because another user changed the
>> record"
>
> Point 1: This trigger won't fire because you created it INACTIVE. That
> means the same as "not active", "sleeping", "ignore me".

:) well I created it active. I desactivated it to see if the bevaviour
of the app would change, and it changed.
(my error for posting the script of the already desactivated trigger)

> Point 2: Something unrelated is happening. A Before Insert trigger (if
> it were active, which it isn't) wouldn't have any effect on an update.

The problem exists only on creating (inserting) records (as I wrote above)
Updating works fine. Inserting also, as soon as I desactivate the trigger...

>>I'm not sure there is a way to work around this... The bde is a
>> dependency of the appcation (it's the old 16 bit bde 2.52).
>>Bde settings:
>>SQLPASSTHRUMODE = SHARED NOAUTOCOMMIT
>>SQLQRYMODE = SERVER
>
> [10259] isn't a Firebird exception.

yes I know, it's a bde error message (see subject;-) and it's only here FYI

> heLen
>
>
>
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/