13 Replies Latest reply on Apr 14, 2016 12:38 PM by CICT

    ExecuteSQL Returns Empty string when querying schema objects

    coherentkris

      Why would this return null string ExecuteSQL ( "SELECT * FROM FileMaker_Tables" ; "" ; "" ) when run on a file with native tables/TO's and odbc data source tables/TO's?

      Its NOT returning "?" so the syntax is right.

      Windows 7 ent sp 1. FMA 13v3 connecting to FMS 13 v10.

      Occurs in data Viewer and Set Var in script.

      Cant select any single elements that are supposed to be returned by the Tables object either.

      Length ( ExecuteSQL ( "SELECT BaseTableName FROM FileMaker_Tables" ; "" ; "" ) ) = 0 = True.

       

      Update 1:

      Seems local to one file in my system and recover did not show any issues on the most recent backup ( about an hour ago ).

       

      Update 2:

      Bumped up to FMPA13_05 and issue persists.

      Rebooted server and issue persists.

       

      Update 3:

      Forcing the ExecuteSQL to run on the server still returns null string.

       

      Update 4:

      Created a copy of the file and hosted it on the server returns same null string result.

       

      Leia said it best when she said "Help me Obi Wan. Your my only hope."