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 .DOT 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@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
_______________________________________________
Valentina mailing list
Valentina (at) lists .DOT macserve.net
http://lists.macserve.net/mailman/listinfo/valentina
©2008 Robert Nichols |
