Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Custom file extensions for CDX index files?
Message
From
23/08/2005 04:03:30
 
 
To
23/08/2005 03:24:24
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
Miscellaneous
Thread ID:
01042821
Message ID:
01042828
Views:
21
This message has been marked as the solution to the initial question of the thread.
>I have a need to have multiple tables with identical names but different file extensions. These tables do not have memo fields.
>
>The problem with this scenario is that only one table can have a CDX file. Is there a way to have a CDX file with a custom file extension? Can this be accomplished by hacking a DBF's header?
>
>Example goal:
>
>table1.abc (table), table1.abcx (cdx file)
>table1.123 (table), table1.123x (cdx file)
>
>Malcolm

You cannot do it with the structural CDX (those open implicitly)
because, as for the file memo the name is implicit: tablename.cdx

But, you can do it with a not structural cdx:
use table1.123 alias table1_123
INDEX ON somekey TAG someTag OF table1.123x
INDEX ON somekey2 TAG someTag2 OF table1.123x
...
USE
*
* OPEN
use table1.123 alias table1_123 INDEX table1.123x
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform