MySQL Forums
Forum List  »  Microsoft Access

Importing Boolean values from Access
Posted by: Mike Anderson
Date: February 07, 2011 11:10AM

I'm converting Access tables to MySQL and using Access as the front-end. When -1 is imported, MySQL turns it into a 1. Using Access as the front-end, whenever a checkbox is checked, Access enters a -1 into the MySQL database.
My question is what is the best way to handle this problem?
I could search/replace all the imported 1's to -1 and that way I wouldn't have to change all the queries which use -1's as criteria.
It's a big job as I'm dealing with hundreds of tables and thousands of fields, so I'm just looking for the most efficient way of handling the problem.

Options: ReplyQuote

Written By
Importing Boolean values from Access
February 07, 2011 11:10AM
February 08, 2011 05:58AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.