learner
7th December 2005, 19:29
Hi,

I am trying to populate the text for Customer Master by using function text.write



text.file.path = "C:\somefolder\textdata.txt"
my.bp.id = "100000009"

db.retry.point()

select tccom100.*
from tccom100
for update
where tccom100._index1 = {:my.bp.id}
selectdo
system.lang = "2"
text.return = text.write("tccom100.txta",system.lang,kw1,kw2, kw3, kw4, "", "", text.file.path)

if text.return > 0 then
long new, new1
new = db.update(ttccom100,db.retry)
new1 =commit.transaction()

endif

message("%s%d","Text ret", text.return)



Normally text.write returns the no. of lines written, but 90% of the time in my case it is returning me -4 which as per stnd. baan error documentation means "Interrupted system call"

Can somebody tell me where exactly I am doing the mistake ? Why sometimes the same code works, and sometime the same doesnt work.


Any help would be appreciated.

Thanks & Regards

Learner

learner
7th December 2005, 20:12
Hi,

After posting the post, I realised and figured the bug, the text file which was opened for writing TEXT DATA was still open , so that made text.write to generated -4, so programatically i closed the file and it worked.

Regards

Learner