7 Replies Latest reply on Nov 14, 2011 5:32 PM by Ramki

    How to check whether a table is empty or no records?

    Ramki

      Hi all,

       

      In SQL we check something like this "select <varname>=count(*) from <a table>. Then check <varname> for 0 to check no records in a table without criteria. How to do the same in file maker. count in FM is used for difference purpose. can I say isempty(tablename)?

       

      Thanks

      Ramki