opencirrus

ExecuteSQL problem

Discussion created by opencirrus on Feb 11, 2014
Latest reply on Feb 11, 2014 by opencirrus

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'

Outcomes