Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
BUG: SEEK Finds Old Data and mistakes recno()
Message
De
19/05/2003 06:58:29
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
BUG: SEEK Finds Old Data and mistakes recno()
Divers
Thread ID:
00789923
Message ID:
00789923
Vues:
54
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
Fil
Voir

Click here to load this message in the networking platform