
SQL chyba
Co může znamenat následující Firebird SQL chyba?
cursor identified in the UPDATE or DELETE statement is not positioned on a row.No current record for fetch operation.
Dotaz:
select cast(lsd.OrdNumber as integer), fi.Name,
ib_decodedate_day(lsd.Docdate$date) || '.' || ib_decodedate_month(lsd.Docdate$date) || '.' || ib_decodedate_year(lsd.Docdate$date),
lsd.id from LogStoreDocuments lsd, Firms fi
left join STOREDOCUMENTS on lsd.STOREDOCUMENT_ID = STOREDOCUMENTS.ID
left join FIRMOFFICES on FIRMOFFICES.ID = STOREDOCUMENTS.FIRMOFFICE_ID
left join addresses on FirmOffices.ADDRESS_ID = addresses.id
where lsd.Firm_ID = fi.ID and
lsd.x_zpracoval_terminal <> 'A' and lsd.documentType = 32
ib_decodedate_day(lsd.Docdate$date) - to je nejaka procedura alebo funkcia?
nasiel som k tomu nieco: faq144