M
Maracay
Hi guys
There is a better way to know if a column in a table is empty?, what I am
doing is to read all the table but takes too long when I have 10.000 records
or more in the table, this is my code:
Dim rd As Recordset
Set rd = Recordset
rd.MoveFirst
swID = False
swPrefix = False
Do Until rd.EOF
If Not IsNull(ID) Then
swID = True
End If
If Not IsNull(Prefix) Then
swPrefix = True
End If
rd.MoveNext
Loop
There is a better way to know if a column in a table is empty?, what I am
doing is to read all the table but takes too long when I have 10.000 records
or more in the table, this is my code:
Dim rd As Recordset
Set rd = Recordset
rd.MoveFirst
swID = False
swPrefix = False
Do Until rd.EOF
If Not IsNull(ID) Then
swID = True
End If
If Not IsNull(Prefix) Then
swPrefix = True
End If
rd.MoveNext
Loop