AnsweredAssumed Answered

Built-in Function v. SQL

Question asked by PJSpark on Sep 28, 2012
Latest reply on Sep 28, 2012 by philmodjunk

Title

Built-in Function v. SQL

Post

     Hi,

     I have a quick question for the pros!

     I would like to know which would be more reliable, quicker and or effecient using FMP 12

     Using FMPs built-in function, like get(totalrecordcount)

     vs.

     Using FMPs ExecuteSQL("SELECT COUNT * FROM [table]";"";"")

     Just curious if anyone has tried something like this.

     I guess I should say from a table containing a modest 50-100 k in records.

     Thanks for your time

      

Outcomes