Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Indexing on a remove view created by a cursor adapter
Message
 
 
To
16/06/2005 09:53:41
General information
Forum:
Visual FoxPro
Category:
Object Oriented Programming
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01023934
Message ID:
01023957
Views:
11
All you have to do is set the cursor to RowBuffering, create the indexes, then set the buffering back to what it was.
local lnOldBuffering
lnOldbuffering = cursorgetprop('buffering', cursorname)
if cursorsetprop('buffering', 3, cursorname)
   * do indexing here
   cursorsetprop('buffering', lnOldBuffering, cursorname)
endif
>Ok, I think my topic explains what I need. All our data is stored in SQL Server. We use Cursor Adapters to create a READ ONLY cursor for a disply to the user so they can select what entry to maintain. We want to be able to INDEX on that cursor. However, we are running into a road block in that a cursor created by a cursor adapter is always buffered, which we don't want it to be. Is there any way to allow us to use the cursor adapter's cursor and index on that?
>
>Any help would be greatly appreciated.
>
>Thanks
Mark McCasland
Midlothian, TX USA
Previous
Reply
Map
View

Click here to load this message in the networking platform