>>>will do the trick for a cursor. Caroline was right, except maybe for including the IDX part.
>>
>>Aw nuts. Well my heart was in the right place...
>
>Just save it for a view question :-)
>
>BTW, (for Caroline) I did test an IDX on a cursor later, and guess what? It does need get auto-deleted with cursor. Can't think of a situation to use an idx with cursor, but it does work just fine.
That's good to know - I just copied the syntax from the help and forgot to remove the IDX reference as I also thought that it would only work with a CDX - good to know that inadvertently I got it right :)
Caroline