Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Serious BUG: VFP doesn't respect the index's FOR
Message
De
17/04/2005 12:54:14
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9
Divers
Thread ID:
01005504
Message ID:
01005600
Vues:
25
Hi Sergey,
SET NULL OFF
CREATE CURSOR testDefault (f1 i NULL DEFAULT NULL)
INSERT INTO testDefault VALUES (NULL)
INDEX ON F1 FOR NOT ISNULL(F1) TAG T1 CANDIDATE
* #1 - the following BLANK doesn't fail even w/o DEFAULT clause
* !!! Sergey we do a error here, the index filter the rows and blank do none at eof
BLANK 		&& DEFAULT
* #2 - ignore the error
GO 1
BLANK 		&& DEFAULT
* #3 - ignore the error
UPDATE testDefault SET F1 = F1

* #4 - Index is corrupted at this point - ignore the error
* it is not in corrupted state, but VFP compare and check the current key with the old key
REPLACE RECORD 1 f1 WITH 1

* #5  Error on the BROWSE command : Index does not accept NULL. - ignore the error
* This occur because into a BROWSE with a FILTERED active index, 
* VFP evaluate the key FOR index cyclical ( it is correlate with the REPROCESS task )
BROWSE LAST NOWAIT

* #6 - deactivate the index, and you can look the table
SET ORDER TO
BROWSE LAST NOWAIT
RETURN
Thanks for refocus my attention here!
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform