So, I’m writing some code to insert fields from a form into a VFP database. At first I had an error return stating that a field that is a Date field does not accept null values.
I then tried to force a value into the field thinking that would take care of the problem, but now I’m receiving a data type mismatched error.
The best I can guess is that since VBScript doesn’t use Data Types the date field isn’t be recognized as a date data type.
So my question is how do I insert a date data type into a VFP database using an ODBC connection? Also Numeric values will probably come in handy as well.
Any help is greatly appreciated.
