mark_h
11th February 2002, 23:11
I have a table with a text field on it. When I delete this record I want to also delete the text. So I am trying to use text.delete, this is after the delete on my table and the commit.transaction.

if(tppss990.txtn>0) then
numlines = text.delete("tppss990.txtn","")
endif

I have tried several forms of the text.delete and the above is just the current version. Is there something I am missing? The record on my table gets deleted, but not the text in the text tables.

By the way - I am a super user on 4c3 and I created all the text in the test environment that I am trying to delete. Once my table is deleted I can go into tttxt1100m000 (Maintain Texts) and delete the text record.

Thanks

Mark

mark_h
11th February 2002, 23:23
I was going to just delete this post rather than admit my own stupidity, but since some views took place I would let everyone know I found my own solution. The code I posted actually works, but in order to run the new code I forgot to close the old version. I did not catch this until I tried to compile in debug mode. :)

Being a moderator I could have just deleted it and nobody would have known it but me. :)

Mark