Hi Mark,
* Mark Aufflick <[EMAIL PROTECTED]> [060405 06:31]:
> Sybase, like SQLlite, does (now) support an auto-incrementing column
> type, but AFAICT there is no way to find out which id you just
> inserted.
Sybase provides the @@identity variable which holds the last
auto-generated identity value in the transaction. I can also say for
sure, that Sybase has had identity columns for quite some time
(started using them sometime around 1998 - not sure which version of
Sybase though). The big problem with identity columns as you've said
is that Sybase at times will produce large gaps if the server goes
down unexpectedly or is shutdown with nowait. But there are
workarounds (and since 12.5 official fixes) for that problem.
-- Olaf
--
AOLserver - http://www.aolserver.com/
To Remove yourself from this list, simply send an email to <[EMAIL PROTECTED]>
with the
body of "SIGNOFF AOLSERVER" in the email message. You can leave the Subject:
field of your email blank.
