Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>Hi all
>
>Is it possible to create a Regular index programatically with similiar results to the table designer where the index key is part of the .cdx file. If I use "Index on something to something", a .idx file is created. Maybe thats ok, but it seems to be a legacy from the past. I have almost completed a utility to copy database structures over to a new database and having seperate .ndx files would be a difference I could live with if needs be.
>
>TIA
>John Harriss
You want to issue an...
index on something tag something
This will put the index in the structural .CDX file.
index on something to something
as you say creates something.idx
index on something tag something of something
will create a something.cdx with a tag of something in it.
BTW: You shouldn't need a utility to do what you want.. you can just use the command...
COPY TO NewFileName DATABASE DataBaseName FOR .F. WITH CDX
BOb
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement