RE: How to treat the SET type field?

Hi Hirobon,

I have never used those SET or ENUM type columns. It may be that Access doe=
s not support them since they are a little unusual and are a MySQL extensio=
n to the SQL standard.

I did a little searching in Google for "mysql odbc access enum type" and ca=
me to the conclusion that Access probably does not support these types of c=
olumns through ODBC.

________

Carl Zeiss Vision Australia (Asia Pacific)
Global Business Solutions/Customer Enablement
Software Engineer

J o h n  B o n n e t t

Phone: +61 (0) 8 8392 8307
Fax: +61 (0) 8 8392 8160
Mailto: [email protected]
www.zeiss.com/vision

This email, including any attachments, is intended for the sole use of the =
intended recipient(s) and may contain information that is confidential, pri=
vileged and/or the sender=1B$B!G=1B(Bs work.
Any review or distribution by any other person is prohibited. If you are no=
t an intended recipient, please immediately contact the sender and delete a=
ll copies.


-----Original Message-----
From: =1B$B=3DE!!Gn8w=1B(B [mailto:[email protected]]
Sent: Monday, 24 February 2014 3:24 PM
To: [email protected]; Bonnett, John
Subject: Re: How to treat the SET type field?

Hi, John!

As you mentioned, I didn't provide you enough information.

I will tell you what i tried to do and what i expected to happen.
I made a table as bellow.

CREATE TABLE IF NOT EXISTS `test` (
`no` int(11) NOT NULL AUTO_INCREMENT COMMENT 'No', `type` set('one','two','=
three','four') NOT NULL COMMENT 'type', PRIMARY KEY (`no`)
) ENGINE=3DMyISAM DEFAULT CHARSET=3Dutf8 COMMENT=3D'test table'

AUTO_INCREMENT=3D6 ;

INSERT INTO `test` (`no`, `type`) VALUES (1, 'three'), (2, 'two'), (3, 'thr=
ee'), (5, 'four');

And I made a screen with MS Access2013(See attached file).
I expected that i can put the type field as a checkbox.
But It didn't work. It worked like a toggle button.

Did I make a mistake??

Thank you for any help.

hirobon.


---------------
This message is intended for a particular addressee only and may contain bu=
siness or company secrets.
If you have received this email in error, please contact the sender and del=
ete the message immediately. Any use of this email, including saving, publi=
shing, copying, replication or forwarding of the message or the contents is=
 not permitted.

-- 
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/myodbc