I have an SQL calc field. The calc is correct when in focus, but if I move to a later record that contains a blank field for the calculated value, all the records in the field show '?'. The calc uses this script:
ExecuteSQL("SELECT SUM (in_water) FROM FeedsUsed WHERE Route='e' AND \"_IOuuID\"=?";"";"";IO::__uuID)
IO::__uuID is used to ID the record.
Why might a change of the record selected change this calc?