V4RB2 comparison model

[Ruslan Zasukhin]

On 3/29/05 12:20 AM, "erne" <ernestogiannotta at tiscalinet.it> wrote:

> Hello Ruslan,
> 
> comparing an integer to a string data are coerced as real numbers
> but comparing a Long field to a String field data are coerced as strings
> 
> e.g.
> let's have LongField = 50 and StringField = "50"
> Select * from Table Where LongField = StringField
> finds nothing
> Select * from Table Where Trim(LongField) = StringField
> finds the record
> 
> is this the intended behaviour?

I think no. bug.
Integer is similar to long.

> Moreover I feel the need here of data conversion functions like
> Str(integer) as String and Val(string) as Real

2.0 support SQL's feature type cast.


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