Subject | [Firebird-Architect] Auto-increment/-generated fields and getting values back |
---|---|
Author | Dmitry Yemanov |
Post date | 2004-12-22T17:10:04Z |
"Roman Rokytskyy" <rrokytskyy@...> wrote:
identity/autoincrement columns. What one needs is to read the spec and
submit a feature request to the tracker. Or present it here, although,
unfortunately, we still don't a dedicated person to summarize fb-arch
discussions, so every proposal has quite good chances to be lost in dust.
Dmitry
>The SQL-99 spec contains both sequences/generators and
> Yes, but that's completely different thing. The original talk was
> about adding some kind of an autoincrement field that would
> automatically fetch its value from generator.
identity/autoincrement columns. What one needs is to read the spec and
submit a feature request to the tracker. Or present it here, although,
unfortunately, we still don't a dedicated person to summarize fb-arch
discussions, so every proposal has quite good chances to be lost in dust.
> What you propose is to fetch the ID first on the client, and then useSee my other message.
> it in INSERT. Perfect solution, but it will not help those that are
> too used to autoincrement fields and getGeneratedKeys() in JDBC.
Dmitry