Solved

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

Posted on 2008-10-15
2
818 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
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

Active Directory Webinar

We all know we need to protect and secure our privileges, but where to start? Join Experts Exchange and ManageEngine on Tuesday, April 11, 2017 10:00 AM PDT to learn how to track and secure privileged users in Active Directory.

Question has a verified solution.

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

PL/SQL can be a very powerful tool for working directly with database tables. Being able to loop will allow you to perform more complex operations, but can be a little tricky to write correctly. This article will provide examples of basic loops alon…
Composite queries are used to retrieve the results from joining multiple queries after applying any filters. UNION, INTERSECT, MINUS, and UNION ALL are some of the operators used to get certain desired results.​
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

821 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