List:MySQL ODBC« Previous MessageNext Message »
From:hirobon Date:February 24 2014 5:29am
Subject:Re: How to treat the SET type field?
View as plain text  

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


Thread
How to treat the SET type field?重 博光23 Feb 2014
  • RE: How to treat the SET type field?John Bonnett24 Feb 2014
RE: How to treat the SET type field?John Bonnett24 Feb 2014
  • Re: How to treat the SET type field?重 博光25 Feb 2014
    • RE: How to treat the SET type field?John Bonnett25 Feb 2014
Re: How to treat the SET type field?hirobon24 Feb 2014