Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Vb recordsets...
Message
 
To
15/10/1999 06:16:34
John Vlahos
V I Software Solutions Design
Mississauga, Ontario, Canada
General information
Forum:
Visual Basic
Category:
Other
Miscellaneous
Thread ID:
00276735
Message ID:
00276771
Views:
25
>How can I test if a recordset contains 0 records so I can skip calling the Move() mehods so that I can avoid the "No current record" error message generated by VB 5.0?

The RecordCount property is not always good (it can sometimes returns -1 even if you have data in the recordset!). It is better to check this way:
If rst.bof and rst.eof then
'The recordset is really empty.
end if
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com
Previous
Reply
Map
View

Click here to load this message in the networking platform