PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: "Edward J dot Sabol" <sabol at alderaan dot gsfc dot nasa dot gov>
Subject: Re: Retrieving Identity Value of newly inserted row
Date: Jan 13 2006 8:12PM

> Work-around: don't use placeholders, or hack it with a SELECT
> max(...) after the insert (ugh!)

Or don't use identity columns. For implementing sequential keys, personally,
I use "Method 3" as docummented at

http://www.isug.com/Sybase_FAQ/ASE/section6.2.html#homegrown

Placeholders work fine using this method.