AnsweredAssumed Answered

SQL calculation field

Question asked by tays01s on Aug 19, 2018
Latest reply on Aug 20, 2018 by tays01s

I have a calc field:

ExecuteSQL("SELECT \"__uuID\" FROM \"IO\" WHERE \"__uuID\"=?";"";"";Patient::IO_n)


that is 'text' and 'does not store calcs'. In data viewer the calc correctly gets the uuID, but the field remains empty and Data viewer indicates: <index missing>.


A different version of solution using what appeared to be the same fields and calc did work, but I haven't spotted the difference and error in the new version.