Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Manipulating data with objects
Message
From
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:
00395679
Views:
10
>>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform