[freetds] Return the InsertID after an Insert?

craigs s.craig at andronics.com
Thu Mar 3 05:09:17 EST 2005


if i can update a record in my table by using the identity value then 
yes thats what i mean.

thanks, i'll try that and see what happens.

Shaun.

Owen, Robert wrote:

>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
>  
>




More information about the FreeTDS mailing list