Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Funny: When a equal can to be not equal
Message
From
09/04/2005 05:40:20
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Funny: When a equal can to be not equal
Environment versions
Visual FoxPro:
VFP 9
Miscellaneous
Thread ID:
01003001
Message ID:
01003001
Views:
72
CLEAR 


CREATE CURSOR EQUALORNOTEQUAL (AB C(10) NULL)
APPEND BLANK

SYS(3054,11)
Test()
INDEX ON DATETIME()		TAG T1
* OTHERS...
*INDEX ON DTOC(DATE())+AB	TAG T1
*INDEX ON SECONDS()		TAG T2

* WAIT CHANGE
DO WHILE KEYMATCH(DATETIME())
*DO WHILE KEYMATCH(SECONDS())
	DOEVENTS
ENDDO
TEST()

SYS(3054,0)

PROCEDURE test
SELECT * FROM EQUALORNOTEQUAL WHERE DATETIME()=DATETIME() INTO ARRAY RANDOM
*SELECT * FROM BYBYBUG WHERE SECONDS()=SECONDS() INTO ARRAY RANDOM
?? _tally
Comment: don't uses not deterministic values into a index key, VFP don't check this condition.
Next
Reply
Map
View

Click here to load this message in the networking platform