3.5.1 server - strange sql results

[Florian Bogeschdorfer]

Hi Robert

I have a very similar issue and I have given the matter to Ruslan and Ivan
just one hour ago. Ruslan suspects a wrong date/time format in DB and they
are checking now.

Best, Florian

>
>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 nichols
>
>formwork design llc
>114 3rd st ne | charlottesville, va 22902 | 434.296.2223 |
>www.formworkdesign.com
>
>
>
>
>_______________________________________________
>Valentina mailing list
>Valentina at lists.macserve.net
>http://lists.macserve.net/mailman/listinfo/valentina