Visual FoxPro Insert Into & Date Data Types

By foetoid ·
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.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums