Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Indexing a table buffered view
Message
 
 
To
01/11/1999 19:53:03
Jill Derickson
Software Specialties
Saipan, CNMI
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00285192
Message ID:
00285445
Views:
15
>I've been using row buffering and often create indexes on my views, (so I can display the records in an "ordered" grid and allow the user to choose the order).
>
>I just switched to table buffering and now the INDEX ON UPPER( cName) TAG Name fails w/:
>
>Command cannot be issued on a table with cursors in table buffering mode.
>
>Is there a way around this?
>
>TIA, J

CursorSetProp("buffering", 3, "myview") && switch to optimistic row buffering
Index on ... tag ...
CursorSetProp("buffering", 5, "myview") && switch back to opt table buffering
Mark McCasland
Midlothian, TX USA
Previous
Reply
Map
View

Click here to load this message in the networking platform