Hi,

My FoxCode-Table is about 1100 records long by now and I realized that there is not any index on it at all.

I looked through the foxscript SourceCode and found several SQL's and based on them, I did as follows:

lc_FoxCode = _FoxCode
_FoxCode   = ""

use (lc_FoxCode) exclusive

index on CMD tag CMD additive
index on ABBREV tag ABBREV additive
index on upper(ABBREV) tag U_ABBREV additive
index on upper( alltrim(ABBREV) ) tag UA_ABBREV additive
index on TYPE tag TYPE additive
index on upper(TYPE) tag U_TYPE additive
index on deleted() tag DELETED additive

use
_FoxCode = lc_FoxCode

After that I reopened the table (shared) looked at the structure and funnily all indices were gone (I think there is always a backup around). So I quit and opened VFP6, had a look at the table and found the indices. I made a reindex just to be sure, and after closing VFP6 and reopening VFP7 the indices are where they belong.

I have the feeling macros are much faster now.

Anything that speaks against having indices on FoxCode?