Does not create the index file

[Eugene Lutsenko]

When attempting to create an index file error occurs, the file can not be created:

SELECT (M_KlastCls)
INDEX ON STR(Num_Klast,15)+STR(999999.9999999-Sxodstvo,19,7) TO KlastCls

[rdonnay]

Do you have any more information about the error that occurred?

[Tom]

What is "Sxodstvo"? Is that a memvar or a database field?

[Eugene Lutsenko]

This database field



--------------------------------------------------
Date : 10.07.2014
Time : 12:57:01
Procedure : F4_2_2_2
Line Number : 50536
Information : Error BASE/8999
Description : File can not be created
Operation : DbCreateIndex
Thread ID : 1
Source :
Called from : (B)INIT: _DCINIT(28)
Called from : F4_2_2_2(50536)
Called from : (B)MAIN(681)
Called from : DC_GETLIST:EVENTLOOP(4596)
Called from : DC_GETLIST:READGUI(3800)
Called from : DC_READGUI(111)
Called from : MAIN(779)

Status:


Work Area 1 :
Alias: CLASSES ** EOF **/10
File Name: D:\ALASKA\AIDOS-X\AID_DATA\A0000001\SYSTEM\CLASSES.DBF
Dos Handle: ***
Data Driver: DBFNTX
Index Hndl Tag Name File Name Key
----- ---- ---------- ------------- -------------------------------

Work Area 2 :
Alias: SXODCLS_ ** EOF **/10
File Name: D:\ALASKA\AIDOS-X\AID_DATA\A0000001\SYSTEM\SxodCls_Abs.DBF
Dos Handle: ***
Data Driver: DBFNTX
Index Hndl Tag Name File Name Key
----- ---- ---------- ------------- -------------------------------

Work Area 3 :
Alias: KLASTCLS Record 1/100
File Name: D:\ALASKA\AIDOS-X\AID_DATA\A0000001\SYSTEM\KlastClsAbs.DBF
Dos Handle: ***
Data Driver: DBFNTX
Index Hndl Tag Name File Name Key
----- ---- ---------- ------------- -------------------------------
1** 0 KLASTCLS KlastCls.NTX STR(Num_Klast,15)+STR(999999.99

Work Area 4 :
Alias: SXODCLS_ ** EOF **/10
File Name: D:\ALASKA\AIDOS-X\AID_DATA\A0000001\SYSTEM\SxodCls_Prc1.DBF
Dos Handle: ***
Data Driver: DBFNTX
Index Hndl Tag Name File Name Key
----- ---- ---------- ------------- -------------------------------

Work Area 5 :
Alias: KLASTCLS Record 100/100 ** Database Selected **
File Name: D:\ALASKA\AIDOS-X\AID_DATA\A0000001\SYSTEM\KlastClsPrc1.DBF
Dos Handle: ***
Data Driver: DBFNTX
Index Hndl Tag Name File Name Key
----- ---- ---------- ------------- -------------------------------

File(s) Open:
Handle File Name

Command Sets Loaded:

ALTERNATE OFF
ALTFILE
AUTOINDEX OFF
AUTOLOCK ON
BELL OFF
CANCEL ON
CENTURY ON
CHARSET 1
CHRKEY 290
COLLATION {...}
CONFIRM OFF
CONSOLE ON
CURSOR
DATEFORMAT dd.mm.yyyy
DCLIP D:\ALASKA\AIDOS-X\
DEBUG OFF
DEBUGFILE
DECIMALS 15
DEFAULT
DELETED OFF
DELIMCHARS ::
DELIMITERS OFF
DEVICE SCREEN
DOSKEY OFF
DOTSTACK 100
EDITOR
EPOCH 1900
ESCAPE ON
EXACT OFF
EXCLUSIVE OFF
EXIT OFF
EXTRA OFF
EXTRAFILE
FIXED OFF
FLDKEY 289
HISTORY
INCLUDE
INDEXKEY 279
INSERT OFF
INTENSITY ON
KEYSTAT ON
LEXICAL OFF
LIBS
LINKER
LINKOPT
MAKE
MARGIN 0
MAXROWS
MCENTER OFF
MCONFIRM ON
MESSAGE 0
ODIR
ODOMETER 5,00
PATH
PDIR
PEXT .PRG
PRINTER OFF
PRINTFILE
PROMPT DOS
PUBLIC OFF
QUERYKEY 272
RDD DBFNTX
RDDDICT DBFNTX
REEDIT ON
RESET OFF
SCOREBOARD ON
SCROLLBREAK OFF
SETCOLOR
SOFTSEEK OFF
SOUNDS OFF
STATUS ON
TALK OFF
TIME HH:MM:SS
TYPEAHEAD 60
UNIQUE OFF
USEDBFPROTECT OFF
USEEXCLDATA OFF
USEEXCLDICT OFF
WRAP ON
XPPOPT
XPPPATH

Memory(0) - Conventional Memory : 817152
Memory(2) - Program Run Memory : 4173824
Memory(4) - Virtual Memory (EMS) : 4194304

DOS Gateway Commands (COMM=):


<DO Procedure> Commands (PROC=):


Batch File Commands (BATC=):

[Auge_Ohr]

When attempting to create an index file error occurs, the file can not be created:

SELECT (M_KlastCls)
INDEX ON STR(Num_Klast,15)+STR(999999.9999999-Sxodstvo,19,7) TO KlastCls

i think String is too long

Code: Select all

STR(x,15) + STR(999999.9999999-y,19,7) -> 23

[Eugene Lutsenko]

Does not work. I was not like this since 1988 when I started working on the CLIPPER. It seems as if the file with the same name has been busy.

[Eugene Lutsenko]

Happened. It works. So it turns out that you can not create a new index file with a name that is already open at the time of the index file


M_KlastCls = "KlastCls"+Ar_Model[m]
SELECT (M_KlastCls)
INDEX ON STR(Num_Klast,15)+STR(99999.9999999-Sxodstvo,19,7) TO (M_KlastCls)

[rdonnay]

If you use the DBFCDX or FOXCDX driver, and use tag names instead of separate index files, then you can recreate an index that is already open.

[Eugene Lutsenko]

Thank you, Roger! Before that I did not reach, use NTX. I'm always so glad Your messages. Very grateful to You and all the forum participants for the possibility of human communication and ongoing support.