refresh(record) on query with sum doesn't work
Posted: Thu 22 Jan 2009 14:31
I put an MyQuerycomponent with this query
It is a detail query related to my master table. when I go to my childform and close it again, I use refreshrecord on the detail table, so I can see the new sum. The refreshing doesn't work and Delphi comes with the error
Project raised exception class EMySQLException with message '
#42S22Unknown column 'ontvangenbollen'in 'fieldlist''
This AV also occurs when I put the fields in the fieldlist @Designtime and set the field ontvangen.readonly := true;
I'm using MyDAC 5.70.0.42
Code: Select all
SELECT ontvangsten.snr, ontvangsten.inkoopregelnummer,
SUM(ontvangsten.aantal_bollen) AS ontvangenbollen
FROM ontvangsten
WHERE ontvangsten.snr = :snr
GROUP BY ontvangsten.snr, ontvangsten.inkoopregelnummer
Project raised exception class EMySQLException with message '
#42S22Unknown column 'ontvangenbollen'in 'fieldlist''
This AV also occurs when I put the fields in the fieldlist @Designtime and set the field ontvangen.readonly := true;
I'm using MyDAC 5.70.0.42
