Hi Anonymous!

I think you sould check and run if correct this statement:

delete from tplan_kw_pos x
where not exists (select 1
from tplan_kw_pos a
inner join tauftr_ge b on a.auftragsjahr = b.jahr and a.auftragsnr = b.nr
where a.id = x.id)

Andr�s

From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Sent: Friday, June 15, 2018 10:19 AM
To: firebird-support@yahoogroups.com
Subject: [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?

Thank you.





__________ Information from ESET Mail Security, version of virus signature database 17555 (20180615) __________

The message was checked by ESET Mail Security.
http://www.eset.com



__________ Information from ESET Mail Security, version of virus signature database 17555 (20180615) __________

The message was checked by ESET Mail Security.
http://www.eset.com



[Non-text portions of this message have been removed]