[freetds] Return the InsertID after an Insert?
craigs
s.craig at andronics.com
Thu Mar 3 05:21:27 EST 2005
Thanks guys, this is what i'm after.
Shaun.
Thompson, Bill D (London) wrote:
>Shaun, Rob,
>
>It looks like MySQL has a feature called an "AUTO_INCREMENT" column on
>tables.
>This looks very much like an identity column in SQL Server, AFAICT from
>a quick google.
>If this is what you're after, I'd do as Rob suggests.
>
>You'd have to "select @@IDENTITY" after your insert and then bring the
>value back into your program by binding and fetching, as you would in a
>normal select.
>
>Bill
>
>-----Original Message-----
>From: freetds-bounces at lists.ibiblio.org
>[mailto:freetds-bounces at lists.ibiblio.org] On Behalf Of Owen, Robert
>Sent: 03 March 2005 10:06
>To: FreeTDS Development Group
>Subject: RE: [freetds] Return the InsertID after an Insert?
>
>
>Do you mean the identity value from a table?
>
>If so suggest RETURN @@IDENTITY and use the return value in db-lib
>
>Rob.
>
>-----Original Message-----
>From: freetds-bounces at lists.ibiblio.org
>[mailto:freetds-bounces at lists.ibiblio.org] On Behalf Of craigs
>Sent: 03 March 2005 10:02
>To: FreeTDS Development Group
>Subject: Re: [freetds] Return the InsertID after an Insert?
>
>
>I should have explained it better! what i mean is the row number the
>Insert was inserted into, in MySQL its a function called
>mysql_insert_id, eg..
>
>row no. data
>3 Aston Villa
>4 Man Utd.
>
>if i inserted Arsenal next the row would be 5, thats what i want to
>return. Is this possible in freetds or will i just have to do another
>query?
>
>Thanks,
>Shaun.
>
>Thompson, Bill D (London) wrote:
>
>
>
>>Shaun
>>
>>AFAIK, there's no such concept as an "insert ID" in sql server.
>>What does it represent in MySQL ?
>>You can get a "number of rows affected" value...
>>
>>Bill
>>
>>-----Original Message-----
>>From: freetds-bounces at lists.ibiblio.org
>>[mailto:freetds-bounces at lists.ibiblio.org] On Behalf Of craigs
>>Sent: 03 March 2005 09:55
>>To: FreeTDS Development Group
>>Subject: [freetds] Return the InsertID after an Insert?
>>
>>
>>Is it possible in db-lib to return the insertid of a record when its
>>inserted, eg. insertid = dbsqlexec("Insert into .....etc") I know this
>>can be done in mysql but dont know about ms sql, any info would be
>>great.
>>
>>Shaun.
>>_______________________________________________
>>FreeTDS mailing list
>>FreeTDS at lists.ibiblio.org
>>http://lists.ibiblio.org/mailman/listinfo/freetds
>>--------------------------------------------------------
>>
>>If you are not an intended recipient of this e-mail, please notify the
>>
>>
>sender, delete it and do not read, act upon, print, disclose, copy,
>retain or redistribute it. Click here for important additional terms
>relating to this e-mail. http://www.ml.com/email_terms/
>
>
>>--------------------------------------------------------
>>
>>_______________________________________________
>>FreeTDS mailing list
>>FreeTDS at lists.ibiblio.org
>>http://lists.ibiblio.org/mailman/listinfo/freetds
>>
>>
>>
>>
>
>_______________________________________________
>FreeTDS mailing list
>FreeTDS at lists.ibiblio.org
>http://lists.ibiblio.org/mailman/listinfo/freetds
>
>______________________________________________________________________
>This email has been scanned by the MessageLabs Email Security System.
>For more information please visit http://www.messagelabs.com/email
>______________________________________________________________________
>
>
>_____________________________________________________________________
>CONFIDENTIALITY NOTICE
>
>The contents of this e-mail are confidential to the ordinary user of
>the e-mail address to which it was addressed and may also be
>privileged. If you are not the addressee of this e-mail you may not
>copy, forward, disclose or otherwise use it or any part of it in any
>form whatsoever. If you have received this e-mail in error please
>e-mail the sender by replying to this message.
>
>A list of the partners of Norton Rose, Solicitors, can be inspected at
>www.nortonrose.com
>
>Please refer to www.nortonrose.com/regulation for the firm's regulatory
>position.
>
>Regulated by the Law Society.
>______________________________________________________________________
>
>_______________________________________________
>FreeTDS mailing list
>FreeTDS at lists.ibiblio.org
>http://lists.ibiblio.org/mailman/listinfo/freetds
>--------------------------------------------------------
>
>If you are not an intended recipient of this e-mail, please notify the sender, delete it and do not read, act upon, print, disclose, copy, retain or redistribute it. Click here for important additional terms relating to this e-mail. http://www.ml.com/email_terms/
>--------------------------------------------------------
>
>_______________________________________________
>FreeTDS mailing list
>FreeTDS at lists.ibiblio.org
>http://lists.ibiblio.org/mailman/listinfo/freetds
>
>
More information about the FreeTDS
mailing list