Re: DBI/DBD::Sybase @@IDENTITY Bug??

2001-03-12 Thread Andrew Powell
Michael: WOW! NEAT! THANKS!! That solved the problem. Sincerely, Andrew Powell aap Michael Peppler wrote: > Andrew Powell writes: > > It appears that selecting @@IDENTITY returns only the first IDENTITY > > result for the database connection. This is with SyBase 11.0.3.3, DBI > > 1.13

Re: DBI/DBD::Sybase @@IDENTITY Bug??

2001-03-12 Thread Michael Peppler
Andrew Powell writes: > It appears that selecting @@IDENTITY returns only the first IDENTITY > result for the database connection. This is with SyBase 11.0.3.3, DBI > 1.13 and DBD:Sybase 0.91. > > For example, I created a test table as such: > create table test (id numeric(10,0) identity,

RE: DBI/DBD::Sybase @@IDENTITY Bug??

2001-03-12 Thread Booth, Tim
After something that happened in my code recently, I suspect there may be a more general problem. May I suggest you replace the prepare/executes with the basic 'do' function for the two insertions. Does this make any difference? My problems involved a rather long-winded trigger, which (among ot