druagord — Mon, 28 Jul 2003 22:45:12 +0000

thanks suzanne i should have seen that one

Suzanne — Fri, 25 Jul 2003 13:00:12 +0000

or 1, depending.

druagord — Fri, 25 Jul 2003 12:27:00 +0000

Quote: I mean, what were they thinking?!?

they where thinking of the best way to make money doing over complicated things to sell you programming course. then every 3 or 4 years they change everything so you start from 0 again

JeevesBond — Fri, 25 Jul 2003 10:53:55 +0000

Hehehe, yeah. I've been programming VB for years, the more I know about it - the less I like it. It's so tempramental, they try to make programming "easy" but just make everything over-complicated and illogical...For web based stuff PHP is the way to go: no COM overhead for a start.

Mark Hensler — Fri, 25 Jul 2003 08:41:15 +0000

Does this suprise anyone that microsoft has it's own theory on referencing lists? I mean, what were they thinking?!?

jlot6 — Thu, 24 Jul 2003 22:58:03 +0000

Thanks, this helps...

JeevesBond — Thu, 24 Jul 2003 21:25:39 +0000

ADO is a bit strange with EOF and BOF (you'll find the same happens with EOF).

The AbsolutePosition for BOF is -1, whilst the first record is stored in AbsolutePosition 1 (BOF does not have a record associated with it).

Also...AbsolutePosition is indexed from 1, therefore 0 doesn't really do anything. ADO probably returns the first record becasue it is the nearest match.

Suzanne — Thu, 24 Jul 2003 18:38:28 +0000

My guess is it's so you don't have to correct for the zero position. Oversight?

Record count should be accurate, a count of how many records you have? Absolute position is also logical, it's ABSOLUTELY in the first position, not the zeroth position.

jlot6 — Thu, 24 Jul 2003 15:33:48 +0000

I can understand that, I don't however understand then why if you use recordcount or absoluteposition, is starts from 1?

ROB — Thu, 24 Jul 2003 14:15:51 +0000

perhaps the index is zero based?

to seek the first record you can use MoveFirst