I have a form that access a table through a TADOQuery control which has its contents edited through a Data Grid.
It was working fine until I added a calculated field to the TADOQuery and inserted code in its OnCalcFields event like this...
with ADOQUERYTABLEX do begin
:= FieldByName('FIELDY').Value * FieldByName('FIELDZ').Value ;
Now whenever I try to assign any values to the table's other fields, the following exception is raised.
"Invalid value for field 'FIELDX' "
Whats going on?