gwinzeler

executeSQL

Discussion created by gwinzeler on Jul 9, 2012
Latest reply on Jan 20, 2014 by user19752

using the following for conditional formatting and works fine but when I try to use in a field as a calculation it doesn't work...

 

conditional formatting

0 < ExecuteSQL ( "select count (*) from tableA where rowID = ?" ; "" ; "" ; $$rowD)

 

field calculation

fieldtest = ExecuteSQL ( "select count (*) from tableA where rowID = ?" ; "" ; "" ; $$rowD)

Outcomes