Hi

we had use comparison in baan 5 in select query but in LN its giving compilation error please provid any solution i even tried to use variable but still its giivng error

e.g. for clarification

tdsls400.aaaa say is a table field of tdsls400.
i have this to field values both of same domain
now i am using it as

select tdsls401.*
from tdsls401
where tdsls401._index1 = {:tdsls400.orno}
and (tdsls401.xxxx <> :tdsls400.aaaa)
selectdo
endselect


this is giving error even talking tdsls400.aaaa's value in a variable is giving error incompatibl data type please give me a soltuion.

I think that the domain of at least one of the fields tdsls401.xxxx and tdsls400.aaaa was changed from BaanERP to ERP LN. You can't compare strings with numeric fields.

I had this problem.

In ERP LN the domain tcorno changed from float to String.
just to give you the option of a order number like

AAA000125 and so on...

Hi Mahesh,

This question has already being posted by you in earlier thread,
http://www.baanboard.com/baanboard/showthread.php?t=29813

Why are you starting a new thread again? Didnt the proposed solutions solve your problem ? If not then let us know, so that someone may propose another solution.

Cya