>Hi all,
>
>suddenly I get following error message in an application that has been running flawlessly for several months now: "Unable to create temporary work files".
>
>According to the error information I get from my error routing, the line that causes the Error is a "BEGIN TRANSACTION". What happens after the BEGIN TRANSACTION is an insert into an updatebale remote view of serveral records and then a tableupdate of 3 remote views.
>I already checked diskspace, user rights, read only attributes and so on and everything is ok.
>Who can help me ??
>
>Best Regards,
>Hans
Hans,
I would first double check space (can you copy a large file there?) and permissions on sys(2023), config.fpw settings, where the program was started from (it might happen unintentionally dblclick an exe on CD for example though it'd error much earlier). With no config.fpw settings tmpfiles default to 'work dir' in application shortcut. Might someone played with it?
From within code I'd also test if it's specific to that part of code or really an issue with temp work space:
create cursor xx (f1 c(250),f2 c(250),f3 c(250))
for ix=1 to 100000
insert into xx values ('')
endfor
lcTemp = sys(2015)
sort on f1 to (m.lcTemp)
erase ( m.lcTemp + '.*' )
use in 'xx'
Cetin