Hi,

Does anyone know the way to create a new tctext field assigning the value of a tcmcs.str10 field?

Exemple:

domain tcmcs.str10 var1
domain tctext text1


var1="Hello"
text1=var1

You can use the TEXT.WRITE function, athough you will have to write your variable to a temporary file first (use the seq functions to create the temporary file).

example code baan

........................................................................................................
string xda2(4000)
xda = "Any_text_that_you_want"

ret = seq.open("pr", "w+")

xda2 = xda(1;80)
seq.puts(xda2,ret)
xda2 = xda(81;80)
seq.puts(xda2,ret)
seq.close(ret)

select *
from tdsls040 for update
where tdsls040._index1 ={300003}
selectdo
ret = text.write("tdsls040.txtb","5","text", "","",
"","text","text","pr" )
db.update(ttdsls040,DB.RETRY)

endselect
commit.transaction()
......................................................................................................:)