Hi, I'm writing an application in which the records of various tables of one and the same database are being manipulated. However, the corresponing procedures should only be executed, if the tables contains any records/data. Thus I need something like
If "table contains data" then procedure1 procedure2 . . Else Exit Sub End If
Can anyone tell me how to determine if a table contains data.
Thanks Sascha (Sascha W. Felix)
Wed, 24 Dec 1997 03:00:00 GMT
R. Ne #2 / 3
How to find out if table contains data?
Hi, Sascha:
When you open the table, check if both table.EOF and table.BOF are TRUE. If both are true, then it's an empty table.
Quote:
>Hi, >I'm writing an application in which the records of various tables of one and >the same database are being manipulated. However, the corresponing procedures >should only be executed, if the tables contains any records/data. Thus <snip> >Thanks >Sascha >(Sascha W. Felix)
Wed, 24 Dec 1997 03:00:00 GMT
VB 4Ev #3 / 3
How to find out if table contains data?
Quote:
>Can anyone tell me how to determine if a table contains data.
Try this:
DIM Empty% DatabaseObject.Refresh
if DatabaseObject.Recordset.RecordCount = 0 THEN Empty% = 1
How to find out if table contains data?