>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.