- Remove From My Forums
-
Question
-
I have a client who is using an application developed in Visual Fox Pro 6.0. This client had a power failure during a posting run. Now when trying to repost, they get ERROR 26 NO TABLE HAS NO INDEX ORDER SET. Is there any
way of fixing this dbf without actually having Visual Foxpro 6.0. Thank you.
Answers
-
I think you may need to delete all tags and re-create them. For this you will need to have VFP 6.0.
-
Proposed as answer by
Wednesday, October 14, 2015 4:30 AM
-
Marked as answer by
Youjun Tang
Monday, October 19, 2015 7:14 AM
-
Proposed as answer by
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS
Contact US
Thanks. We have received your request and will respond promptly.
Log In
Come Join Us!
Are you a
Computer / IT professional?
Join Tek-Tips Forums!
- Talk With Other Members
- Be Notified Of Responses
To Your Posts - Keyword Search
- One-Click Access To Your
Favorite Forums - Automated Signatures
On Your Posts - Best Of All, It’s Free!
*Tek-Tips’s functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.
Posting Guidelines
Promoting, selling, recruiting, coursework and thesis posting is forbidden.
Students Click Here
table has no index order set ????table has no index order set ????(OP) 17 Jan 02 19:06 I am trying to do a search and I get the error «table has no index order set» I have set my clients file with several fields that are indexed. I am using a textbox on a form with this code in the keypress area of the text box LPARAMETERS nKeyCode, nShiftAltCtrl * SaveAlias() Saves current ALIAS() lcData = ALLT(THIS.Value)+ CHR(nkeyCode) SELE clients && Select Alias() RELE lcData THISFORM.list1.Refresh() * RestAlias() Restore old ALIAS() Red Flag SubmittedThank you for helping keep Tek-Tips Forums free from inappropriate posts. |
Join Tek-Tips® Today!
Join your peers on the Internet’s largest technical computer professional community.
It’s easy to join and it’s free.
Here’s Why Members Love Tek-Tips Forums:
Talk To Other Members- Notification Of Responses To Questions
- Favorite Forums One Click Access
- Keyword Search Of All Posts, And More…
Register now while it’s still free!
Already a member? Close this window and log in.
Join Us Close
Нет таких файлов нет вот содержимое лога
=== ОШИБКА № 1 ===
Дата: 15.12.2009 Время: 17:20:17
Код ошибки………: 26
Сообщение об ошибке: Table has no index order set.
Программа……….: PROCEDURE RESTOREGENERATORDBF BEST5_REINDEX.FXP
Номер строки…….: 1794
Ошибочная строка…: DATETIME()
Была выполнена цепочка нижеследующих программ:
ON…
PROCEDURE ALL_INDEX_BRO C:PROGRAM FILESBESTBEST5_34CLIENTBINFOXBRO.EXE
BEST5_REINDEX.FXP
PROCEDURE RESTOREGENERATORDBF BEST5_REINDEX.FXP
ON…
PROCEDURE FOXBRO_ERROR_PROC C:PROGRAM FILESBESTBEST5_34CLIENTBINFOXBRO.EXE
Версия FOXPRO……..: Visual FoxPro 07.00.0000.9465 EXE Support Library for Windows
Серийный номер FOXPRO:
Характеристики памяти компьютера:
SYS(12) : 655360
SYS(17) : Pentium
SYS(23) : 0
SYS(24) : 0
SYS(1001): 937361408
SYS(1016): 355952
Описание открытого файла данных:
Имя открытой БД: C:PROGRAM FILESBESTBEST5_34SERVERDATAPROREPTEMPL.DBF
ALIAS()……..: REPTEMPL
SEL ECT(0)……: 2
SELECT(1)……: 32767
ORDER()……..:
TAG(1)………:
TAG(2)………:
TAG(3)………:
TAG(4)………:
TAG(5)………:
KEY(1)………:
KEY(2)………:
KEY(3)………:
KEY(4)………:
KEY(5)………:
SYS(2021,1)….:
SYS(2021,2)….:
SYS(2021,3)….:
SYS(2021,4)….:
SYS(2021,5)….:
================================================================================
LIST MEMORY:
_OTOOLBAR Pub L .F.
_ADATA Pub A
( 1) L .F.
( 2) C «c:program filesbestbest5_34serverdatadbf2009best5.dbc»
( 3) C «c:program filesbestbest5_34serverdatadbfkyltyra2009best5.dbc
X
( 4) C «c:program filesbestbest5_34serverdatadbfbudgetbest5.dbc»
( 5) C «c:program filesbestbest5_34serverdataprobest5pro.dbc»
_LDECLARE Pub L .T.
_LOADLIB Pub L .F.
EXTERNALLIB
Pub O ISFOXSTRINGARRAY OBJECT
_ERR_COUNT Pub N 1 ( 1.00000000)
CNAMEDBC Local L .F. foxbro
CCOMMAND Local L .F. foxbro
CDOREINDEX Local L .F. foxbro
CNAMEDBC1 Local L .F. foxbro
CCREATIONDB
Local L .F. foxbro
CNOPROGRBAR
Local L .F. foxbro
COLDERROR Local C «DO FoxBro_Error_Proc WITH ERROR(), SYS( 16 ), LINENO(), MESSAGE(), M
X ESSAGE( 1 ), ‘C:PROGRAM FILESBESTBEST5_34CLIENTBINFB_ERROR1.LOG
X ‘» foxbro
LFLAGERROR Local L .F. foxbro
LDOREINDEX Local L .F. foxbro
LNOPROGRBAR
Local L .F. foxbro
_OLD_ERROR_PROC
Priv C «» foxbro
_ERR_FILE Priv C «C:PROGRAM FILESBESTBEST5_34CLIENTBINFB_ERROR1.LOG» foxbro
_ERR_PROC Priv C «DO FoxBro_Error_Proc WITH ERROR(), SYS( 16 ), LINENO(), MESSAGE(), M
X ESSAGE( 1 ), ‘C:PROGRAM FILESBESTBEST5_34CLIENTBINFB_ERROR1.LOG
X ‘» foxbro
_NO_ERRORS Priv L .F. foxbro
_OFORM Priv O PROGR all_index_bro
PCPATH Priv C «C:PROGRAM FILESBESTBEST5_34SERVERDATAPRO» best5_reindex
CTASK Priv C «» best5_reindex
LONLY Priv L .F. best5_reindex
NARXIV Priv N 0 ( 0.00000000) best5_reindex
CBASE Priv C «» best5_reindex
LUPDATECRC Priv L .F. best5_reindex
LNOTEST Priv L .F. best5_reindex
OFORM Priv O PROGR best5_reindex
LLOGFILE Priv L .T. best5_reindex
NRETURNVALUE
Priv N 0 ( 0.00000000) best5_reindex
NPREFIXNNOPER
Priv L .F. best5_reindex
CCURR_PROF Priv L .F. best5_reindex
CRUN Local C «Runner.EXE Array5.bdll FoxBroReindex «C:PROGRAM FILESBESTBEST5_34
X SERVERDATAPROBEST5PRO.DBC» — F 0 — F F 0 T 0 — — » best5_reindex
XRET Local N 0 ( 0.00000000) best5_reindex
LOLDEXCLUSIVE
Local L .T. best5_reindex
COLDDATABASE
Local C «C:PROGRAM FILESBESTBEST5_34SERVERDATAPROBEST5PRO.DBC» best5_reindex
_ERR_PROC Local C «DO FoxBro_Error_Proc WITH ERROR(), SYS( 16 ), LINENO(), MESSAGE(), M
X ESSAGE( 1 ), ‘C:PROGRAM FILESBESTBEST5_34CLIENTBINFB_ERROR1.LOG
X ‘» best5_reindex
ISPRO Local L .T. best5_reindex
YN_COUNT Local N 1 ( 1.00000000) best5_reindex
ERRNUM Local N 0 ( 0.00000000) best5_reindex
COLDEXCLUSIVE
Local C «OFF» best5_reindex
COLDCOLLATE
Local C «MACHINE» best5_reindex
COLDDELETED
Local C «ON» best5_reindex
COLDSAFETY Local C «ON» best5_reindex
TBN Priv C «reptempl X restoregeneratordbf
N Priv N 3409 ( 3409.00000000) restoregeneratordbf
NERRNUM Local N 26 ( 26.00000000) foxbro_error_proc
CPROGNAME Local C «PROCEDURE RESTOREGENERATORDBF BEST5_REINDEX.FXP» foxbro_error_proc
NLINENUM Local N 1794 ( 1794.00000000) foxbro_error_proc
CERRMSG Local C «Table has no index order set.» foxbro_error_proc
CCODETEXT Local C «DATETIME()» foxbro_error_proc
CERRFILE Local C «C:PROGRAM FILESBESTBEST5_34CLIENTBINFB_ERROR1.LOG» foxbro_error_proc
NI Local N 8 ( 8.00000000) foxbro_error_proc
NJ Local C «» foxbro_error_proc
CSETREFRESH
Local C «0» foxbro_error_proc
CERRDIR Local C «C:PROGRAM FILESBESTBEST5_34CLIENTBIN» foxbro_error_proc
CSETTALK Local L .F. foxbro_error_proc
CSETPRINTER
Local L .F. foxbro_error_proc
CSETDEVICE Local L .F. foxbro_error_proc
CSETCONSOLE
Local L .F. foxbro_error_proc
CSETALTERNATE
Local L .F. foxbro_error_proc
CSETALTERFILE
Local L .F. foxbro_error_proc
CALIAS Local L .F. foxbro_error_proc
CDBF Local L .F. foxbro_error_proc
NTABLE Local L .F. foxbro_error_proc
COLDONERROR
Local C «DO FoxBro_Error_Proc WITH ERROR(), SYS( 16 ), LINENO(), MESSAGE(), M
X ESSAGE( 1 ), ‘C:PROGRAM FILESBESTBEST5_34CLIENTBINFB_ERROR1.LOG
X ‘» foxbro_error_proc
CCURSELECT Local N 2 ( 2.00000000) foxbro_error_proc
NCURRECNO Local N 1 ( 1.00000000) foxbro_error_proc
NRECNO Local L .F. foxbro_error_proc
AWORKAREAS Local A foxbro_error_proc
( 1) L .F.
71 variables defined, 1521 bytes used
953 variables available
Print System Memory Variables
Pub C «»
_ALIGNMENT Pub C «LEFT»
_ASCIICOLS Pub N 80 ( 80.00000000)
_ASCIIROWS Pub N 63 ( 63.00000000)
_ASSIST Pub C «»
_BEAUTIFY Pub C «»
_BOX Pub L .T.
_BROWSER Pub C «»
_BUILDER Pub C «»
_CALCMEM Pub N 0.00 ( 0.00000000)
_CALCVALUE Pub N 0.00 ( 0.00000000)
_CODESENSE Pub C «»
_CONVERTER Pub C «»
_COVERAGE Pub C «»
_CUROBJ Pub N -1 ( -1.00000000)
_DBLCLICK Pub N 0.50 ( 0.50000000)
_DIARYDATE Pub D 15.12.2009
_DOS Pub L .F.
_FOXCODE Pub C «»
_FOXDOC Pub C «»
_FOXGRAPH Pub C «»
_FOXTASK Pub C «»
_GALLERY Pub C «»
_GENGRAPH Pub C «»
_GENHTML Pub C «»
_GENMENU Pub C «»
_GENPD Pub C «»
_GENSCRN Pub C «»
_GENXTAB Pub C «»
_GETEXPR Pub C «»
_INCLUDE Pub C «»
_INCSEEK Pub N 0.50 ( 0.50000000)
_INDENT Pub N 0 ( 0.00000000)
_LMARGIN Pub N 0 ( 0.00000000)
_MAC Pub L .F.
_MLINE Pub N 0 ( 0.00000000)
_OBJECTBROWSER Pub C «»
_PADVANCE Pub C «FORMFEED»
_PAGENO Pub N 3 ( 3.00000000)
_PBPAGE Pub N 1 ( 1.00000000)
_PCOLNO Pub N 32 ( 32.00000000)
_PCOPIES Pub N 1 ( 1.00000000)
_PDRIVER Pub C «»
_PDSETUP Pub C «»
_PECODE Pub C «»
_PEJECT Pub C «NONE»
_PEPAGE Pub N 32767 ( 32767.00000000)
_PLENGTH Pub N 66 ( 66.00000000)
_PLINENO Pub N 33 ( 33.00000000)
_PLOFFSET Pub N 0 ( 0.00000000)
_PPITCH Pub C «DEFAULT»
_PQUALITY Pub L .F.
_PRETEXT Pub C «»
_PSCODE Pub C «»
_PSPACING Pub N 1 ( 1.00000000)
_PWAIT Pub L .F.
_RMARGIN Pub N 80 ( 80.00000000)
_RUNACTIVEDOC Pub C «»
_SAMPLES Pub C «C:PROGRAM FILESCOMMON FILESMICROSOFT SHAREDVFPSAMPLES»
_SCCTEXT Pub C «»
_SCREEN Pub O FORM
_SHELL Pub C «»
_SPELLCHK Pub C «»
_STARTUP Pub C «»
_TABS Pub C «»
_TALLY Pub N 1 ( 1.00000000)
_TASKLIST Pub C «»
_TEXT Pub N -1 ( -1.00000000)
_THROTTLE Pub N 0.00 ( 0.00000000)
_TRANSPORT Pub C «»
_TRIGGERLEVEL Pub N 0 ( 0.00000000)
_UNIX Pub L .F.
_VFP Pub O UNKNOWN TYPE
_WINDOWS Pub L .T.
_WIZARD Pub C «»
_WRAP Pub L .F.
81 System Variables Defined
Menu and Pad Definitions
0 Menus Defined
Popup Definitions
_HELP 609 bytes
_TOOLS 696 bytes
_TABLE 1914 bytes
_VIEW 1479 bytes
_EDIT 1131 bytes
_FILE 1740 bytes
6 Popups Defined
Window Definitions
Name Fr om To Size
PROGRESS 6.450,21.375 22.650,92.625 364 bytes
1 Window Defined
================================================================================
LIST STATUS:
Processor is Pentium
Current Database: C:PROGRAM FILESBESTBEST5_34SERVERDATAPROBEST5PRO.DBC
Currently Selected Table:
Select area: 2, Table in Use: C:PROGRAM FILESBESTBEST5_34SERVERDATAPROREPTEMPL.DBF Alias: REPTEMPL
Code page: 1251
Memo file: C:PROGRAM FILESBESTBEST5_34SERVERDATAPROREPTEMPL.FPT
Lock(s): <none>
Select area: 1, Table in Use: C:PROGRAM FILESBESTBEST5_34SERVERDATAPROGENERATOR.DBF Alias: GENERATOR
Code page: 1251
Structural CDX file: C:PROGRAM FILESBESTBEST5_34SERVERDATAPROGENERATOR.CDX
Index tag: TABLENAME Collate: Machine Key: UPPER(TABLENAME)
Lock(s): <none>
Procedure file: LOADLIB.FXP
Class libraries: C:PROGRAM FILESBESTBEST5_34CLIENTBINBRO.VCX ALIAS BRO
File search path:
Default directory: C:PROGRAM FILESBESTBEST5_34CLIENTBIN
Print file/device:
Work area = 2
Margin = 0
Decimals = 2
Memowidth = 50
Typeahead = 20
Blocksize = 64
Reprocess = 10.00 SECONDS
Refresh = 0,5 SECONDS
DDE Timeout = 2000
DDE Safety = on
Code page: 1251
Collating sequence: Machine
Compiler code page: 1251
Date format: Short
Macro Hot Key =
UDF parameters are passed by: VALUE
On Shutdown: CLEAR EVENTS
ON KEY LABEL hot keys:
ALT+M CreateMenuTools()
Textmerge Options
Delimiters: Left = << Right = >>
Show
Alternate — off Color — on Exact — off Logerrors — on Space — on
ANSI — off Compatible — off Exclusive — on Mouse — on Status Bar — on
Asserts — off Confirm — off Fields — off Multilocks — on Sysmenus — on
Bell — on Console — off Fixed — off Near — off Talk — off
Blink — on Cursor — on Fullpath — on Null — off Textmerge — off
Brstatus — off Deleted — on Heading — on Optimize — on Title — off
Carry — off Device — scrn Help — off Print — off Unique — off
Century — on Echo — off Intensity — on Readborder — off
Clear — on Escape — on Lock — off Safety — off
Declared DLLs:
BDA_RunAppFromFox X c:program filesbestbest5_34clientbinbestvmf.dll
RegCloseKey X C:WINDOWSsystem32ADVAPI32.dll
RegCreateKey X C:WINDOWSsystem32ADVAPI32.dll
RegDeleteKey X C:WINDOWSsystem32ADVAPI32.dll
RegDeleteValue X C:WINDOWSsystem32ADVAPI32.dll
RegEnumKey X C:WINDOWSsystem32ADVAPI32.dll
RegEnumKeyEx X C:WINDOWSsystem32ADVAPI32.dll
RegEnumValue X C:WINDOWSsystem32ADVAPI32.dll
RegOpenKey X C:WINDOWSsystem32ADVAPI32.dll
RegQueryValueEx X C:WINDOWSsystem32ADVAPI32.dll
RegSetValueEx X C:WINDOWSsystem32ADVAPI32.dll
StringFromGUID2 X c:windowssystem32ole32.dll
================================================================================
Открытые таблицы:
2 — ‘REPTEMPL’ — ‘C:PROGRAM FILESBESTBEST5_34SERVERDATAPROREPTEMPL.DBF’
Record# ID GUID NAME X TECH TEMPLATE ISSYSTEM USERCODE STATIONID MODIFIED TYPEBASE
1 3 вкeuХДЦ‘= Журнал регистрации кассовых документов ( в валюте учета) X 1 Memo .T X 1 18.11.2002 18:23:38 A
1 — ‘GENERATOR’ — ‘C:PROGRAM FILESBESTBEST5_34SERVERDATAPROGENERATOR.DBF’
Record# TABLENAME X LASTID
4 reptempl X 2161
================================================================================