8 Replies Latest reply on May 17, 2013 11:23 AM by DavidJondreau

    Execute SQL problem?

    productionQC

      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