Error message indicates the view must have optimistic buffering. Do you have CursorSetProp('buffering',3) or CursorSetProp('buffering',5)?

Best Wishes
>>>>>>>>>>>>>>>>> your message below
I am bringing in a large remote view from Oracle. Once I get it, I need to manipulate it a lot and want to index it.

CursorSetProp('buffering',1)
Makes VFP6/SP4 say "Views require either DB_BUFOPTROW or DB_BUFOPTTABLE"

OK. So then I try to make/take the view offline with
? CreateOffline('universal_vw','d:\wintemp\universal_vw')
And I can see a .dbf and .tbf. But I get the same error if I try to index it after that.

How to index a remote view?