I have an VB frontend that can't be changed for various reasons, and have
been attempting to move the database (access) out to MySQL (for various
other reasons ;). I haven't been able to successfully read True/False
fields, and after much research it appears that I need to map any true/false
or yes/no to 1/0 in the MyODBC source code.
I've downloaded the source code, but I haven't been able to determine what
and how to change the mapping. Any assistance would be GREATLY appreciated!
FYI: I tried treating the MySQL side as an enum field, but the VB front end
won't accept the result.
Thanks in advance,
David McKay
da********@mckaygroup.com