AnsweredAssumed Answered

Execute SQL problem?

Question asked by productionQC on May 14, 2013
Latest reply on May 17, 2013 by DavidJondreau

Title

Execute SQL problem?

Post

     Hello-

     I am trying to get a basic operation using Execute SQL to work and all it returns is a "?" in the field.

     I have a table named CYLINDERS and layout call CylTable.  In this layout I have it set to table view and my columns are as follows.

     CylNo.  Age  Result  Date 

      

     I have a field setup as a calcualtion with the following formula:ExecuteSQL( "select count(*) from CYLINDERS
     where Age=7" ; "" ; "")

     my intention was to have this function count all of the rows that contain an age of 7.  Instead I just a "?".  I have seen many examples of this being used and can't seem to get it to work...any ideas
      

      

Outcomes