>>Example? Can't imagine anything convincing enough, but why not - Seek() /Scan While, in cases where we have 1) local tables, 2) large table with expected small recordset to retrieve. It can be more efficient than SQL Select, specially if we just want to recalculate couple of things and don't really need a cursor.
>
>I don't think SQL is OOP, actually, though that might make an interesting thread of its own. :)
I didn't mean it as an example of "when is spaghetti code better than OOP", but as a case when I deliberately go against theory (which says I'd get a cursor when I need some set of data from a table), knowing why and what, and what's the risk.