I converted one table from Paradox to Mysql with 532.458 registers. After
that I try converted more 473.493, but i recept this error:
Key Violation.
[MyODBC][ODBC 3.51 Driver]
[mysqld-3.23.39-max-nt] Sort Aborted
My table:
Create table FichaFin
FinID MEDIUMINT NOT NULL AUTO_INCREMENT,
FinFunc INTEGER NOT NULL,
FinFilial INTEGER NOT NULL,
FinMesRef INTEGER NOT NULL,
FinProcesso INTEGER NOT NULL,
FinGrpCalc INTEGER NOT NULL,
FinCalcSeq INTEGER NOT NULL,
FinVerCodigo INTEGER NOT NULL,
FinVerTipo CHAR(1),
FinVerEsp INTEGER,
FinHistorico VARCHAR(40),
FinQtd DECIMAL(10,5),
FinValor DECIMAL(12,2),
FinFator DECIMAL(10,5),
FinUnidade CHAR(5),
FinGrpIR INTEGER,
FinGrpSS INTEGER,
FinGrpFGTS INTEGER,
FinCredData DATETIME,
FinMesCal INTEGER,
FinSalINSS CHAR(1),
FinFGTS CHAR(1),
FinIRRF INTEGER,
FinRAIS CHAR(1),
FinAAS INTEGER,
FinOrdem INTEGER,
FinCCH CHAR(1),
FinIRCod INTEGER,
FinFerias INTEGER,
FinFunNum INTEGER,
FinDepCod INTEGER,
FinAgreg INTEGER,
FinTStamp DATETIME,
FinCStamp INTEGER
, CONSTRAINT FichaFin_pk PRIMARY KEY (FinID)
) type= INNODB;
What's wrong?
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
