Error description: (DOS Error 267) DBFCDX/1006 Create error

[Otto]

Hello,
Can someone help me please.
I try with:

index on field-> ORDER DAY TmpAUFT6 TO TEMPUMS TEMPORARY

to create a temporary index.
Where is it created?

Error description: (DOS Error 267) DBFCDX/1006 Create error: TEMPUMS.cdx

Best regards
Otto

[Enrico Maria Giordano]

Hello,
Can someone help me please.
I try with:

index on field-> ORDER DAY TmpAUFT6 TO TEMPUMS TEMPORARY

This is a wrong syntax. You can't use spaces inside a field name.

EMG

[Otto]

Hello Enrico,
I am sorry, but autocorrection changed the expression.
I have:
index on field->AUFTRAGNUM TAG TmpAUFT6 TO TEMP5 TEMPORARY

( Auftragnum was translated to order and TAG to day )

Can you please help me. Where do I find the directory.
Best regards
Otto

[Enrico Maria Giordano]

I can't reproduce the problem. Can I have your DBF and all that is required to reproduce the problem here, please?

EMG

[Otto]

Hello Enrico,
I have the problem in a vm. Everything works fine for me local. In this VM I get the error with every database.
I asked the question before, then I was able to solve the problem, but I don't remember where the temp folder is.

viewtopic.php?f=3&t=37533&p=224442&hilit=temporary+index#p224442
Thank you for your help.
Best regards
Otto

[Otto]

Hello Enrico,
now I inserted
? GETENV("TMP")
and I see that the environment is:

WINDOWS 10
c:\Users\Otto Buero\AppData\Local\Temp\

SERVER 2019
c:\Users\Otto Buero\AppData\Local\Temp\16

If I create 16 my self all is working.
But what is the correct way.
Best regards
Otto

Code: Select all  Expand view

#include 'fivewin.ch'

//----------------------------------------------------------------------------//
REQUEST DBFCDX
REQUEST DBFFPT
//----------------------------------------------------------------------------//

Function main()
//----------------------------------------------------------------------------//
       
        ? GETENV("TMP")
       
        use "umsatz.dbf" new
        index on field->bezeichnun  TAG TmpB5Nr TO TEMP5 TEMPORARY
       
        xbrowse("umsatz")
       
        msginfo( procname() + "   " + str(procline()) + "   " + str( 1 ) )

return nil
//----------------------------------------------------------------------------//        
INIT PROCEDURE PrgInit

   SET CENTURY ON
   SET EPOCH TO YEAR(DATE())-98

   SET DELETED ON
   SET EXCLUSIVE OFF

   REQUEST HB_Lang_DE
 

   HB_LangSelect("DE")
 

   SET DATE TO GERMAN

   SetHandleCount(205)
   rddsetdefault( "DBFCDX" )
   SetGetColorFocus()

   EXTERN DESCEND

   SetBalloon( .F. )
   SetKinetic( .T. )

   fwNumFormat( 'E', .t. )

RETURN










 

[Enrico Maria Giordano]

Sorry, I'm not familiar with VMs.

EMG

[karinha]

Mister otto, test please.

Code: Select all  Expand view

#include 'Fivewin.ch'
#Include "Directry.ch"
#Include "Ord.Ch"

ANNOUNCE RDDSYS
REQUEST DBFCDX
REQUEST DBFFPT

EXTERNAL DESCEND

FUNCTION Main()

//----------------------------------------------------------------------------//
       
   ? GETENV( "TMP" )
       
   // USE "umsatz.dbf" new

   // INDEX ON field->bezeichnun  TAG TmpB5Nr TO TEMP5 TEMPORARY
       
   // xbrowse( "umsatz" )

   USE CUSTOMER NEW

   INDEX ON FIELD->FIRST TAG FIRST TO TEMP5 TEMPORARY  // MEMORY
   GO TOP
       
   xbrowse( "CUSTOMER" )
       
   msginfo( procname() + "   " + str( procline() ) + "   " + str( 1 ) )

RETURN nil

//----------------------------------------------------------------------------//
INIT PROCEDURE PrgInit

   SET DATE TO GERMAN
   SET CENTURY ON

   // SET EPOCH TO YEAR( DATE() ) - 98  //??
   SET EPOCH TO YEAR( DATE() ) - 50  // OR 30

   SET DELETED ON
   SET EXCLUSIVE OFF
   SET MULTIPLE OFF

   REQUEST HB_Lang_DE

   HB_LangSelect( "DE" )

   // SetHandleCount( 205 )  // 16 Bits ??

   rddsetdefault( "DBFCDX" )

   SetGetColorFocus()

   SetBalloon( .F. )
   SetKinetic( .T. )

   fwNumFormat( 'E', .T. )

RETURN NIL
 

Regards.

[Otto]

Hello João,
I tried the changes but with no success.

As for the moment I implemented this solution which seems to work:


LOCAL CtMP := GETENV( "TMP" )
//----------------------------------------------------------------------------//
lMKDir(CtMP)
Thank you for your help and best regards
Otto