Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Compobj and .null.
Message
From
20/02/2007 14:25:54
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 5
Miscellaneous
Thread ID:
01197380
Message ID:
01197401
Views:
19
I am using a scatter name oFields and compobj to compare the tables, but I get a .F. if the fields contain .null. while they are identical. Can I resolve this?

As Boris pointed out, you can use NVL() to resolve this.

The reason this happens is that you can think of .NULL. as meaning "I don't know". So if you ask VFP:

Is "I don't know" equal to "I don't know", what would you expect the anser to be?

I would ezpect it to be "I don't know"
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform