Insert/Update enum malfunction

[rrkramer]

Insert/Update, Ver 3.64, on a table with the following CREATE TABLE, produces a pull-down with three lines (NULL),, when attempting to modify the 'style' column:

CREATE TABLE catalog (

cust_id char(8) DEFAULT '' NOT NULL ,

cat_id char(8) DEFAULT '' NOT NULL ,

description char(30) DEFAULT '' NOT NULL ,

status tinyint(1) DEFAULT '0' NOT NULL ,

which_db char(8) DEFAULT '' NOT NULL ,

style enum('','company_store','imprints','forms','supplies') DEFAULT '' NOT NULL ,

sortby char(4) DEFAULT '' NOT NULL ,

file_attach enum('Y','N') DEFAULT 'N' NOT NULL ,

PRIMARY KEY (cust_id,cat_id)

);

It seems the problem is caused by the initial '' which is unnecessary, of course, but stilll …

I would test with the new beta, but can't find it. Is that generally available?

Richard

[CalEvans]

works fine with sqlyog 3.7 against MySQL 4.0.16

=C=

[rrkramer]

OK, this MySQL 4.23, but how do I get hold of 3.7?

[Shadow]

What is MySql 4.23? SQLyog 3.7 is still in beta, if you want to take part in testing it, then send an e-mail to Ritesh. (He is not available for the next 2 days, so be patient!)

[rrkramer]

>What is MySql 4.23?

The old off by 1.00? (3.23, in fact)

Thanks,

Richard

[Shadow]

I thought so! 😀

[Author]

Posts