No error thrown when trying a SELECT on a corrupted database

[Ruslan Zasukhin]

On 11/6/07 9:36 PM, "Dave Addey" <listmail1 at dsl.pipex.com> wrote:

Hi Dave,

> Hi there,
> 
> I¹ve been seeing this problem with v2.5.10, and also with v3.0.2, in V4RB.
> Here¹s the problem...
> 
> I am opening and testing my database file before using it, to make sure that
> it is a valid database, and has not become corrupted.  The idea is that
> Valentina should throw an exception if the database is not valid, and I can
> then catch this exception and create a new blank database.
> 
> However, I am finding that the code below:
> 
>       Dim DBRec as VCursor
> 
>       DBrec = outDatabase.SQLSelect("SELECT * FROM Tracks ORDER BY Title,
> ArtistNoThe, Album, TrackNumber", EVCursorLocation.kServerSide,
> EVLockType.kNoLocks, EVCursorDirection.kRandom)
> 
> ...just ³hangs² when trying to access a corrupted database, rather than
> throwing an exception.  In earlier versions of V4RB 2.5.x, this line would
> throw an exception.  The database is opening without any problems.
> 
> Any ideas about how I can get this code to throw an exception correctly?

Well, corruptions can be different and not expected and not planned. Right?
So if code hangs than corruption is somehow not checked.

May be in 2.5 you did have other corruption at all.
Or the same db in 2.5 throw error but in 3.x no ?

In any case you need report this into Mantis, and attach db there.
 
> I¹m using REALbasic 2007r2 UB on an Intel Mac Pro.

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]