Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Binary Index Weirdness
Message
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Title:
Binary Index Weirdness
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01005602
Message ID:
01005602
Views:
67
Hi all,

This seems like a bug to me, but maybe someone else can shed some light.

*--Create a cursor with 2 fields - one allows NULLs the other does not.
CREATE CURSOR c_Test (Int1 I NULL, int2 I)
INDEX ON ISNULL(int1) TAG BinTest1 BINARY &&-fails with "Invalid index expression for a Binary Index."
INDEX ON ISNULL(int2) TAG BinTest2 BINARY &&--Runs fine (it shouldn't)

The only difference between the two index statements is that the field Int1 allows binary information to be stored, whereas Int2 does not.

Thanks for any help.

-Matt
Next
Reply
Map
View

Click here to load this message in the networking platform