Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Implicit tableupdate when buffering change
Message
From
11/10/2003 04:49:19
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Implicit tableupdate when buffering change
Miscellaneous
Thread ID:
00837793
Message ID:
00837793
Views:
61
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
Next
Reply
Map
View

Click here to load this message in the networking platform