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 .DOT macserve.net
http://lists.macserve.net/mailman/listinfo/valentina
©2008 Robert Nichols |
