0 Replies Latest reply on Feb 15, 2011 7:24 PM by MikeDever

    SQL command POW does not work.

    MikeDever

      Summary

      SQL command POW does not work.

      Product

      FileMaker Pro

      Version

      11.0v3

      Operating system version

      10.6

      Description of the issue

      SELECT POW( 7,2 ) FROM dual  
      - does not work.
      - correct answer is 47
      I get Error:

      com.filemaker.jdbc.FMSQLException: [FileMaker][FileMaker JDBC] FQL0030/(1:7): "POW" is an invalid function.