data type conversion

[vsudaya]

Hi,

I have float64 data type column, whenever i compare this column with 0(zero) value,
in layout experssion window for a variable, its giving invalid expression(RSV-RND-0051), this i may think
due to invalid type casting. my expression window code as follows.

case
column_name = 0 then 'h'
else 'n'
end

can anybody give how to type cast the column.

Thanks in advance
vsub

[BIsrik]

i suppose u typing this expression in a variable..in that case do even check on the defn of query items. try using 0.0 instead of 0.

srik

[vsudaya]

Yes, i am typing this in expession of variable, i have tried with 0.0
still its giving the same problem. even i checked defintion of query item. i have tried with some other item of text type, its does not have any problem, when i trying with data type float 64 column. i am getting this problem.

any idea.

thanks in adavance
vsub

[BIsrik]

in that case try using to_number function or cast function...and then use the data item in the variable...

Srik

[vsudaya]

Hi,

I have tried with to_number,cast function, still its giving the same problem, do yu think any problem in package ?

thanks in advance.
vsub

[BIsrik]

can u put the entire contents of the error..

Srik

[vsudaya]

Hi,

I got the where is the problem, its due to query's i am referring. query1, query2. i am creating variable and in expression window i am writing the code as follows. and i am using this variable(string type) in conditional style query1 column in report.

case
when [query2].[column_name] = 0 THEN 'H'
else 'N'
end

whenever i refer the column from query2, its giving invalid expression, if i put all the column in one query and do this i dont have problem.

but the in this case, i have 2 querys, which has got different filters(even though refer to one query subject), i cant
put all the columns in one query. how can i do this?

what is RSV-RND-0051 invalid expression  error mean?

thanks in advance
vsud