how to check if table is empty?

[amb3r]

Hiya guys,

I need to write a code to check if a table is empty (i.e. no records in the table), below is the Pseudo code:

IF tableIsEmpty THEN
do this...
ELSE
do this..
End IF

Does anyone know how i can achieve this please? Is there a method to check if a table is empty or not?

Thanks alot,

Amber

 

[gemma-the-husky]

if dcount("*","tablename") =0

returns a count of the number of entries in the table

 

[amb3r]

thats Perfect. Thanks hun

Amber