>>I created the index in a view table from MS sql table
>>thank I set the order
>>howerver when I quit fox and come back try to run it again
>>I get table has not index order
>
>Views are temporary files. You need to create index again.

Also, if you use a CursorAdapter to access this DB instead of a remote view, you can build the re-indexing code right into the CursorAdapter.