Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Null values in cursor
Message
 
 
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:
01220070
Views:
33
This message has been marked as the solution to the initial question of the thread.
Try
  ... IIF(.T., myfunc(OtherField), NULL) 
>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.
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform