Re: realSQLDatabase limit of rows, database corrupted

[Dr Gerard Hammond <realbasic at macsos dot com dot au>]

Hi Matthias,

Umm, what is happens with the standard way..

select count(*) from mails

Otherwise use SQLmanager to export and import as SQL


At 11:46 AM +0200 29/7/07, Matthias Buercher wrote:
>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>


-- 

Cheers,

Dr Gerard Hammond
MacSOS Solutions
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>

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