Good to see that the issue is solved, but of curiosity: Why not simply
delete from tplan_kw_pos a
where not exists( select * from tauftr_ge b
where a.auftragsjahr = b.jahr
and a.auftragsnr = b.nr )
Set
2018-06-15 10:38 GMT+02:00 Omacht András [email protected] [firebird-support] <
[email protected]>:
> 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: [email protected] [mailto:firebird-support@
> yahoogroups..com]
> Sent: Friday, June 15, 2018 10:19 AM
> To: [email protected]
> 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]
>
>
>
> ------------------------------------
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Documentation item
> on the main (top) menu. Try FAQ and other links from the left-side menu
> there.
>
> Also search the knowledgebases at http://www.ibphoenix.com/
> resources/documents/
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> ------------------------------------
>
> Yahoo Groups Links
>
>
>
>
