SQL with Join is causing a hard crash on an undamaged database

[Dave Addey]

Hi Ruslan,

That is excellent news!  As soon as a new build is available, I shall test
both of these things straight away :-)  Thanks!

Dave.

> From: Ruslan Zasukhin <sunshine at public.kherson.ua>
> Reply-To: Valentina Developers <valentina at lists.macserve.net>
> Date: Mon, 10 Jul 2006 15:48:40 +0300
> To: "valentina at lists.macserve.net" <valentina at lists.macserve.net>
> Conversation: SQL with Join is causing a hard crash on an undamaged database
> Subject: Re: SQL with Join is causing a hard crash on an undamaged database
> 
> On 7/10/06 3:37 PM, "Dave Addey" <listmail1 at dsl.pipex.com> wrote:
> 
>> Hi all,
>> 
>> I¹m getting an application crash (in my app, or in Vstudio) when I do the
>> following:
>> 
>> SELECT * FROM Tracks, PlaylistTracks WHERE PlaylistTracks.TrackUniqueIDPtr =
>> Tracks.UniqueID AND PlaylistTracks.PlaylistUniqueIDPtr = 2 AND
>> (Tracks.SearchField LIKE '%hel%') ORDER BY Title, ArtistNoThe, Album,
>> TrackNumber
>> 
>> ...on a database in V4RB2.  It works on some databases, but not on this one
>> particular one.  DIAGNOSE finds no errors.
>> 
>> Mac OS 10.4.7, V4RB 2.3.
>> 
>> Submitted to Mantis, 0001678.  Any ideas for a workaround?
> 
> I believe I already have fix this few days ago.
> 
> And good news, I almost have fix 1676 bug after 3 days of hunting.
> VERY hard bug was ...
> 
> So may be today I will make new V4RB build
> 
> -- 
> 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