3.5.1 server - strange sql results

[Robert Nichols]

Excellent. 3.5.2 fixed it.
On Jan 31, 2008, at 1:15 PM, Ruslan Zasukhin wrote:

> On 31/1/08 5:36 PM, "Robert Nichols" <robert at formworkdesign.com>  
> wrote:
>
>> A SQL statement that worked fine in earlier versions is giving me
>> trouble in 3.5.1. I'm using v4rb and vserver.
>>
>> select trans.**,projects.fullname from trans,projects where  
>> trans.type
>> = 0 and trans.fldDate = '12/31/2007'
>>
>> Using 3.5.1, the above statement produces a cursor that does not
>> restrict the value of trans.type to 0. In other words, I get too many
>> records, some of them have trans.type = 1, etc.
>>
>>
>> If I eliminate from the query the relationship with table  
>> "projects"--->
>>
>>      select trans.**, from trans where trans.type = 0 and
>> trans.fldDate = '12/31/2007'
>>
>> then the cursor only includes records with the correct value for
>> trans.type.
>>
>> Is this clear?  It's a showstopper.
>
> Robert,
>
> In the case with Florian team, we have found that 3.5.1 have bug on  
> it,
> But good news is that this bug fixed 2 weeks ago for 3.5.2
>
> So you can try download fast Vstudio 3.5.2b10
>    http://www.valentina-db.com/download/beta/3.5.2b10
>
> And check your query opening db LOCALLY,
>    if it works, then just upgrade your tools to 3.5.2b10
>
>
> -- 
> 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

_____________________________________________________________________________

robert nichols

formwork design llc
114 3rd st ne | charlottesville, va 22902 | 434.296.2223 | www.formworkdesign.com