3.5.1 server - strange sql results

[Ruslan Zasukhin]

On 31/1/08 5:36 PM, "Robert Nichols" <robert at formworkdesign.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]