freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

[freetds] Return the InsertID after an Insert?

From: craigs <s.craig AT andronics.com>
To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
Subject: [freetds] Return the InsertID after an Insert?
Date: Thu, 03 Mar 2005 09:54:31 +0000

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] Return the InsertID after an Insert?, craigs, 03/03/2005
- <Possible follow-up(s)>
- RE: [freetds] Return the InsertID after an Insert?, Thompson, Bill D (London), 03/03/2005
  - Re: [freetds] Return the InsertID after an Insert?, craigs, 03/03/2005
- RE: [freetds] Return the InsertID after an Insert?, Owen, Robert, 03/03/2005
  - Re: [freetds] Return the InsertID after an Insert?, craigs, 03/03/2005
- RE: [freetds] Return the InsertID after an Insert?, Thompson, Bill D (London), 03/03/2005
  - Re: [freetds] Return the InsertID after an Insert?, craigs, 03/03/2005
    - Re: [freetds] Return the InsertID after an Insert?, craigs, 03/03/2005
- RE: [freetds] Return the InsertID after an Insert?, Thompson, Bill D (London), 03/03/2005
  - Re: [freetds] Return the InsertID after an Insert?, craigs, 03/03/2005
    - Re: [freetds] Return the InsertID after an Insert?, James K. Lowden, 03/03/2005