Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Errors with Index tags
Message
From
15/11/2002 16:23:13
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00723415
Message ID:
00723441
Views:
8
In the Copy file command in the first line of code, are those the tables and cdx's being copied?
If so you don't need the rest of the code. You'd only need to zap the local tables if any data is in them to start with empty tables.

When are the users getting these errors? When trying to use the tables/indexes or during the copying code below?

after you run the copying code, are the appropriate dbf, cdx (and fpt if any) files actually there?


Variable 'MYTAG' not found - this will occur if the tag is missing from the cdx or the cdx is missing, since when it doesn't find the cdx or index tag, it then assumes MYTAG is a variable

Index tag not found - i can only get this error when setting the index using index number (e.g. Set Order To 2 when only 1 index)

Structural .cdx file is missing - occurs when the table assumes it has an index file that belongs to it and cannot find it.


>This is how the files are copied:
>
><<
>
>Copy file (centralfiles) to (localfiles)
>For I = 1 to NoOfTables
> Use TheTable
> Copy structure to (localfile) with cdx
>endfor
>
>* to ensure that the index is correct
>For I = 1 to NoOfTables
> select LocalTable
> Reindex
>endfor
>
>>>
>
>I would like to trap these errors in a error handler and work around it.
>
>Please verify this:
>
>"Variable 'MYTAG' is not found" - Does this always refer to index tags? This happens when the .cdx file is missing
>"Index tag is not found" - indicates that there is an index file, but not the specified tag
>What is the difference between Structural .cdx file is missing & Variable 'MYTAG' is not found
>
>In all thses cases, shall I just recreate all the index tage for the table in question?
>
>Thank you
>
>Ria
Insanity: Doing the same thing over and over and expecting different results.
Previous
Reply
Map
View

Click here to load this message in the networking platform