Can anyone help with the following problem I am having with an ExecuteSQL calculation. I have the destination field set to calculation, and the calculation works fine if I replace the LOWER ID with the actual record that I'm trying to retreive.
This points and returns the correct record as expected:
- ExecuteSQL ( "SELECT assemblyPN FROM Assemblies WHERE ASSEMBLYID = 36" ; "" ; "" ; "")
This returns a ? as it is not picking up on the correct LOWER ID (note the field is structure::LOWER ID):
- ExecuteSQL ( "SELECT assemblyPN FROM Assemblies WHERE ASSEMBLYID = LOWER ID" ; "" ; "" ; "")
I suspect my issue is with the syntax used in the WHERE ASSEMBLYID = LOWER ID, can anyone check if my syntax is correct please?
(I have tried the following WHERE ASSEMBLYID = 'LOWER ID'