Valentina Studio crashing on SQL

[Steve Albin]

On Monday, June 26, 2006 sunshine at public.kherson.ua (Ruslan Zasukhin) wrote:

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

Actually Perfs.nSessid does not exist.  Should give empty cursor.  I did a diagnose before the SQL and no problems are found.  

I just submitted this to Mantis with a small database that will reproduce the problem.  Entry number 1667.  


Steve

--
Steve Albin - Montclair, NJ
http://www.jazzdiscography.com/
http://www.steve-albin.com/ 


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