Compobj and .null. - Level Extreme

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Compobj and .null.

Message

20/02/2007 14:00:28

Borislav Borissov
Microcomplex
Sofia, Bulgarie

20/02/2007 13:56:04

Zakaria Al Azhar
Actuaris.Net
Tétouan, Morocco

Information générale

Forum:

Visual FoxPro

Catégorie:

Codage, syntaxe et commandes

Titre:

Re: Compobj and .null.

Versions des environnements

Visual FoxPro:

VFP 5

Divers

Thread ID:

01197380

Message ID:

01197393

Vues:

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.

Répondre

Fil

Voir

Click here to load this message in the networking platform