Valentina Studio crashing on SQL

[Ruslan Zasukhin]

On 6/26/06 6:31 AM, "Steve Albin" <steve at steve-albin.com> wrote:

Hi Steve,

Have you diagnose your db ?

May be = 3 record is bad ?

> I am having a very odd problem with Valentina Studio.
> 
> The following SQL works fine:
> 
> Select * from Perfs, IssPerfs
>     WHERE Perfs.nSessId = 2
>     AND Perfs.nPerfId = IssPerfs.nPerfId
> 
> The following SQL crashes Valentina Studio:
> 
> Select * from Perfs, IssPerfs
>     WHERE Perfs.nSessId = 3
>     AND Perfs.nPerfId = IssPerfs.nPerfId
> 
> There is no value of Perfs.nSessid = 3.  I would expect an empty cursor, but
> instead Valentina Studio just crashes and subsequently will not open the
> database.  The target database is a V4RB 1.10 database that I allow Valentina
> Studio to convert to V2.
> 
> I am using Valentina Studio 2.3.  I really don't care if Valentina Studio
> works for me, but the real problem is that my V4RB 2.4b13 app is crashing on
> the same SQL. 



-- 
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]