On 31/1/08 5:36 PM, "Robert Nichols" <robert AT formworkdesign D.O.T com> wrote:
Hi Robert,
> 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.
First advice -- check your DateTime formats.
DateTime Separators...
--
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
©2008 Ruslan Zasukhin |
