>Frank,
>
>Unless I am missing something, this doesn't solve the problem I have. I am looping through the field collection and then replacing the caption with the VPM DD caption. At the end of this I want to sort the field collection on the file/caption.
Jack, what I do is the following:
First I clear the collection.
Then I look if I have a metatable, if so, use that one to fill the field collection.
But if it does not exist I fill the fieldcollection using
SELECT SQL statements and loField=.oFieldsCollection.ADDITEM()
Because the SELECT SQL is ordered, all AddItem() call are done in the right order.
hth,
Frank Camp