>If I make a remote view of a sql anywhere table and mark all the fields as updateable and make sure that the PK fields are marked and then try to make a date field a null value, VFP6.0 SP3 C5's on me immediately.
>
>I've gotten around it by not listing the date field in the list of fields that I am updating and allowing it to remain as is, but obviously this keeps me from being able to change a date from a value to .null.
>
>I've tried searching the KB articles about this, I still haven't found an answer.
>
>1. Could someone more knowledgable about searching KB try it for me and see if they can find something?
>2. Is anyone else using SQL Anywhere and have never heard of this problem, or maybe has dealt with the problem already?
>
>Thanks!
Hi Todd,
Did you mark your date field to accept NULL value in SQL Anywhere Database? From my experience with SQL Anywhere it works fine with nulls if the nulls are allowed. One other quirk is that if you send empty date it will default to 01/01/1900.
Nick
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison