Hi,

I have modified new report using tfgld1406m000 session, I have insert filed as following way

select tfgld495.*
from tfgld495
where tfgld495.guid = :tfgld106.ref2
selectdo
endselect

select cisli225.*
from cisli225
where cisli225.msid = :tfgld495.rbid
and cisli225.msln = :tfgld495.rpon
endselect


But getting following error when I compiled

rtfgld140611004( 398): Error SQL: SQLState QP010: Parameter 'tfgld495.rbid' should be of type REAL instead of type STRING
rtfgld140611004( 370): Error SQL: SQLState QP010: Parameter 'tfgld495.rbid' should be of type REAL instead of type STRING


This happened cisli225.msid type is long, other tfgld495.rbid is string

How I can convert this filed to string in this report?

Please advice for this

Thanks in advance


Dinushi

select cisli225.*
from cisli225
where cisli225.msid = :1
and cisli225.msln = :2
wherebind(1, lval(tfgld495.rbid))
wherebind(2, lval(tfgld495.rpon))
endselect

obviously, if rbid or rpon doesn't contains valid numbers, you have runtime errors....

Hi,

Thanks for your kind advice, my report is work properly

Thanks & Regards
Dinushi
:)