Ramki

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

Discussion created by Ramki on Nov 14, 2011
Latest reply on Nov 14, 2011 by 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

Outcomes