Table has no index order set ошибка foxpro

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)
Any ideas?

SELE clients && Select Alias()
SET NEAR ON
SEEK UPPE(lcData)
SET NEAR OFF

RELE lcData

THISFORM.list1.Refresh()

* RestAlias() Restore old ALIAS()

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

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:

  • Tek-Tips ForumsTalk 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

Источник
  • Remove From My Forums

  • Question

  • I have a client running a VFP7 application on a network with 5 users. The clients are using 4 Windows 7 PCs and 1 Windows 10 PC.

    The network was a Windows 2008 server. But this crashed last week.

    Everything was running great when the 2008 server was running. The VFP7 App performed great.

    A couple of days ago, the clients IT company put up a new server running Windows 2019 server.

    Now the client is having problems with the VFP7 app.

    1: Queries are taking 20 seconds to perform instead of sub-second. This happens on all client PCs.

    2: All clients get this error when the VFP7 app tries to create an index: «Table has no index order set»

    3: 2 client PCs get the following error that knocks them out of the VFP7 app. The app is trying to join 2 large tables at the time of this error: «Fatal error: Exception code=C0000094 @ 05/17/19 06:30:45 PM…..»

    Question: 

    -Can a VFP7 app run on Windows server 2019?

    -Is there anything that I can try to get this VFP7 app working in this environment?

    -Will converting it to VFP9 work? Or will VFP9 work better?

    -Any other advice?

    I realize that Foxpro is not supported, but the client really likes this app and wants to make it work.

Answers

  • What’s the role of the server, typically it’s just the file server for data. Are you running the EXE and clients are connecting with remote desktop? Please, don’t say the EXE is located on the server and clients have a shortcut to start the exe.

    Also, why would clients index data?

    You create your indexes once at design time of the database, you deploy your database with CDX files of the DBFs and the indexes update with any data changes. Only IDX indexes don’t automatically open with data and can get out of sync.

    http://fox.wikis.com/wc.dll?Wiki~C0000094Error tells, if you index, you should, first DELETE TAG ALL and then index, but indeed your problem might go away when you don’t index during runtime
    at all. I even think you’re not taking multi user into account, an error like «Table has no index order set» is to be expected when you index during runtime. There is no such thing as seamless (re)indexing. Unless you create local IDX indexes or
    indexes on cursors this is a big concurrency problem, no matter what server version, it’s likely to start occurring because tables grew larger and not because of which OS.

    If this is remote desktop (or Citrix or similar) even «local» IDXes are not local and exclusive to one user, unless you create them in the user session specific folders, if you move to remote desktop anything you generate in the applidcation folde
    that previous to introducing remote desktop was exclusive to a single user is now shared. So in that aspect centralising the installation of the application itself on a terminal server means you need to reorganise user specific local data and indexes and the
    only thing that’s automatic in that respect are cursors, generated in the session id separated TEMP folders.

    Besides that the likelyhood, IF its still an OS based problem is, you are victim of the oplock settings of Windows, if the server is just the file server. If the EXE runs on it together with the data being local there, that problem doesn’t arise, though.
    Win2008 server still allowed to turn smb3 off and revert to smb2, nowdays this is no possibility anymore, so if you used some registry entries to handle this, they’re not having any effect in todays Windows server versions.

    All of that should be really well known by now.

    Bye, Olaf.

    • Edited by

      Monday, May 20, 2019 8:20 AM

    • Proposed as answer by
      Alex-KSGZ
      Tuesday, May 28, 2019 7:19 AM
    • Marked as answer by
      Tom BorgmannEditor
      Wednesday, July 31, 2019 6:09 AM

  • It’s not an untypical setup, but it means you even have network traffic to start up the EXE. The process (the running application) will still be created on each client. But as it’s not installed locally, the EXE is read into client memory from the file share
    through the network.

    It would all be less worriesome, if this is just a one time hit at startup, but neither the EXE file nor runtime DLLs VFP uses are simply fully loaded into client memory just at startup. You get network errors, which clearly can be related to accessing the
    EXE and runtime DLLs on the network share while the application runs already for minutes/hours that are not happening at operations on DBFs. And that’s additional to the problems network access to DBFs on a share already has. They don’t go away unless you
    put all this on a terminal server, but you don’t just have say 1% more errors are startup time, when they don’t bite you much, as you then simply restart, you have qualitative other errors.

    In todays networks and protocol hurdles you have, it’s a bit of a wonder, if everything works out fine. I guess you either only have one user at a time or just a couple concurrently, les than 10 users? If you use a software like that with more than 10 users,
    you’ll likely see the problems coming up. Or you have a software where the vendor/developer have worked around the problems avoiding problematic features or making configurations, but less and less of them work, eg SMB can’t be changed to old versions. You
    might simply not have concurrent access of same data, really same records of same tables written to/updated.

    Bye, Olaf.

    • Edited by
      OlafDoschke
      Tuesday, June 4, 2019 1:26 PM
    • Marked as answer by
      Tom BorgmannEditor
      Wednesday, July 31, 2019 6:09 AM

Источник
title description author ms.author ms.date ms.service ms.subservice ms.topic helpviewer_keywords

Visual FoxPro ODBC Driver Native Error Messages

Visual FoxPro ODBC Driver Native Error Messages

David-Engel

v-davidengel

01/19/2017

sql

connectivity

conceptual

error messages [ODBC], Visual FoxPro ODBC driver

Visual FoxPro ODBC driver [ODBC], error messages

FoxPro ODBC driver [ODBC], error messages

Visual FoxPro ODBC Driver Native Error Messages

The following tables list error messages native to the Visual FoxPro ODBC Driver.

001

Error code Error message
1 Feature is not available.
2 Input/output operation failure.
3 Free handle is not found.
5 Use of unallocated handle.
99 Procedure canceled.

100

Error code Error message
100 Too many files open.
101 Cannot open file.
102 Cannot create file.
105 Error writing to file.
107 Invalid key length.
109 Record is out of range.
110 Record is not in index.
111 Invalid file descriptor.
113 File is not open.
114 Not enough disk space for value.
115 Invalid operation for the cursor.
118 Index file does not match table.
119 No table is open.
120 File does not exist.
121 File already exists.
122 Table has no index order set.
123 Not a table.
125 Index expression exceeds maximum length.
127 You must use a logical expression with a FOR or WHILE clause.
128 Not a numeric expression.
129 Variable is not found.
132 File is in use.
133 Index does not match the table. Delete the index file and re-create the index.
135 End of file encountered.
136 Beginning of file encountered.
137 Alias is not found.
139 You must use a logical expression with FILTER.
142 Cyclic relation.
143 No fields were found to copy.
144 The LOCATE command must be issued before the CONTINUE command.
145 Must be a character or numeric key field.
146 Cannot write to a read-only file.
147 Target table is already engaged in a relation.
148 Expression has been re-entered while the filter is executing.
149 Not enough memory for buffer.
150 Not enough memory for file map.
155 Invalid buffdirty call.
156 Duplicate field names.
158 No fields found to process.
159 Numeric overflow. Data was lost.
162 Procedure ‘value‘ is not found.
165 value is not related to the current work area.
170 Variable ‘value‘ is not found.
171 Cannot open file value.
173 File ‘value‘ does not exist.
174 ‘value‘ is not a memory variable.
175 ‘value‘ is not a file variable.
176 ‘value‘ is not an array.
177 Alias ‘value‘ is not found.
180 File was not placed in memory using the LOAD command.
182 There is not enough memory to complete this operation.

200

Error code Error message
200 Syntax error.
201 Too many names used.
202 Program is too large.
203 Too many memory variables.
205 Nesting error.
206 Recursive macro definition.
209 Line is too long.
210 Allowed DO nesting level exceeded.
211 An IF | ELSE | ENDIF statement is missing.
212 Structure nesting is too deep.
213 There is a missing keyword in the FOR…ENDFOR or DO CASE…ENDCASE command structure.
219 Command contains unrecognized phrase/keyword.
221 Command is missing required clause.
222 Unrecognized command verb.
224 Invalid subscript reference.
227 Missing expression.
228 Table number is invalid.
229 Too few arguments.
230 Too many arguments.
233 Statement is not allowed in interactive mode.
234 Subscript is outside defined range.
236 Suspend program before using RESUME.
238 No PARAMETER statement is found.
239 Must specify additional parameters.
240 Not a character expression.
250 Too many PROCEDURE commands are in effect.
252 Compiled code for this line is too long.
257 Key string is too long.
291 Expression used with ASIN() is out of range.
292 Cannot use 0 or negative as the argument for LOG10().
293 Expression used with ACOS() is out of range.
294 FOXUSER.DBF file is invalid.
295 Invalid path or file name.
296 Error reading the resource.
297 Command is allowed only in interactive mode.

300

Error code Error message
301 Operator/operand type mismatch.
302 Data type mismatch.
305 Expression evaluated to an illegal value.
307 Cannot divide by 0.
308 Insufficient stack space.
337 Cannot nest the PRINTJOB command.

400

Error code Error message
406 Printer is not ready.
407 Invalid argument used with the SET function.
410 Unable to create temporary work files.
423 Error creating the OLE object.
424 Error copying the OLE object to the Clipboard.
462 value internal consistency error.
465 SQL pass-through internal consistency error.
466 Connection handle is invalid.
467 Property is invalid for local cursors.
468 Property is invalid for table cursors.
469 Property value is out of bounds.
470 Incorrect property name.
471 Incorrect column format.
473 Environment-level property is invalid.
474 Invalid call issued while executing a SQLEXEC() sequence.
479 Invalid update column name value.
489 General fields cannot be used in the WHERE condition of an update statement. Change the WhereType property of the view.
491 No update tables are specified. Use the Tables property of the cursor.
492 No key columns are specified for the update table value. Use the KeyFieldList property of the cursor.
493 SQL parameter is missing.
494 View definition has been changed.
495 Warning: The key defined by the KeyField property for table value is not unique.
498 SQL SELECT statement is invalid.
499 SQL parameter value is invalid.

500

Error code Error message
502 Cannot write to the record because it is in use.
503 File cannot be locked.
508 Error initializing OLE.
520 No database is open or set as the current database.
522 Connectivity internal consistency error.
523 Execution was canceled by the user.
525 Function is not supported on remote tables.
526 Connectivity error: value.
527 Cannot load ODBC library, ODBC32.DLL.
528 ODBC entry point missing, value.
530 Fetching canceled; remote table is closed.
532 Type conversion is not supported.
533 This property is read-only.
536 Function is not supported on native tables.
538 A stored procedure is executing.
540 Session number is invalid.
541 Connection value is busy.
542 Base table fields have been changed and no longer match view fields. View field properties cannot be set.
543 Type conversion required by the DataType property for field ‘value‘ is invalid.
544 DataType property for field ‘value‘ is invalid.
545 Table buffer for alias value contains uncommitted changes.
546 Cannot close table during execution of table-bound expression.
547 Cannot insert an empty row from a view into its base table(s).
548 Table value has one or more non-structural indexes open. Please close them and retry the Begin Transaction.
549 Data session #value cannot be released with open transaction(s).
550 .DBC internal consistency error.
557 The database must be opened exclusively.
559 Property is not found.
560 Property value is invalid.
561 Database is invalid. Please validate.
562 Cannot find object value in the database.
563 Cannot find view value in the current database.
566 Cannot issue the PACK command on a database while its tables are in use.
567 Primary key property is invalid; please validate database.
570 Database is read-only.
571 The name value is already used for another
575 Object name is invalid.
577 Table value is referenced in a relation.
578 Invalid database table name.
579 Command cannot be issued on a table with cursors in table buffering mode.
580 Feature is not supported for non-.DBC tables.
581 Field value does not accept null value.
583 Record validation rule is violated.
585 Update conflict. Use TABLEUPDATE() with the lForce parameter to commit the update or TABLEREVERT() to roll back the update.
586 Function requires row or table buffering mode.
587 Illegal nested OLDVAL() or CURVAL().
589 Table or row buffering requires that SET MULTILOCKS is set to ON.
590 BEGIN TRANSACTION command failed. Nesting level is too deep.
591 END TRANSACTION command cannot be issued without a corresponding BEGIN TRANSACTION command.
592 ROLLBACK command cannot be issued without a corresponding BEGIN TRANSACTION command.
593 Command cannot be issued within a transaction.
594 Illegal to attempt a file lock in a transaction after taking prior record locks.
596 Table buffering is not enabled.
597 Views require either DB_BUFOPTROW or DB_BUFOPTTABLE.
598 Rule and trigger code must balance transaction usage.
599 Data session #value was forced to ROLLBACK all transactions to avoid deadlock.

600

Error code Error message
601 Alias name is already in use.
602 Operation is invalid for a Memo, General, or Picture field.
612 No such menu or menu item is defined.
618 Menu has not been defined with DEFINE MENU.
624 Menu title has not been defined with DEFINE PAD.
625 Menu has not been defined with DEFINE POPUP.
631 Array dimensions are invalid.
637 File must be opened exclusively to convert the Memo file.
638 Field must be a Memo field.
649 No previous PRINTJOB command to correspond to this command.
651 CANCEL or SUSPEND is not allowed.
659 The table has memo fields that cannot be converted while open read-only.
683 Index tag is not found.

700

Error code Error message
700 Record is in use by another user.
701 File must be opened exclusively.
702 File is in use by another user.
703 Record is not locked.
705 File access is denied.
706 Cannot sort .IDX files in descending order.
707 Structural .CDX file is not found.
708 File is open in another work area.
712 Field name is a duplicate or invalid.
714 Window ‘value‘ has not been defined.
718 File is read-only.
722 Preprocessor expression is invalid.
734 Property value is not found.
737 value is a method, event, or object.
738 Property value is not a method or event.
740 value is a read-only property.
748 This file is incompatible with the current version of Visual FoxPro.
750 File was created in a later version of Visual FoxPro than the current version.
763 Property value already exists.
773 Database object type is invalid.
784 This object is derived from a base class and does not have a parent class.

800

Error code Error message
802 SQL: Cannot locate table.
872 Too many columns.
879 No primary key.
884 Uniqueness of index value is violated.
885 Only structural tags can be defined as candidate.
886 Index does not accept NULL.
887 Illegal recursion in rule evaluation.
888 Tag name is too long.

900

Error code Error message
901 Function argument value, type, or count is invalid.
902 Expression evaluator failed.
903 String is too long to fit.
904 ** or ^ domain error.
905 LOG(): Zero or negative used as argument.
906 SQRT() argument cannot be negative.
912 Operation is invalid for a General field.
914 Code page number is invalid.
915 Collating sequence ‘value‘ is not found.
918 File name is too long.
922 Volume does not exist.
923 Object value is not found.
924 value is not an object.
925 Unknown member value.
928 Statement is only valid within a class definition.
929 value can only be used within a method.
930 Cannot redefine value.
931 Statement is not in a procedure.
934 Statement is only valid within a method.
935 The current object does not inherit from class value.
937 Procedure file ‘value‘ is not found.
938 Object is not contained in a value.
939 WITH/ENDWITH mismatch.
940 Expression is not valid outside of WITH/ENDWITH.
941 Error code is invalid.
942 Objects cannot be assigned to arrays.
943 Member value does not evaluate to an object.
945 The current object has been released.
947 Expression is too complex.
951 Cannot clear the object in use.
955 WIN.INI/registry is corrupted.
957 Error accessing printer spooler.
959 Invalid coordinates.
960 Illegal redefinition of variable value.
971 Cannot compile until the current COMPILE command has completed.
972 Array value is in use.
974 Arrays cannot be assigned to array elements.
976 Cannot resolve backlink.
988 Currency value is out of range.
990 Cancel.
999 Function is not implemented.
Источник

Table has no index order set. (26)

[Для таблицы не установлен порядок индексов]

Данная ошибка вызывается одним или несколькими условиями из числа следующих:

fox90000.gif Индекс для файла таблицы не был выбран в тот момент, когда была выдана команда

UPDATE с опцией RANDOM.

fox90000.gif Была предпринята попытка операции FIND или SEEK на неиндексированной таблице и

и при действующей установке SET ORDER TO 0.

fox90000.gif Была предпринята попытка выдать SET RELATION с применением нечислового реляцио

ного выражения для неиндексированной таблице или при действующей установке SET

ORDER TO 0.

Новое на сайте

  • Обновлен портфель программиста

    Добавлены: Установка HTML Help (Создание справочной системы), Imagedit.zip — Графический редактор ( ico и bmp), Библиотека локализации HTML Help (Русский)

  • Новые примеры программ

    Установка библиотек, Игровая программа «Охота на лис», Установка библиотек «Охота на лис», plastic -«Платежки», Библиотеки (на FPD26), platan -«Платежки» (на Clipper 5.2)

  • Обновленна справка

    Подсказки, технология программирования и использование Visual FoxPro. Команды, функции, операторы, объекты, свойства, события и методы.

Источник
  • 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

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 ????

(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)
Any ideas?

SELE clients && Select Alias()
SET NEAR ON
SEEK UPPE(lcData)
SET NEAR OFF

RELE lcData

THISFORM.list1.Refresh()

* RestAlias() Restore old ALIAS()

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

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:

  • Tek-Tips ForumsTalk 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

==================================================­==============================

Источник

Понравилась статья? Поделить с друзьями:
  • T790 ошибка картриджа
  • T46 ошибка webasto
  • T04 513 ошибка riso
  • T01 521 ошибка ризограф
  • T кратная средняя ошибка выборки называется ошибкой выборки