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

Reply via email to