> On 18 Nov 2003 at 12:11, Yves Glodt wrote:
>
>>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"
>
> Try YourDataSet.UpdateMode := upWhereKeyOnly;
>
> If PERS_NUMBER is a primary key, you have to get its new value in
> OnNewRecord by another query.

It's not a primary key, and unfortunately I have no access to the source,
we're only a reseller.

But as the app itself allows you to execute sql statements on events
(as after create etc) I guess I will drop the trigger and use a stored proc
that updates PERS_NUMBER after a record has been inserted.

This bde sucks, my trigger works so nice in isq...
Thanks to everybody helping out,
Yves

> SY, Dimitry Sibiryakov.
>
>
>
>
> 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/