Information générale
Titre:
BUG: SEEK Finds Old Data and mistakes recno()
Hi
SET NEAR OFF
SET MULTILOCKS ON
CREATE CURSOR customer (cust_id c(20))
INSERT INTO (ALIAS()) VALUES ('AAAAA')
INSERT INTO (ALIAS()) VALUES ('BBBBB')
INSERT INTO (ALIAS()) VALUES ('CCCCC')
INDEX ON cust_id TAG IXcust_id
=CURSORSETPROP('Buffering',5)
* =CURSORSETPROP('Buffering',4) && also have bug
TABLEUPDATE(.T.)
? SEEK('AAAAA'),RECNO(),cust_id
REPLACE cust_id WITH '11111'
? SEEK('AAAAA'),RECNO(),cust_id
We can see that it finds the value old and firm on the successive record.
I uses many, many table buffering cursors.
It put me on much evil state, I need revision any index uses, explicit or implict ( rushmore OPTIMIZATION: SELECT,REPLACE,CALCULATE,LOOKUP,.... all!).
Fabio
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement