Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Manipulating data with objects
Message
 
 
To
21/07/2000 16:02:52
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00395398
Message ID:
00395701
Views:
10
Ah. You have to set buffering to row to create or delete an index tag. Then you can turn table buffering back on. So many little traps, tricks....

>>>I prefer table buffering [5],...
>>>
>
>I'm trying to use your suggestion an implement table buffering, but when I set =CURSORSETPROP("Buffering", 5, "intrancust"), I get "Command cannot be issued on a table with cursors in table buffering mode (Error 1579). If I leave out "INDEX ON stocknum TAG stocknum" it tells me "table has no index order set". What did I miss?
>
>BeforeOpenTables Event:
>SET TALK OFF
>SET DELETED ON
>SET PATH TO ('C:\DiamondAcct\Data\')
>OPEN DATABASE Tomparco SHARED
>SET EXCLUSIVE OFF
>SET MULTILOCKS ON
>SET DATABASE TO Tomparco
>
>Load Event:
>SET EXCLUSIVE OFF
>DBSETPROP('intrancust', 'view', 'Tables', 'Tomparco!inventory')
>DBSETPROP('intrancust', 'view', 'SendUpdates',.T.)
>=CURSORSETPROP("Buffering", 5, "intrancust")
>INDEX ON stocknum TAG stocknum
Mark McCasland
Midlothian, TX USA
Previous
Reply
Map
View

Click here to load this message in the networking platform