A standard template for bulletproof ExecuteSQL in FileMaker.

ExecuteSQL Template

Let (
  [
    _alias = "a";

    _a_pro			= devp.GetTableName ( PRO::___PRO ) & " " & _alias;
    _a_act			= _alias & "." & devp.GetFieldName ( PRO::__f_ACT );
    _a_ka_project_id	= _alias & "." & devp.GetFieldName ( z_base_project_id ) ;

    _sql =	"SELECT MAX( "	& _a_ka_project_id & " ) 
		 FROM "	& _a_pro & " 
		 WHERE "	& _a_act & " = ? " ;

    _query_result = ExecuteSQL ( _sql ; devp.Nil ; devp.Nil ; __f_ACT );

    _result = _query_result + 1
  ] ;  

  _result
)