?SQLEXEC(HandelSQL,"CREATE TABLE SETUP (KEY_NAME CHAR(20) DEFAULT '' NOT NULL,VALUE DOUBLE(8,0) DEFAULT 0 NOT NULL, KEY 'KEY_NAME' ('KEY_NAME'))") 

[MySQL][ODBC  3 . 51  Driver][mysqld- 5 . 0 . 24 -community]You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version for the right syntax to use near ''KEY_NAME' ('KEY_NAME'))' at line  1 

?SQLEXEC(HandelSQL,"CREATE TABLE SETUP (KEY_NAME CHAR(20) DEFAULT '' NOT NULL,VALUE DOUBLE(8,0) DEFAULT 0 NOT NULL)")
?SQLEXEC(HandelSQL,"CREATE TABLE t1 (C CHAR(10) DEFAULT '' NOT NULL,IDENT MEDIUMTEXT DEFAULT '' NOT NULL, KEY `C` (`C`))")

CREATE TABLE `setup` (
  `KEY_NAME` char( 20 ) NOT NULL default '',
  `VALUE` double( 8 , 0 ) NOT NULL default '0',
  KEY `KEY_NAME` (`KEY_NAME`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;