Posted by Robert Klemme on 11/28/06 17:17

On 28.11.2006 17:51, Jim C wrote:
> I'm accessing the tables with an application that uses ODBC for now
> (it'll probably go some other more direct route in the near future as
> things are refactored). The way it is architected it needs to know the
> value before the insert occurs because of the how and when it passes
> that value to child records in master-detail setups.

Hm, I smell data inconsistency here. You certainly do not have foreign
keys on that id column, do you? Otherwise the DB would force you to
first insert the record that gets the id and then dependent records.

> Your idea about emulating an Oracle sequence looks like it will be just
> the ticket. Thanks!

You're welcome!

robert

[Back to original message]