Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Temporary index in buffer mode
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Titre:
Temporary index in buffer mode
Versions des environnements
Visual FoxPro:
VFP 6 SP3
OS:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
00957281
Message ID:
00957281
Vues:
48
Hi, I Got a problem creating a sample TEMPORARY index
The index key is based on user entry so this is why I create a temp. index

See code below!

LOCAL X AS Session

USE C:\SOMETABLE SHARED
SET ORDER TO 1
CURSORSETPROP("Buffering",4)
? CURSORGETPROP("Buffering",4) &&--> 4 OK

X=CREATEOBJECT("SESSION") && TO SIMULATE A FORM (PROBLEME AS WELL WITH A FORM)
SET DATASESSION TO X.DataSessionID

USE C:\SOMETABLE SHARED AGAIN
? CURSORGETPROP("Buffering") && --> 1 OK


INDEX ON SOMEFIELD TO C:\TEMPIDX.IDX
--> ERROR : Command cannot be issud on a table with cursors in table
buffering mode

This is ok when buffering mode 4 or 5 but why in the second datasession
Why that doesn't work ?
Any work arrond (other than remove the buffering temporary in the first datasession) ?


Thank for your help

Luc St-Pierre
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform