Computed Columns

sandeep_c24 · Post by **sandeep_c24** » 24.03.2008, 05:42

Currently Zeos allows computed columns to be edited but an exception is raised as soon as the record is posted. Should computed columns be marked as read-only?

Sandeep

Post by **mdaems** » 25.03.2008, 00:14

This reasoning seems logical.
2 remarks :

How about existing code
Isn't this kind of errors caused by the compiler instead of the zeos library? I remember the 'autoincrement' column problem which was caused by a standard Delphi Dataset behavior.

Mark

sandeep_c24 · Post by **sandeep_c24** » 25.03.2008, 07:49

I think existing code will not break as database engines don't allow updates to computed columns.

Sandeep

Post by **mdaems** » 25.03.2008, 08:37

I agree... as far as setting these readonly property to true doesn't influence the behavior of queries with an attached TZUpdateSQL object. Because in these queries you could enable updates of Calculated fields.
Do you have a patch sugestion?
Please log an issue in the bug tracker, so we don't forget about it.

Mark

sandeep_c24 · Post by **sandeep_c24** » 26.03.2008, 07:32

I have logged about this in Bug tracker.

Sandeep