Re: How to treat the SET type field?

------=_Part_19735_36524801.1393219752997
Content-Type: text/plain; charset=ISO-2022-JP
Content-Transfer-Encoding: 7bit



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=MyISAM DEFAULT CHARSET=utf8 COMMENT='test table'

AUTO_INCREMENT=6 ;

INSERT INTO `test` (`no`, `type`) VALUES
(1, 'three'),
(2, 'two'),
(3, 'three'),
(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.


test.JPG



------=_Part_19735_36524801.1393219752997
Content-Type: text/plain; charset=us-ascii


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