hi:

I will develope an report in BaaN V ,but when i was edit that script , the BaaN SQL cant select item data from tcibd001(target item into there).
my script:

select tcibd001.item
from tcibd001
where tcibd001._index = {:var.item}
as set with 1 rows
selectdo
....
selectempty
....
endselect

of all times(var.item record exist or not exist), select segment will goto selectempty!!!
why?and how to i can do it?What difference between baan IV and BaaN V ?
segment fields?
thanks!

I did a search on this forum(segmented fields) and found this post (http://www.baanboard.com/baanboard/showthread.php?t=14637&highlight=segmented+fields). Check out what NPR posted part way down and see if that helps.

Mark

you are missing the index number.


where tcibd001._index = {:var.item}


it should be:


select tcibd001.item
from tcibd001
where tcibd001._index1 = {:var.item}
as set with 1 rows
selectdo
....
selectempty
....
endselect

Thanks mark and malutz！
so, I was resolved it ,
because of that field defined a segmention in tcidb000,I must added some space to item var.