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.

0 total posts (Page 1 of 1)  
Thread display: Collapse - | Expand +

All Answers

Share your knowledge
Back to Software Forum
0 total posts (Page 1 of 1)  

Related Discussions

Related Forums