Groups > comp.databases.ms-sqlserver > #455

Re: problem from proc call and autoincreasing key in using otl

Path	csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!gegeweb.org!eternal-september.org!feeder.eternal-september.org!.POSTED!not-for-mail
From	Erland Sommarskog <esquel@sommarskog.se>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: problem from proc call and autoincreasing key in using otl
Date	Tue, 14 Jun 2011 23:39:06 +0200
Organization	Erland Sommarskog
Lines	21
Message-ID	<Xns9F04F0993205BYazorman@127.0.0.1> (permalink)
References	<3c4bb9a9-97ed-4a95-9982-2afd993017bd@34g2000pru.googlegroups.com> <40019655-3aa1-40c0-950e-11d0d3e75240@v11g2000prk.googlegroups.com>
Mime-Version	1.0
Content-Type	text/plain; charset=windows-1252
Content-Transfer-Encoding	8bit
Injection-Info	mx04.eternal-september.org; posting-host="DD6dU+BfJNjsjSP4/K/V7w"; logging-data="20168"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1/iYz4F/xWfFwRw4UsFSXT0"
User-Agent	Xnews/2006.08.24 Mime-proxy/2.1.c.0 (Win32)
Cancel-Lock	sha1:JR/qwn8GPdYp22XbaPNwh/L17CI=
Xref	x330-a1.tempe.blueboxinc.net comp.databases.ms-sqlserver:455

Show key headers only | View raw

white_ideal (whiteideal@gmail.com) writes:
> I know how to get the identity of course by using sql. But don't know
> how to get it using the interface from otl. It's so difficult to
> implement in otl. And I am a little regret to use otl in my project,
> but i have no choice at present.

So the question boils down to "how do I receive a result set through OTL" or 
"how do I receive an output parameter through OTL". There is nothing
special with regards to the IDENTITY value.

I see that they have a discussion board on the OTL web site, you may
find better answers there.

-- 
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

problem from proc call and autoincreasing key in using otl white_ideal <whiteideal@gmail.com> - 2011-06-12 17:08 -0700
  Re: problem from proc call and autoincreasing key in using otl Erland Sommarskog <esquel@sommarskog.se> - 2011-06-13 07:23 +0000
    Re: problem from proc call and autoincreasing key in using otl Gene Wirchenko <genew@ocis.net> - 2011-06-13 07:28 -0700
      Re: problem from proc call and autoincreasing key in using otl Erland Sommarskog <esquel@sommarskog.se> - 2011-06-13 23:59 +0200
        Re: problem from proc call and autoincreasing key in using otl Henk van den Berg <me@myplace.net> - 2011-06-14 08:35 +0200
  Re: problem from proc call and autoincreasing key in using otl white_ideal <whiteideal@gmail.com> - 2011-06-13 15:13 -0700
    Re: problem from proc call and autoincreasing key in using otl Erland Sommarskog <esquel@sommarskog.se> - 2011-06-14 23:39 +0200
      Re: problem from proc call and autoincreasing key in using otl white_ideal <whiteideal@gmail.com> - 2011-06-14 15:36 -0700
        Re: problem from proc call and autoincreasing key in using otl white_ideal <whiteideal@gmail.com> - 2011-06-14 17:33 -0700
  Re: problem from proc call and autoincreasing key in using otl white_ideal <whiteideal@gmail.com> - 2011-06-14 17:34 -0700

csiph-web