Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
NULL DATES
Message
From
12/12/2000 17:53:04
 
 
To
12/12/2000 17:21:39
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00452593
Message ID:
00452608
Views:
22
>Is there a command that I have to send to the SQL server to accept NULLS?
>I have some null date fields so I do: NVL(myfield,NULL)
>It won’t let me do this. But if I INSERT from the query analyzer is fine.
>Any ideas?

The column has to be defined as allowing NULLs, so the column would have to be redefined.
What is the insert statement you used in the Q/A? How are you making this call from VFP?
By "won't let me do this" do you mean gives a "Column does not accept nulls" error? If not, what error do you get?
Insanity: Doing the same thing over and over and expecting different results.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform