select bug

[Ruslan Zasukhin]

On 9/13/06 6:16 AM, "kuzemsky katy" <katy at ociwen.com> wrote:

Hi Katy,

> Hello All,
> 
> 
> VAMD 2.4.1
> Windows xp
> MacosX 10.4.7
> Director Mx 2004
> 
> 
> T1 = a table
> F1 = varchar field
> F2 = string field
> 
> F1 contains the same datas as  F2. It contains myValue for example.
> 
> 
> On mac, no problem.
> On pc, I have a problem of select
> 
>   query1 : Select * from T1 where F1 = 'myValue'    ->problem
>   query2 : Select * from T1 where F2 = 'myValue'    ->OK
>   query3 : Select * from T1 where F1 = 'myValue%'   ->problem
>   query4 : Select * from T1 where F1 = 'myValu%'    ->OK
>   query5 : Select * from T1 where substr(F1,1, 6) = 'myValue' ->OK
> 
> Query1 returns 0 result or it must return 1 result. It's the same
> thing for query3. The other queries return the right thing.
> 
> I have the same thing with the query builder of Vstudio.
> 
> 
> Is there something wrong in query1?

Today I will upload new build of most products.

Was fixed cross-platform issue on strings.
It looks you have meet this issue here.


-- 
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]