On 31/1/08 5:36 PM, "Robert Nichols" <robert at formworkdesign DOT 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]
_______________________________________________
Valentina mailing list
Valentina@lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina
©2008 Ruslan Zasukhin |
