Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Implicit tableupdate when buffering change
Message
De
11/10/2003 04:49:19
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Implicit tableupdate when buffering change
Divers
Thread ID:
00837793
Message ID:
00837793
Vues:
63
Hi,

implicit tableupdate is one potential source of errors.
CLEAR
SET MULTILOCKS ON
CREATE CURSOR myCursor (id i)
CURSORSETPROP("Buffering",3)
INSERT INTO myCursor VALUES (1)
CURSORSETPROP("Buffering",5)
* fire implicit TABLEUPDATE() ( bug for me )
* TableBuffering extended RecordBuffering
* then correct operation is not update the record buffer
* and preserve the buffer data ( i known the problem with buffered index but ... )
* if is too hard to implemement, fire a error
? TABLEREVERT()
CURSORSETPROP("Buffering",3)
INSERT INTO myCursor VALUES (2)
INDEX ON id TAG tid		&& <---- fire implict TABLEUPDATE()
? TABLEREVERT()
INSERT INTO myCursor VALUES (3)
? KEYMATCH(2)			&& <---- fire implicit TABLEUPDATE()
* ( bad for me, but MS documented it)
? TABLEREVERT()
INSERT INTO myCursor VALUES (4)
? INDEXSEEK(3)			&& none implicit TABLEUPDATE()
? TABLEREVERT()
For me, con the record buffering active, it must only fire implicit tableupdate when it is attempted to abandon the record in explicit way (SEEK, LOCATE, LOOKUP, GO...)

Fabio
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform