why will resfresrecord not working

jkuiper · Post by **jkuiper** » Fri 04 Dec 2009 15:00

This is my query

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

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

Code: Select all

Project ChildHome.exe raised exception class EMySqlException with message '
#42S22Unknown column 'klantvoluit' in 'field list''.

Offcourse I can do a full refresh, but why should I do this and not only for one record by using refreshrecord?

swierzbicki · Post by **swierzbicki** » Sat 05 Dec 2009 08:37

You should set the FullRefresh option to true. It will works then.

Dimon · Post by **Dimon** » Mon 07 Dec 2009 07:51

Please let me know if the problem was solved.