Hello,

I got error message after compile the program script. The error is Type incompatibility: [String] and [Number]. Any one tell me please how to fix this error. Thank you

Hi,

Please post your script. The error means you are comparing a number with a string.

select tdsls400.orno, tdsls400.sotp, tdsls400.odat, tdsls400.ofbp,
tdsls400.cfrw, tdsls400.cpls, tdsls400.cbrn,tdsls400.creg
from tdsls400
where tdsls400._index1 inrange {:orno.f, :sotp.f, :ofbp.f} and {:orno.t, :sotp.t, :ofbp.t}
and tdsls400.orno refers to tdsls400
and tdsls400.sotp refers to tdsls094
and tdsls400.orno >= 01012010
and (tdsls400.bkyn = 1)
order by tdsls400._index1
selectdo
rprt_send()
endselect
}

Error got in line : and (tdsls400.bkyn = 1)

Hi,

You are going wrong.

1. sotp and ofbp are not part of index 1. Compare them separately.
2. orno is string so add "" to the order number.

Verify that the domain of tdsls400.orno field is a string. If is, enclose the value 01012010 in single quotes

Took me a couple of tries, but I go it into the correct forum.