Issue with ReadNext, ReadPrev

I have an issue with the following sequence.

1) User select all recordsby executing a SqlCeResultSet ( using like % )

2) User selects "Last" by triggering the rset.readlast()

3) User now selects "Next" by triggering the rset.readnext()

4) User now select "Prev" by triggering rset.readprevious()

...

nothing happens...the textboxes do not update their values.

However if the "Prev" button is pressed again ( a second time ) now the textboxes populates the prev record's data and the dataset nav goes well again...

This behaviour is very annoying...any help here?

Thanks in advance!

I would say it’s a bug in SQL CE as exception should’ve been thrown on attempt to read past last record. Please file a bug report on http://connect.microsoft.com/

To make sure your application still works after that is fixed (and to eliminate that effect with existing versions) make sure not to read past last record, e.g. disable"Next" button if user hits "Last" or reaches last record by hitting "Next". That is easy to determine – if Read()/ReadLast() returns false then it’s the last record and “Next” should be disabled. Enable it as user moves back to valid records range.

|||

Ilya,

I've found a workaround in my project, without resoriting to enabled/disabled buttons.

I'll try to post the bug

Thanks for your coop.

Gus

|||

The bug 13334 in SQL Server CE has been filed to track this issue.

Hope the issue gets resolved soon.