On 2018-06-15 10:37, 'Check_Mail' check_mail@...
[firebird-support] wrote:

> Sorry, there is a before delete trigger active, it ist he problem
> (firebird has changed the weird sequence in FB3, in FB2.5 it works.

I'm not sure what you are trying to say here. What do you mean with
"firebird has changed the weird sequence in FB3"? And if you think
you've found a bug, then please report it in the tracker.

Mark

> VON: firebird-support@yahoogroups.com
> <firebird-support@yahoogroups.com>
> GESENDET: Freitag, 15. Juni 2018 10:19
> AN: firebird-support@yahoogroups.com
> BETREFF: [firebird-support] Delete issue
>
> Hello,
>
> I would like to delete all records, where no order number already
> exists in the table tauftr_ge. Here an example of the statement:
>
> delete from tplan_kw_pos x where x.id = (select a.id from
> tplan_kw_pos a left join tauftr_ge b on a.auftragsjahr = b.jahr and
> a.auftragsnr = b.nr where b.nr is null and a.id = x.id)
>
> I get an error, The cursor identified in the UPDATE or DELETE
> statement is not positioned on a row.
>
> no current record for fetch operation.
>
> It looks simple, delete some records, but what can be wrong?