iOS Question how to confirm a recordset is empty ?

[little3399]

Hi all

Is there any way to confirm a recordset was empty ? It seem the recordset.nextrow can not support this ? Tks!

 

[sorex]

what do you mean with empty?

if it exists it won't be empty but contain default value or NULL values.

 

[little3399]

My means was if RecordSet.NextRow=false, this not sure the recordset was empty ...

 

[sorex]

oh you meant recordset I thought you meant the record.

I guess you use

do while recordset.nextrow

so I guess it will skip the loop if it's empty.

 

[little3399]

my logic flow was if the recordset empty and then insert some data into the table , if not , then not insert ...

 

[sorex]

I just checked and the help that shows up when typing a resultset.NextRow mentions that it returns true if it has records.

so your false check should work.