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

[Ruslan Zasukhin]

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]