FiveTech Software tech support forums

Hello,
trying to create a TEMPORARY index I get following error:
Error description: (DOS Error 267) DBFCDX/1006 Create error: TEMPUMS.cdx

index on field->AUFTRAGNUM TAG TmpAUFT6 TO TEMPUMS TEMPORARY

Can someone please help me.
Thank you in advane
Otto

Hello,
Now I copied the whole program to this new server and get:
hb_cdxSortWritePage: Can't create temporary file.
Thank you for your help and best regards,
Otto

Do you have write permits ?

Dear Antonio,
where are the temporary files located.
Thank you in advance Otto

Dear Antonio,
thank you for your help.
Yes it was a problem with permits.
Best regards,
Otto

Dear community,
I have the same issue with a program. I get "...Create error: TEMP5.cdx...".
Can anyone help me, please? Where do I have to set the permission?
Where is temp5.cdx created.
Thank you in advance and kind regards
Iris

Dear Iris,

Where is TEMP5.dbf located ?

Try so:

Code: Select all  Expand view

FOR i:= 1 to 3
   TRY
       INDEX ON ....
       EXIT
   END
NEXT

Dear all,

this was the solution:

function main()
LOCAL CtMP := GETENV( "TMP" )

lMKDir(CtMP)

Kind regards and thank you for the answers!

Just for general reference.

Here are some notes (to myself) from my note app:

At the top of your program you should set the default path to DBFs and indexes.

SET DEFAULT TO ".\"

Note that above prepresses to:

Set(7.".\")

To use a variable you can't do:

SET DEFAULT TO cPath

But this works:

SET DEFAULT TO (cPath)

If you don't set the path, you may have an issue like I once did. The files were created and saved, but I couldn't find them. They were not in the same directory as the EXE which they normally are. There were stored in a completely different directory. Took me hours to figure this out.

So always set the default path!

Nice to see you back on the forum, Iris.

Mr.Otto,

I create Temporary Indexes as under and working Ok since a long time.

Code: Select all  Expand view

USE <database>
INDEX ON <field> TAG <cTag> TEMPORARY or MEMORY
OrdSetFocus(cTag)
 

Plese note that TO <FileName> clause is not required when you use
TEMPOARAY or Memory clauses.

-Ramesh Babu