Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Identity and ADO

2 posts in Windows NT Last posting was on 1999-12-21 05:16:10.0Z
Rich M Posted on 1999-12-20 17:20:08.0Z
From: "Rich M" <rmorrison@greystone.com>
Subject: Identity and ADO
Date: Mon, 20 Dec 1999 12:20:08 -0500
Lines: 20
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Message-ID: <Ymn0X7wS$GA.192@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: gatekeeper.greystone.com 4.17.182.2
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2797
Article PK: 1090235

I'm using Sybase 11 with the ODBC driver 10.0.3T.4

I'm using ado an cannot get the new identitiy value. My code looks something
like this...

myADORecordset.Update 'does an insert...

Set myNewIdentityrecordset = New ADODB.Recordset

'try and get the new identity...
myNewIdentityrecordset.Open "select @@identity", moSecurity.Connection,
adOpenStatic, adLockPessimistic

I do get a recordset back with 1 field but it is zero...

Thanks
Rich M


Jason Froebe Posted on 1999-12-21 05:16:10.0Z
From: "Jason Froebe" <jfroebe@sybase.com>
References: <Ymn0X7wS$GA.192@forums.sybase.com>
Subject: Re: Identity and ADO
Date: Mon, 20 Dec 1999 23:16:10 -0600
Lines: 41
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
Message-ID: <eM4IgM3S$GA.287@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: 158.159.8.23
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2791
Article PK: 1090229

Hi Rich,

You may get a better response from
news://forums.sybase.com/sybase.public.sqlserver.internet or
news://forums.sybase.com/sybase.public.connectivity.odbc as this deals with
ADO.

j

--
Jason Froebe
Sybase, Inc.
Product Support Engineer

"Rich M" <rmorrison@greystone.com> wrote in message
news:Ymn0X7wS$GA.192@forums.sybase.com...
> I'm using Sybase 11 with the ODBC driver 10.0.3T.4
>
> I'm using ado an cannot get the new identitiy value. My code looks
something
> like this...
>
> myADORecordset.Update 'does an insert...
>
> Set myNewIdentityrecordset = New ADODB.Recordset
>
> 'try and get the new identity...
> myNewIdentityrecordset.Open "select @@identity",
moSecurity.Connection,
> adOpenStatic, adLockPessimistic
>
> I do get a recordset back with 1 field but it is zero...
>
> Thanks
> Rich M
>
>
>