Hi,
On the "CREATE TABLE" statement some mistake in syntax is not reported.
STATEMENT:
CUT-------------------------------------------------------------------------
----------------------------------------------------------------------------
---
CREATE TABLE prodconfirm(IDPC INT(16) AUTO_INCREMENT NOT NULL PRIMARY
KEY,mUser CHAR(16),PLANT VARCHAR(4),LINE VARCHAR(8),,MATERIAL
VARCHAR(10),SERIAL VARCHAR(10),PRODDATE DATETIME,CONFIRM TINYINT(1),TRANSFER
TINYINT(1),
CONF_DATE DATE,TRANSF_DATE DATE,INDEX
productconfirm(IDPC,mUser,PLANT,LINE,MATERIAL,SERIAL,PRODDATE,CONFIRM,TRANSF
ER,CONF_DATE,TRANSF_DATE));
CUT-------------------------------------------------------------------------
----------------------------------------------------------------------------
----
Between "VARCHAR(8)" and "MATERIAL" are double comma.This not generate an
error in syntax.
Regards,
Gelu
_____________________________________________________
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
