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]



------------------------------ ------

------------------------------ ------

++++++++++++++++++++++++++++++ ++++++++++++++++++++++++++++++ ++++++

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-digest@ yahoogroups.com
    firebird-support-fullfeatured@ yahoogroups.com

<*> To unsubscribe from this group, send an email to:
    firebird-support-unsubscribe@ yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
    https://info.yahoo.com/legal/ us/yahoo/utos/terms/