Hi Jill,

Erik was warning you not to index views with table-buffering turned on. So he was telling you to make sure that when you indexed the view that you should set buffering to 3 which is row-buffering.

Are you performing the indexing within the BEGIN .. END TRANSACTION? That may be the problem: views might not be able to be indexed during a transaction because of locking that goes on during the transaction. Try indexing the view outside of the transaction.


>Erik
>
>1)I am not sure I understand what you are saying. VFP will not accept:
>INDEX ON orderno
>I tried using tags:
>INDEX ON orderno tag inorder
>but still got the error on Begin Transaction. Is this what you meant?
>So I still have not figured it out -- besides coding around all the transactions.
>
>
>2) Actually, I am doing more in my Begin and End Transactions. I don't know why I put that code in here.
>
>Thanks,
>Jill