RavCOder
5th September 2019, 18:34
My script give me this error:

ptdsls24000 (79)Error illegal type combination string + double

I created this query :


select distinct tdsls400.ofbp,tdsls400.orno
from tdsls400
selectdo
tdsls401.item, sum(tdsls401.qoor) : sum_quantity
from tdsls401
selectdo
sum = 0
sum = tdsls401.item + sum_quantity
endselect
selectdo
endselect



Help me, I've been there a long time and I don't know what to do anymore.
Regards,
-RavCoder-
bdittmar
5th September 2019, 20:52
My script give me this error:

ptdsls24000 (79)Error illegal type combination string + double

I created this query :


select distinct tdsls400.ofbp,tdsls400.orno
from tdsls400
selectdo
tdsls401.item, sum(tdsls401.qoor) : sum_quantity
from tdsls401
selectdo
sum = 0
sum = tdsls401.item + sum_quantity
endselect
selectdo
endselect



Help me, I've been there a long time and I don't know what to do anymore.
Regards,
-RavCoder-

Here's the problem:

sum = tdsls401.item + sum_quantity
tdsls401.item is type STRING
sum_quantity is type double

Regards
RavCOder
6th September 2019, 11:12
You are right! I can't convert the string to a double. In fact I solved it.