Debugging Tools and Add-Ins For Visual Studio/VB?

[bushmobile]

It's actually a triple negative, so:

If Not rs.EOF Then

Crazy

[Al42]

It's actually a triple negative, so:

If Not rs.EOF Then

Crazy

Exactly. EOF is a boolean so there's no need to create a boolean return against True or False - If EOF and If Not EOF work just fine - and they're human readable.

Some days I refuse to write code - I just go through his code, cleaning up the pleonasms, quintuple (yep) negatives, endless SQL statements, putting in parentheses where it makes the code more readable, or where VB doesn't guarantee order of execution (you have to know your compiler), msgboxes returning integers that only get tested once, and are defined only for that one use. Some people shouldn't be allowed near computers.

I'm lucky in that my immediate superior is a tech type, so he understands that a day spent cleaning up my predecessor's code may result in not wasting a week trying to understand some spaghetti.

(Now if I can convince him that an hour spent reading posts here saves a week trying to figure out how to code something, when one of you geniuses posted a way of doing it last year. Two lines to create and populate an Excel spreadsheet? Thanks to whoever posted that one - saved me who knows how much trial and error.)