I am trying to use the text.edit function to allow users to edit text by using a button I have created. The function works fine if text has already been entered in the field before, and the text number <> 0. However, if no text has ever been entered in the field (text number = 0) then the function does not save the text. Does anyone know how to make this function create a new text number or something else that would work?

Thanks,
Jason

do you save the returned textnumber in the table?

something like:


if tdsls401.txta = 0
then
db.retry.point()

select tdsls401.txta
from tdsls401 for update
where tdsls401._index1 = {i.orno,:i.pono,:i.sqnb}
selectdo
text.edit("tdsls401.txta",language$,"","","","","","",3)

if tdsls401.txta <> 0
then
dal.update(...)
commit.transaction()
else
abort.transaction()
endif
endselect
endselect
endif