General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Joe,
If the field is NOT NULL you not be able to insert anything but a date.
Why can't you include a made up date in your INSERT?
>I am trying to write a SQL Insert query to Update a FoxPro table with values from our mainframe. I am having a problem Inserting an Empty date field to the Fox Table. I cannot Omit the field from the query because It will not Accept nulls. I have tried an empty string ie {d ' - - ') is also failing If a date value is filled in the above format it works.
>
>Does anyone out there know how I can enter a Blank date field from cobol to a foxtable via ODBC.
>
>Any help would be appreciated.
>
>Thank you in advance.
>
>Joe Hendren
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only