I am trying to export the text records from tsclm100 - I only want records where there is text in tsclm100.txte.
The two fields I am after are tsclm100.ccll and the actual text for tsclm100.txte - but I only want the record exported if there is text.

I have written exchange scheme which exports the data - but I get records where there is no text as well.

I tried a range - txte not equal to 0 - but that will not compile - it complains about illegal type combination string <> long.

Any suggestions on how I can construct a range or condition to achieve this?

thanks

Here is the condition I am using to filter out some records that I don't want;
table ttsclm100

select tsclm100.*
from tsclm100
where tsclm100._index1 = {:ccll}
as set with 1 rows


selectdo

if tsclm100.stat = tsclm.stat.accept then
return(false)
endif
if tsclm100.stat = tsclm.stat.regist then
return(false)
endif
endselect

return(true)

Well you would think adding a check like tsclm100.txte>0 would work. Can you post the code that does not work? Been a while since I looked at exchange schememes.

Mark,
thanks for your suggestion - that works.
I had tried that with a range - but not just that in the script.
bob