Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Indexing on a remove view created by a cursor adapter
Message
 
 
À
16/06/2005 09:53:41
Information générale
Forum:
Visual FoxPro
Catégorie:
Programmation Orientée Object
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
MS SQL Server
Divers
Thread ID:
01023934
Message ID:
01023957
Vues:
13
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform