MySQL gotcha -recordcount/absoluteposition

[GeorgeS]

I never figured out why recordcount never worked - always returned -1 for whatever reason, and this is not just here - it also happens at work when I'm working with Oracle - go figure.
I typically do -

While NOT RS.EOF(1)
Wend

..and iterate through the recordset.
I think ADO does not work well with many aspects of MySql such as BLOB Objects and Time/Date stamps

GeorgeS

[Rhodan]

Funny thing is, I don't use recordcount or absoluteposition either. I was just experimenting with the different locktypes and cursor locations and it wasn't doing what it was supposed to - and that bugged me!