why will resfresrecord not working
Posted: Fri 04 Dec 2009 15:00
This is my query
The user of the application can push on a button to tell the application the invoice is payed. But when I using refreshrecord, Delphi comes with this error
Offcourse I can do a full refresh, but why should I do this and not only for one record by using refreshrecord?
Code: Select all
SELECT facturen.factuurID, facturen.factuurnummer, contracten.contractnummer,
contracten.contractID,
facturen.jaar, facturen.maand, facturen.factuurbedrag, facturen.betaald,
CONCAT(aanvragers.voornaam,' ', aanvragers.tussenvoegsels,' ',aanvragers.klantnaam) AS klantvoluit,
CONCAT(gastouder.voornaam,' ',gastouder.tussenvoegsels,' ',gastouder.oudernaam) AS gastoudervoluit
FROM facturen
LEFT OUTER JOIN contracten ON facturen.contractID = contracten.contractID
INNER JOIN aanvragers ON contracten.klantID = aanvragers.klantID
INNER JOIN gastouder ON contracten.gastouderID = gastouder.ouderID
ORDER BY facturen.factuurnummer DESC
Code: Select all
Project ChildHome.exe raised exception class EMySqlException with message '
#42S22Unknown column 'klantvoluit' in 'field list''.