3.5.1 server - strange sql results

[Ruslan Zasukhin]

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