Beefy Boxes and Bandwidth Generously Provided by pair Networks
Keep It Simple, Stupid
 
PerlMonks  

Re: Re: Getting identity after autoincr in FreeTDS/MSSQL/DBI

by wardk (Deacon)
on Nov 09, 2001 at 22:47 UTC ( #124439=note: print w/ replies, xml ) Need Help??


in reply to Re: Getting identity after autoincr in FreeTDS/MSSQL/DBI
in thread Getting identity after autoincr in FreeTDS/MSSQL/DBI

hmmm, I guess I should login before posting, if I was wrong about the above blame anonymous monk...


Comment on Re: Re: Getting identity after autoincr in FreeTDS/MSSQL/DBI
Re: Re: Re: Getting identity after autoincr in FreeTDS/MSSQL/DBI
by scain (Curate) on Nov 09, 2001 at 23:52 UTC
    wardk,

    I think it is different when running over freeTDS on linux, because when I tried to do it as two seperate commands, @@IDENTITY was empty. I think it has something to do with the concept of "current session", but I don't really know.

    Nice work in Identity nabber for MSSQL, by the way.

    Thanks,
    Scott

      If the value for @@identity is empty when doing this as two requests it means that the select @@identity is done on a different physical connection from the insert. This usually happens when you don't completely flush all the results after the initial insert.

      I'm thinking of adding an attribute to DBD::Sybase that would inhibit the automatic secondary connections to handle multiple concurrent $sth on a single database handle as that causes quite a lot of confusion for people...

      Michael

        Since you are using two commands off one prepare, you may need to
        use the:

        while ( $someVar = $sth->fetch ) { do ( something... ) while ( $sth->{syb_more_results} );

        syntax.

        This is explained in the "Programming the Perl DBI" book
        PG: 326 Don't know if it helps - but it's worth a try.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://124439]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others imbibing at the Monastery: (13)
As of 2014-08-29 19:10 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The best computer themed movie is:











    Results (287 votes), past polls