hbenade
23rd March 2006, 10:11
I am getting an error in BaanC40c, have no Idea what causes this

In the function itdsls0005
I am doing this select using variable item.isls0005

select tiitm001.*
from tiitm001
where tiitm001._compnr = :ncmp.isls0005
and tiitm001._index1 = {:item.isls0005} |#SLS068a.n


error: Undefined Symbol tiitm001(type 6) used in query
Select variable tiitm001 not defined

bdittmar
23rd March 2006, 11:09
I am getting an error in BaanC40c, have no Idea what causes this

In the function itdsls0005
I am doing this select using variable item.isls0005

select tiitm001.*
from tiitm001
where tiitm001._compnr = :ncmp.isls0005
and tiitm001._index1 = {:item.isls0005} |#SLS068a.n


error: Undefined Symbol tiitm001(type 6) used in query
Select variable tiitm001 not defined


Maybe it's tiitm001._compnr ???

In 4c4 the item table has no field _compnr !

Regards

george7a
23rd March 2006, 12:18
I tried the code and it was compiled (with endselect).

Did you declare table ttitm001?
Don't you have selectdo / endselect?

- George