How works revCurrentRecordIsLast/revCurrentRecordIsFirst

Jérôme Rosat jrosat at mac.com
Sat Nov 6 06:38:25 CST 2004


Bonjour Jan,

Yes I use MySQL. After creating a recordset, I execute: 
'revMoveToFirstRecord' (go to the first record). Results:

'revNumberOfRecords'      : 3
'revCurrentRecord'        : 0
'revCurrentRecordIsLast'  : false
'revCurrentRecordIsFirst' : false

Then I execute 'revMoveToNextRecord' (go to the second record). Results:

'result()                 : true
'revNumberOfRecords'      : 3
'revCurrentRecord'        : 1
'revCurrentRecordIsLast'  : false
'revCurrentRecordIsFirst' : false

Then I execute 'revMoveToNextRecord' (go to the third and last record). 
Results:

'result()                 : true
'revNumberOfRecords'      : 3
'revCurrentRecord'        : 2
'revCurrentRecordIsLast'  : false ??
'revCurrentRecordIsFirst' : false

Then I execute 'revMoveToNextRecord' (just to see). Results:

'result()                 : false
'revNumberOfRecords'      : 3
'revCurrentRecord'        : 2
'revCurrentRecordIsLast'  : true
'revCurrentRecordIsFirst' : false

I hope it is clear.

Jérôme Rosat

Le 6 nov. 04, à 06:25, Jan Schenkel a écrit :

> --- Jérôme Rosat <jrosat at mac.com> wrote:
>> Bonjour tout le monde,
>>
>> In Dreamcard documentation, for the
>> revCurrentRecordIsLast function,
>> it's written that "Returns whether the current
>> record is the last
>> record in a record set (database cursor)."
>>
>> In my recordset with 3 records, when the cursor is
>> on the first record,
>> revCurrentRecordIsLast return false. It's Ok for me.
>> After moving the cursor with revMoveToNextRecord to
>> the second record,
>> revCurrentRecordIsLast return false. It's still OK
>> for me.
>> If I move the cursor to the third and last record,
>> revCurrentRecordIsLast still return false. With the
>> upper definition,
>> the result should be true. The third record is the
>> last one.
>> But revCurrentRecordIsLast return true only if I use
>>
>> revMoveToNextRecord once again. In short,
>> revCurrentRecordIsLast return
>> true when revMoveToNextRecord return an error. And
>> it is the same for
>> revCurrentRecordIsFirst.
>>
>> Is it a bug or I'm stupid ?
>>
>> Jérôme Rosat
>>
>
> Bonjour Jérôme,
>
> What does the function 'revNumberOfRecords' return for
> that result set ? And is this still on MySQL ?
>
> Jan Schenkel.
>
> =====
> Join us at the European Revolution Conference
> November 14-16, MALTA. ~ http://TechieTours.com/Rev/
>
> =====
> "As we grow older, we grow both wiser and more foolish at the same 
> time."  (La Rochefoucauld)
>
>
> 		
> __________________________________
> Do you Yahoo!?
> Check out the new Yahoo! Front Page.
> www.yahoo.com
>
>
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> http://lists.runrev.com/mailman/listinfo/use-revolution
>


More information about the use-livecode mailing list