On Aug 23, 2007, at 5:02 PM, johnf wrote:
> I have a parent and several child waiting to be saved.
> isTransactionManager = True
>
> parent is inserted into the DB
>
> then getLastInsertID() is called because the children need the PKID
> of the
> parent
>
> But no commit has occurred.
>
> getLastInsertID() fails because of no commit.
>
> I don't think this can work? Anybody have a suggestion on how I
> might fix
> this?
Is there any other way to query the value without committing? If
not, you should probably use sequence instead, and pre-fetch it using
the dbPostgreSQL.pregenPK() method (which doesn't exist yet).
-- Ed Leafe
-- http://leafe.com
-- http://dabodev.com
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
Searchable Archives: http://leafe.com/archives/search/dabo-dev
This message: http://leafe.com/archives/byMID/dabo-dev/[EMAIL PROTECTED]
