indexing views?

[EMJULIAN]

When indexing views, can you build several indexes at once (using "index on...to ...") and then call them using "set order to tag..."? I tried this, and it only finds the last index that I build in the list, any other index comes back as an invalid tag.

Thanks!
Eve

 

[StewartUK]

Eve,

I think you should be doing INDEX ON...TAG...

The "TO" key-word creates (or tries to create) a separate index file. This only holds one index which would be the last one created. "TAG" creates an index file that can contain lots of indexes.

Each index command should be on a separate line.

Hope that helps,

Stewart

 

[Mike Lewis]

Eve,

In general, you can never create more than one index with a given INDEX command. As Stewart rightly says, each index requires a separate command.

Apart from that, I can see no reason for not being able to create multiple indexes on a view. If you issue several successive INDEX ON ...TAG ... commands, you will get several indexes.

Also, keep in mind that when you close the view, the indexes will disappear.

Mike


Mike Lewis
Edinburgh, Scotland

My Visual Foxpro web site:

http://www.ml-consult.demon.co.uk

My Crystal Reports web site:

http://www.ml-crystal.com