|
Replies:
2
-
Pages:
1
-
Last Post:
Jul 25, 2011 10:21 AM
by: Mauritz
|
|
|
Posts:
5
Registered:
6/1/10
|
|
|
|
Disable checkbox for tinyint!!!... !
Posted:
Nov 22, 2010 1:41 AM
|
|
|
So the checkbox has always been sketchy in Toad for MySQL. Previously it would show up for bit(1) now, it no longer shows up for bit(1), but instead shows up for tinyint(1) I don't know about anyone else but I use tinyint(1) for 0-9 settings, and bit(1) for boolean's.
Quest should include an option to disable the checkbox all together since for years? it has not worked properly.
Couple versions back the original problem I had with it was I couldn't update a row when there was a checkbox bit(1) on the table. Thats since been fixed, I used to have to do manual SQL just to update a value in a row.
The problems that I know currently exist are
#1 It shouldn't be on tinyint(1) unless its turned on for tinyint(1), some people will use this for 0-9
#2 When you export to SQL, it exports the tinyint(1) or bit(1) as 'Checked' or 'Unchecked', this is not valid SQL for updating the fields properly. You should be using NULL, 0, or 1
To reproduce, create a table that has tinyint(1), add a couple rows setting that column, then select all rows in the grid, hit control-c as sql, paste in editor... says checked/unchecked instead of 1/0
#3 There should be an option to turn this on/off for bit(1)
|
|
|
Posts:
1
Registered:
7/25/11
|
|
|
|
Re: Disable checkbox for tinyint!!!... !
Posted:
Jul 25, 2011 8:39 AM
in response to: x21_921
|
|
|
Hello,
I agree with you.
This option should be added because it's not efficient to "replace" a numeric value by an alphanumeric one !!!
Sincerly
|
|
|
Posts:
314
Registered:
8/23/07
|
|
|
|
Re: Disable checkbox for tinyint!!!... !
Posted:
Jul 25, 2011 10:21 AM
in response to: getdaone_625
|
|
|
I just tested this in the Toad for MySQL 6.0 beta and it works fine (The data stays numeric).
|
|
|
|
Legend
|
|
Guru: 2001
+
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
