Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Null values in cursor
Message
From
26/04/2007 08:37:45
 
 
To
26/04/2007 08:23:19
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 6 SP5
Miscellaneous
Thread ID:
01220061
Message ID:
01220074
Views:
20
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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform