Booleans not converted per Version History

General usage of Access to MySQL

Moderator: jr

Booleans not converted per Version History

Postby iamko » Fri Feb 25, 2011 7:39 am

The version history says:

2.0.0.56 (2007-05-10)
* Boolean fields are represented as 0 and -1. This is a change from 0 and 1.

However, the boolean TRUEs were converted to 1, not -1, and Access doesn't recognize 1 as True. Is there some kind of setting or something that can fix this? This will have to be run against multiple versions of the database, making it hard to maintain with SQL statements to correct.

Here are the pertinent details:

BullZip version: 3.0.0.148 (latest)
Windows XP SP2
Access 2000 (yes, it's a legacy program)
MySQL ODBC 5.1 Driver
MySQL Server (Win32) Version 5.1.37
iamko
 
Posts: 1
Joined: Fri Feb 25, 2011 7:21 am

Re: Booleans not converted per Version History

Postby jr » Fri Mar 20, 2015 7:55 pm

Hi

I think this is fixed now :-)

/Jacob
jr
Site Admin
 
Posts: 491
Joined: Sun Mar 26, 2006 12:28 pm


Return to General

Who is online

Users browsing this forum: No registered users and 5 guests

cron