>Hi,
> How ot check whether I have defined the original key with a collating sequence of other than "machine"? I have check my setting from VFP option. It show machine in the column.
Check each tag with the IdxCollate() function. List structure will give you only the simple keys, i.e. the ones defined on the field, and only one key per field. If you have two tags on your PK, it's probably showing you only one of them - the new one, I think - and not the other one.
I've just tried to List Stru on one of tables here, and it shows 8 indexes, while the actual count is 10. Therefore, run this simple index checker:
for i=1 to tagc()
? tag(i), key(i), for(i), idxcollate(i), unique(i), primary(i)
endfor
You may add formatting to this - but, essentially, it's all here.
