[egenix-users] how to insert new row, update in-memory object with same row from database?

[Michael Rothwell]

M.-A. Lemburg wrote:

>
> The DB-API lists a standard extension for this purpose:
>
> Cursor Attribute .lastrowid

It doesn't look like mx.ODBC supports it -- "attribute error," and a 
search through the .py files produces no matches for "lastrowid."

>
> That way you know the identity of the row *before* inserting
> it -- usually much better if you plan to use contraints and
> the like on the table.
>
Yeah, but that doesn't do me any good when working with a pre-existing 
database schema.

Thanks,

-Michael