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.

Recordset.RecordCount = -1, how to get how many records in the set

2 posts in ODBC Last posting was on 2007-01-10 23:26:14.0Z
Vladimir Iahnenco Posted on 2007-01-10 18:18:17.0Z
From: "Vladimir Iahnenco" <iahnenco@yahoo.com>
Newsgroups: advantage.odbc
Subject: Recordset.RecordCount = -1, how to get how many records in the set
Date: Wed, 10 Jan 2007 13:18:17 -0500
Lines: 13
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
NNTP-Posting-Host: 74.113.143.114
Message-ID: <45a52ce8@solutions.advantagedatabase.com>
X-Trace: 10 Jan 2007 11:14:00 -0700, 74.113.143.114
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!74.113.143.114
Xref: solutions.advantagedatabase.com Advantage.ODBC:1691
Article PK: 1133071

Hi,
I always get Recordset.RecordCount = -1 with no difference if there are or
not any records in the set.
I checked both rs.Supports(adApproxPosition) and rs.Supports(adBookmark) are
true.

How can get how many records in the set or at least if there are any?

Thanks in advance

Vladimir


Jeremy Mullin Posted on 2007-01-10 23:26:14.0Z
Date: Wed, 10 Jan 2007 23:26:14 +0000 (UTC)
Message-ID: <886edc1520ad38c902eb2ebc9c2f@devzone.advantagedatabase.com>
From: Jeremy Mullin <no@email.com>
Subject: Re: Recordset.RecordCount = -1, how to get how many records in the set
Newsgroups: Advantage.ODBC
References: <45a52ce8@solutions.advantagedatabase.com>
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Content-Type: text/plain; charset=iso-8859-1; format=flowed
X-Newsreader: JetBrains Omea Reader 928.2
NNTP-Posting-Host: 10.24.38.110
X-Trace: 10 Jan 2007 16:21:56 -0700, 10.24.38.110
Lines: 22
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.110
Xref: solutions.advantagedatabase.com Advantage.ODBC:1692
Article PK: 1133072

I'll let someone who knows what they are talking about answer the recordcount
question, but if you just want to know if any records exist I believe the
recordset object has an eof property.

J.D. Mullin
Advantage R&D

> Hi,
> I always get Recordset.RecordCount = -1 with no difference if there
> are or
> not any records in the set.
> I checked both rs.Supports(adApproxPosition) and
> rs.Supports(adBookmark) are
> true.
> How can get how many records in the set or at least if there are any?
>
> Thanks in advance
>
> Vladimir
>