>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