realSQLDatabase limit of rows, database corrupted

[Matthias Buercher <reader at belle-nuit dot com>]

is there a limit of rows in an RealSQLdatabase.

i have added more than 100'000 rows to a database, but i cannot tell  
even any more how many they are.

select count(messageid) from mails
returns no recordset

select messageid from limit 0,100000
returns a recordset with 100'000 rows

select messageid from mails limit 10000,100000
returns a recordset with 100'000 rows

select messageid from mails limit 15000,100000
returns no recordset

select messageid from mails limit 0,114233
returns 114233 rows

select messageid from mails limit 114230,5
returns no recordset


it looks like that there is a corrupted row.
is it likely that a RealSQLdatabase goes corrupt and how can it be  
avoided?

how can i find the corrupted row?

matthias
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>

Search the archives:
<http://support.realsoftware.com/listarchives/lists.html>