Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
BUG!: Changed join treatment behaviour from Vfp6 to Vfp8
Message
De
30/01/2006 14:24:13
 
 
À
30/01/2006 04:16:28
Emanuele Bonin
EB Soluzioni Informatiche
Tezze S/B, Italie
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP
Network:
Windows 2003 Server
Database:
Visual FoxPro
Divers
Thread ID:
01091336
Message ID:
01091593
Vues:
15
Hi Emanuele,

It appears NULL propagation isn't working for Double type in this scenario. The error can be avoided by checking for NULL value explicitly:
Select * From T1 Left Join T2 On T1.Id = T2.ID ;
Where (T2.Q IS NOT NULL) AND T1.Q + T2.Q > 0
Thanks,
Aleksey.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform