No error thrown when trying a SELECT on a corrupted database

[Dave Addey]

Hi Ruslan,

Thanks for the quick response.  I have submitted a test application and
database to Mantis (id 0002383).  Hopefully this will help you to track down
the problem.

Dave.

> From: Ruslan Zasukhin <sunshine at public.kherson.ua>
> Reply-To: Valentina Developers <valentina at lists.macserve.net>
> Date: Mon, 11 Jun 2007 22:46:06 +0300
> To: "valentina at lists.macserve.net" <valentina at lists.macserve.net>
> Conversation: No error thrown when trying a SELECT on a corrupted database
> Subject: Re: No error thrown when trying a SELECT on a corrupted database
> 
> 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]
> 
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina