Page 1 of 1
Error description: (DOS Error 267) DBFCDX/1006 Create error
Posted: Tue Jan 21, 2020 9:15 am
by 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
Re: Error description: (DOS Error 267) DBFCDX/1006 Create error
Posted: Tue Jan 21, 2020 9:59 am
by Enrico Maria Giordano
Otto wrote: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
Re: Error description: (DOS Error 267) DBFCDX/1006 Create error
Posted: Tue Jan 21, 2020 10:17 am
by 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
Re: Error description: (DOS Error 267) DBFCDX/1006 Create error
Posted: Tue Jan 21, 2020 10:41 am
by 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
Re: Error description: (DOS Error 267) DBFCDX/1006 Create error
Posted: Tue Jan 21, 2020 10:58 am
by 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#p224442Thank you for your help.
Best regards
Otto
Re: Error description: (DOS Error 267) DBFCDX/1006 Create error
Posted: Tue Jan 21, 2020 1:43 pm
by 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
#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
Re: Error description: (DOS Error 267) DBFCDX/1006 Create error
Posted: Tue Jan 21, 2020 1:45 pm
by Enrico Maria Giordano
Sorry, I'm not familiar with VMs.
EMG
Re: Error description: (DOS Error 267) DBFCDX/1006 Create error
Posted: Tue Jan 21, 2020 2:23 pm
by karinha
Mister otto, test please.
Code: Select all | Expand
#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.
Re: Error description: (DOS Error 267) DBFCDX/1006 Create error
Posted: Tue Jan 21, 2020 3:04 pm
by 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