For #4, I don't see any attributes that indicate order. But just as a test, I defined a compound index on a table and looked at the table metadata in the Metadata Browser. In this view, the columns are associated to the index in the order that I assigned them. So perhaps you could use your loop variables (i,j,k, etc.) for ordinal position. That's just a guess on my part. I'm not sure what you mean by #3. The columns associated to an index do have the attributes "IsDiscrete", "IsNullable", etc. Maybe that gets you what you need.
... View more