Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select (SQL) -- field does not accept NULL values
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00692839
Message ID:
00693040
Views:
15
Armin,

Thanks for your replies. I plan to use a NVL() type command in the sql*select statement to avoid this NULL problem. But I really need to know why this is a "bug"? Selecting fields that have a NULL in them works fine, it is only when a variable (ora command) that results in a NULL does the problem exist like in :
select proper(Table1.Name) as NewName from table1 into cursor temp
My question is why does this cause an error???


Kevin
Kevin Emmrich
www.jkt9000.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform