No error thrown when trying a SELECT on a corrupted database

[Dave Addey]

Hi Ruslan,

Just wanted to check - can you access the report (id 0002383) I submitted
for this problem?  I set it to private, as it contained some code from a
commercial app.  Let me know if you can't, and I'll amend it so it can be
public.

Dave.


> From: Dave Addey <listmail1 at dsl.pipex.com>
> Reply-To: Valentina Developers <valentina at lists.macserve.net>
> Date: Mon, 11 Jun 2007 23:51:33 +0100
> To: Valentina Developers <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
> 
> 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
> 
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina