subquery as fieldname

[jkuiper]

I use this query in Delphi

Code: Select all

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.

[Dimon]

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.