Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Null values in cursor
Message
De
26/04/2007 08:37:45
 
 
À
26/04/2007 08:23:19
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 6 SP5
Divers
Thread ID:
01220061
Message ID:
01220074
Vues:
24
Try
SELECT SomeField, CAST (MyFunc (OtherField) AS N (10, 2)) AS CalculatedValue;
   FROM MyTable;
   INTO CURSOR Temp
HTH

>In a query similar to:
>
>
>select SomeField, MyFunc(OtherField) as CalculatedValue;
>  from MyTable;
>  into cursor Temp
>
>
>it may happen that MyFunc() returns .NULL. for some cases. If this happens, VFP informs me that the column doesn't accept NULL values.
>
>How do I make VFP allow null values? Of course, I could use NVL(...), but I do want NULL values in some cases, in order to know that there is some missing data.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform