AnsweredAssumed Answered

Storing a calc while it is in focus

Question asked by tays01s on Oct 26, 2017
Latest reply on Oct 30, 2017 by tays01s

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?

Outcomes