malachydevlin

executesql

Discussion created by malachydevlin on Feb 14, 2015
Latest reply on Feb 14, 2015 by malachydevlin

Hi, I have an oddity in ExSQL.

If I make a calculated field = to e.g

ExecuteSQL ("SELECT SURNAME FROM CUSTOMERS WHERE ID=4" ; "" ;""  )

then I get the surname "Bloggs".

 

If (in a script step) I say set field (or even variable, show message) = to

ExecuteSQL ("SELECT SURNAME FROM CUSTOMERS WHERE ID=4" ; "" ;""  )

the exact same statement.

 

I get no error but only "?"

 

strange?

Outcomes