From: Lennon Day-Reynolds <rcoder@...>
Date: 2004-07-29T07:04:07+09:00
Subject: Stupid ODBC!

So, in response to David's call for contributions of adapters for
Active Record, I've been working on an ODBC adapter. Unfortunately,
I've come up against a limitation of the ODBC spec when compared to
most native database APIs there appears to be no standard way of
getting an identifier for the last row inserted. Since one of the
primary methods that an Active Record database adapter must implement
('insert') is expected to return this value, I appear to be stuck for
the moment.

Does anyone have a general solution for this they've used (or seen
described/mentioned) elsewhere? Alternately, might there be a
workaround to remove this requirement from the adapter interface in
Active Record, w/o breaking the rest of the system? (David, that one's
all yours to answer, most likely.)

Lennon