>Hi Friends,
>
>I am opening a Local SQL View like this
>
>Open database MIS Shared
>Use IndentDet In 0 Alias RepTab1 --- Generates Error
>
>Error No 26
>Table has no index order set.
>
>Any ideas why this error for ?
>
>Aashish

Aashish,
(Got here from chatter:)
Maybe you're looking at wrong place for the error. ie: A view normally has no indexes. It might be refrenced in a grid with childorder = 'someorder'.
Cetin