Compobj and .null. - Level Extreme

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Compobj and .null.

Message

From

20/02/2007 14:00:28

Borislav Borissov
Microcomplex
Sofia, Bulgaria

20/02/2007 13:56:04

Zakaria Al Azhar
Actuaris.Net
Tétouan, Morocco

General information

Forum:

Visual FoxPro

Category:

Coding, syntax & commands

Title:

Re: Compobj and .null.

Environment versions

Visual FoxPro:

VFP 5

Miscellaneous

Thread ID:

01197380

Message ID:

01197393

Views:

Yes, NULL can't be compared. NULL is just "Don't know" If you want to compare NULLs use NVL() function:

? NVL(oLeft.FieldWithNull,0)  == NVL(oRight.FieldWithNull,0)  && If FieldWithNull is some of the numeric fields
? NVL(oLeft.FieldWithNull,[]) == NVL(oRight.FieldWithNull,[]) && If FieldWithNull is char
? NVL(oLeft.FieldWithNull,{}) == NVL(oRight.FieldWithNull,{}) && If FieldWithNull is date

Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.

Map

View

Click here to load this message in the networking platform