General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Thanks. I needed to set the view to optimistic row buffering (3) and do the index and then set it back to table buffering (5).
I always use table buffering, so it didn't occur to me that I'd have to use row buffering. So I guess there is a use for row buffering. :)
>Views are alwasy optimistically buffered, either RECORD or TABLE. You need record buffering to index:
>
>CURSORSETPROP("BUFFERING", DB_BUFOPTRECORD) && 3
>
>will work.
>
>When working with remote views, I generally:
>
>USE rv_RemoteView NODATA
>INDEX ON Whatever TAG Whatever
>
>CURSORSETPROP("BUFFERING", 5)
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only