Solved

How to insert a null date into Paradox 5 date field.

Posted on 2008-10-15
2
824 Views
Last Modified: 2013-12-17
I have the task of importing data retrieved from a Paradox 5 table into another database with the exact table. Now the problem is with a Date field in this table is set to 00/00/0000 (its a delete date). The BDE has no problems creating this record with the host application but now the issue for me is that using C# with an OLEdbConnection and issuing queries such as INSERT INTO test VALUES(1,'FirstName,'LastName','00/00/0000') gives me a 'Type mismatch' error.
I do not want to list the field names in the query.

Is there any way to do this in a query?

Thanks in advance.

0
Comment
Question by:ExanSoftware
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 5

Accepted Solution

by:
PaulKeating earned 500 total points
ID: 22726050
INSERT INTO test VALUES(1,'FirstName,'LastName',NULL)
0
 

Author Closing Comment

by:ExanSoftware
ID: 31506503
Thanks, i had tried that but was not working for me until now. Paradox is very finicky. Nothing but a headache to be honest...
0

Featured Post

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For those of you who don't follow the news, or just happen to live under rocks, Microsoft Research released a beta SDK (http://www.microsoft.com/en-us/download/details.aspx?id=27876) for the Xbox 360 Kinect. If you don't know what a Kinect is (http:…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question