Devart Forums

Posted: **Thu 22 Jan 2009 12:15**

I use this query in Delphi

SELECT inkoopregels.*
  (SELECT SUM(aantal_bollen) FROM ontvangsten
    WHERE ontvangsten.inkoopregelnummer = inkoopregels.inkoopregelnummer) AS ontvangenbollen
FROM inkoopregels

Will the field "ontvangenbollen" be seen as a readonly field. For now I put the the fieldvalue into a integer variable to work with it. And I'm not really sure if MyDAC is asking to put that field in editmode to change it.

Posted: **Fri 23 Jan 2009 08:58**

This field is an aggregated field and it can not be edited. But its ReadOnly property is set to False by default.
To set ReadOnly to True you should set the TMyQuery.Options.SetFieldsReadOnly property to True.

Devart Forums

subquery as fieldname

subquery as fieldname