Xojo Conferences
MBSOct2019CologneDE

Re: recordset's recordcount (Real Studio network user group Mailinglist archive)

Back to the thread list
Previous thread: About RB SQL support
Next thread: Out of Bounds Exception Bug


REALdatabase, collected wisdom   -   Jan Erik Moström <
  Re: recordset's recordcount   -   Jan Erik Moström <
   recordset's recordcount   -   Jan Erik Moström <
    Multi-page page range printing anomaly   -   Dennis Birch
   Re: recordset's recordcount   -   William Yu
    Re: recordset's recordcount   -   Seth Willits
     Re: recordset's recordcount   -   Boris Segerstahl
    Re: recordset's recordcount   -   Ken & Deb Allen
     Re: recordset's recordcount   -   Seth Willits
   Re: Peer to Peer Messaging   -   Chris

Re: recordset's recordcount
Date: 28.08.02 08:18 (Wed, 28 Aug 2002 09:18:48 +0200)
From: Jan Erik Moström <
2002-08-28 18:53: Seth Willits <<email address removed>> is believed to have
typed:

> Guess again. I know for a fact it doesn't work in MySQL and I was
> told by Geoff that it was only supported by REAL Databases.

Yes, the reason I asked was that I had one record selected in a mySQL
database and recordCount returned 0

jem

recordset's recordcount
Date: 27.08.02 22:00 (Tue, 27 Aug 2002 23:00:48 +0200)
From: Jan Erik Moström <
What exactly does recordcount do?

jem

Re: recordset's recordcount
Date: 27.08.02 22:34 (Tue, 27 Aug 2002 16:34:34 -0500)
From: William Yu
on 8/27/02 4:00 PM, Jan Erik Moström at <email address removed> wrote:

> What exactly does recordcount do?

Returns the number of records in a RecordSet. However, it's only currently
supported in OpenBase, MySQL, PostgreSQL and 4D plugins. You'll get a -1 if
you try it on any other database.

Regards,
William Yu
<email address removed>

---
Subscribe to the digest:
<mailto:<email address removed>>
Unsubscribe:
<mailto:<email address removed>>

Re: recordset's recordcount
Date: 29.08.02 02:53 (Wed, 28 Aug 2002 18:53:37 -0700)
From: Seth Willits
On 8/27/02 2:34 PM, the NSA intercepted the following message from "William
Yu" <<email address removed>>:

>> What exactly does recordcount do?
>
> Returns the number of records in a RecordSet. However, it's only currently
> supported in OpenBase, MySQL, PostgreSQL and 4D plugins. You'll get a -1 if
> you try it on any other database.

Guess again. I know for a fact it doesn't work in MySQL and I was told by
Geoff that it was only supported by REAL Databases.

Seth Willits
---------------------------------------------------------------------------
President and Head Developer of Freak Software - http://www.freaksw.com
Q&A Columnist for REALbasic Developer Magazine - http://www.rbdeveloper.com

"All men are born with a nose and ten fingers, but no one was born with a
knowledge of God."
-- Voltaire
---------------------------------------------------------------------------


---
Subscribe to the digest:
<mailto:<email address removed>>
Unsubscribe:
<mailto:<email address removed>>

Re: recordset's recordcount
Date: 28.08.02 08:26 (Wed, 28 Aug 2002 10:26:51 +0300)
From: Boris Segerstahl
I tested it on a Realbasic database record set where I know that I have
127 records.
cur.recordcount returned -1. My guess is that it works only within the
datacontrol if you know how to do it. I don't know. Whenever I try to
use recordcount it returns -1, 0 or an unexpected quit.

Boris

On Thursday, August 29, 2002, at 04:53 AM, Seth Willits wrote:

> On 8/27/02 2:34 PM, the NSA intercepted the following message from
> "William
> Yu" <<email address removed>>:
>
>>> What exactly does recordcount do?
>>
>> Returns the number of records in a RecordSet. However, it's only
>> currently
>> supported in OpenBase, MySQL, PostgreSQL and 4D plugins. You'll get a
>> -1 if
>> you try it on any other database.
>
> Guess again. I know for a fact it doesn't work in MySQL and I was told
> by
> Geoff that it was only supported by REAL Databases.
>
> Seth Willits
> ---------------------------------------------------------------------------
> President and Head Developer of Freak Software - http://www.freaksw.com
> Q&A Columnist for REALbasic Developer Magazine -
> http://www.rbdeveloper.com
>
> "All men are born with a nose and ten fingers, but no one was born
> with a
> knowledge of God."
> -- Voltaire
> ---------------------------------------------------------------------------
>
> ---
> Subscribe to the digest:
> <mailto:<email address removed>>
> Unsubscribe:
> <mailto:<email address removed>>
___________________________________
Boris Segerstahl
<email address removed>

---
Subscribe to the digest:
<mailto:<email address removed>>
Unsubscribe:
<mailto:<email address removed>>

Re: recordset's recordcount
Date: 28.08.02 20:05 (Wed, 28 Aug 2002 15:05:28 -0400)
From: Ken & Deb Allen
Actually, this is a common problem with many 'cursor' classes -- in most
cases you need to support a DynaSet ort KeySet cursor (one that permits
forward and backward movement) to know the number of records in the record
set; forward only cursors do not typically know!

-ken

On Wednesday, August 28, 2002, at 09:00 AM, REALbasic Network Users Group
wrote:

> Subject: Re: recordset's recordcount
> From: "Boris Segerstahl" <<email address removed>>
> Date: Wed, 28 Aug 2002 10:26:51 +0300
>
> I tested it on a Realbasic database record set where I know that I have
> 127 records.
> cur.recordcount returned -1. My guess is that it works only within the
> datacontrol if you know how to do it. I don't know. Whenever I try to
> use recordcount it returns -1, 0 or an unexpected quit.
>
> Boris
>
> On Thursday, August 29, 2002, at 04:53 AM, Seth Willits wrote:
>
>> On 8/27/02 2:34 PM, the NSA intercepted the following message from
>> "William
>> Yu" <<email address removed>>:
>>
>>>> What exactly does recordcount do?
>>>
>>> Returns the number of records in a RecordSet. However, it's only
>>> currently
>>> supported in OpenBase, MySQL, PostgreSQL and 4D plugins. You'll get a
>>> -1 if
>>> you try it on any other database.
>>
>> Guess again. I know for a fact it doesn't work in MySQL and I was told
>> by
>> Geoff that it was only supported by REAL Databases.
>>
>> Seth Willits

---
Subscribe to the digest:
<mailto:<email address removed>>
Unsubscribe:
<mailto:<email address removed>>

Re: recordset's recordcount
Date: 29.08.02 01:45 (Wed, 28 Aug 2002 17:45:24 -0700)
From: Seth Willits
On 8/28/02 12:05 PM, the NSA intercepted the following message from "Ken &
Deb Allen" <<email address removed>>:

> Actually, this is a common problem with many 'cursor' classes -- in most
> cases you need to support a DynaSet ort KeySet cursor (one that permits
> forward and backward movement) to know the number of records in the record
> set; forward only cursors do not typically know!

Which is also another problem that has yet to be addressed. MySQL (and
other) databases cannot use the .MovePrevious .MoveFirst, and .MoveLast
methods. I reeeeeally would like to have this functionality. It didn't make
it in time for 4.5 and I'm hoping it will for 4.5.1.

Seth Willits
---------------------------------------------------------------------------
President and Head Developer of Freak Software - http://www.freaksw.com
Q&A Columnist for REALbasic Developer Magazine - http://www.rbdeveloper.com

"Knowledge is limited. Imagination encircles the world."
-- Albert Einstein
---------------------------------------------------------------------------



---
Subscribe to the digest:
<mailto:<email address removed>>
Unsubscribe:
<mailto:<email address removed>>