Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Serious BUG: VFP doesn't respect the index's FOR
Message
From
17/04/2005 12:54:14
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
Miscellaneous
Thread ID:
01005504
Message ID:
01005600
Views:
20
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!
Previous
Reply
Map
View

Click here to load this message in the networking platform