Advanced SQL Generation Options disabled
Posted: Fri 22 Feb 2008 16:09
I'm using v40 of the driver and attempting to get INSERT, UPDATE, and DELETE statements auto generated. When I click to view the Advanced SQL Generation Options disabled they are disabled. This happens on multiple tables.
The table has a primary key, so that's not the problem. I've recreated the MySqlDataSource object multiple times with the same results.
Suggestions?
The table has a primary key, so that's not the problem. I've recreated the MySqlDataSource object multiple times with the same results.
Suggestions?
Code: Select all
-- Table: test_tbl
-- DROP TABLE IF EXISTS `test_tbl`;
CREATE TABLE `test_tbl` (
`script_id` int AUTO_INCREMENT NOT NULL,
`my_id` varchar(8),
`name` varchar(20),
`task_order` int(10) UNSIGNED ZEROFILL NOT NULL DEFAULT '0000000000',
`sql` text,
/* Keys */
PRIMARY KEY (`script_id`)
) ENGINE = MyISAM;