Fehler: SQLDataSourceItem.runSql() - Statement: SELECT config.intkey, btyp.vkpreis, btyp.memberpreis, btyp.bez, bpreisl.von, bpreisl.bis, btyp.ispreisgrp0, btyp.ispreisgrp1 FROM config, btyp, bpreisl where config.mand_refkey = 'xbrain' AND config.division_refkey = 'squash' AND btyp.config_refkey = config.intkey AND lower(btyp.refkey) ILIKE 'eb%' AND bpreisl.btyp_refkey = btyp.intkey AND isft is true AND ( btyp.ispreisgrp0 is true OR btyp.ispreisgrp1 is true ) ORDER BY bpreisl.von SQL-Exception: This statement has been closed. state=55000
Fehler: SQLDataSourceItem.runSql() - Statement: SELECT buchung.intkey, buchung.thekeninfo, buchung.betrag, buchung.paydate, buchung.von, buchung.menge, buchung.status, buchung.card_intkey, buchung.text, customer.*, buchung.partner_refkey, partner.name AS partner_name, partner.vname AS partner_vname, abo.paydate AS abo_paydate, abo.vkpreis * buchung.menge AS abo_betrag, card.paydate AS card_paydate, card.vkpreis * buchung.menge AS card_betrag, buchung.isdisease, buchung.isholiday FROM customer, buchung left outer join abo on (abo.intkey = buchung.abo_intkey) left outer join card on (card.intkey = buchung.card_intkey) left outer join customer partner on (partner.mand_refkey = buchung.mand_refkey AND partner.refkey = buchung.partner_refkey) where buchung.mand_refkey = 'xbrain' AND buchung.division_refkey = 'squash' AND buchung.divnr = 3 AND buchung.datum = '2024-03-21' AND customer.mand_refkey = buchung.mand_refkey AND customer.refkey = buchung.customer_refkey ORDER BY buchung.von SQL-Exception: This statement has been closed. state=55000
WEB-App