|
Replies:
0
-
Pages:
1
|
|
|
Posts:
20
Registered:
2/16/10
|
|
|
|
Quick export to Excel 2003 dropping int fields randomly
Posted:
Jul 25, 2011 5:56 PM
|
|
|
Hi,
I'm using the Toad 6 beta (6.0.0.1454) and have just discovered that the quick export to Excel 2003 is dropping integer fields randomly - depending on the table, some integer fields appear but others don't.
Create the table below and select all rows in the data grid view. Do a quick export to an Excel instance. On my system, the smallint field simply does not appear in the output. This was working fine in the latest Toad 5.
Thanks,
Linda
--------------------------------
CREATE TABLE `test` (
`course` char(10) COLLATE latin1_general_ci NOT NULL,
`course_vers_num` smallint(6) unsigned NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
insert into `test`(`course`,`course_vers_num`) values ('ADN02',1);
insert into `test`(`course`,`course_vers_num`) values ('ADSEDS',1);
insert into `test`(`course`,`course_vers_num`) values ('BACLBS',1);
insert into `test`(`course`,`course_vers_num`) values ('BCLBS',1);
insert into `test`(`course`,`course_vers_num`) values ('BECOL',1);
|
|
|
|
Legend
|
|
Guru: 2001
+
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
