Execute SQL problem?
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