FreeTDS Development Group

[craigs <s.craig AT andronics.com>]

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
>