AnsweredAssumed Answered

SQL command POW does not work.

Question asked by MikeDever on Feb 15, 2011

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.

Outcomes