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-supp...@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]
------------------------------------
------------------------------------
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
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
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)
<*> To change settings via email:
firebird-support-dig...@yahoogroups.com
firebird-support-fullfeatu...@yahoogroups.com
<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com
<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/
