Re: Class::DBI::Sybase patch (for IDENTITY columns)

[prev] [thread] [next] [Date index for 2004/10/19]

> On Tue, Oct 19, 2004 at 11:56:19AM -0500, Michael Wojcikiewicz wrote:
>> Attached is a patch (and full file) for allowing auto-generation of values
>> for IDENTITY columns in Sybase.  It relies on the fact that sp_help
returns the right info regarding IDENTITY columns (works in sybase
12.5.2).
>> Comments?  Suggestions?  Bugs??
>
> Just curious why you'd going through the DBI prepare-execute-fetch
cycle, rather than the normal Class::DBI set-sql approach?

I was just following the coding convention that was in the 0.1 release.  I
guess it seems like overkill to use set_sql for a built-in command (like
sp_columns or sp_help) or for a statement as simple as 'SELECT
@@IDENTITY'.  I could convert to use set_sql if that is desired.

--mike