Hello everyone, I'm using Firebird 1.5. My table DDL is
" CREATE TABLE IPOJ_INFOPOSO_JOURNALIERE (
    IPOJ_FPO_CODE_FK_PK       INTEGER NOT NULL,
    IPOJ_NUM_SEQ_PK           SMALLINT NOT NULL,
    IPOJ_CDF_NAPO_CODE_FK     VARCHAR(10),
    IPOJ_NUM_ORD              SMALLINT,
    IPOJ_SP_CODE_FK_PK        INTEGER NOT NULL,
    IPOJ_SP_CIPUCD            VARCHAR(7) NOT NULL,
    IPOJ_DJMIN                NUMERIC(15,5),
    IPOJ_DJMAX                NUMERIC(15,5),
    IPOJ_DTMIN                NUMERIC(15,5),
    IPOJ_DTMAX                NUMERIC(15,5),
    IPOJ_NATUCD_CDF_CODE_FK   VARCHAR(10),
    IPOJ_NATUCD_CDF_NUM_FK    CHAR(2),
    IPOJ_DONANTH_CDF_CODE_FK  VARCHAR(10)
);

ALTER TABLE IPOJ_INFOPOSO_JOURNALIERE ADD CONSTRAINT
PK_IPOJ_INFOPOSO_JOURNALIERE PRIMARY KEY (IPOJ_FPO_CODE_FK_PK,
IPOJ_NUM_SEQ_PK, IPOJ_SP_CODE_FK_PK, IPOJ_SP_CIPUCD); "

When I'm executing the following query insert
into  IPOJ_INFOPOSO_JOURNALIERE values
(534,1,'01',1,914,'9123827',0.00000,1.00000,0.00000,0.00000,7,04,''), I
always have this error :
"Unsuccessful execution caused by a system error that precludes
successful execution of subsequent statements.
I/O error for file "D:\VALIDATION\DBFBFB\Database.FDB".
Error while trying to read from file.
Fin de fichier atteinte."

It seems to be a 902 error, I've readed the firebird documentation and I
don't know how to resolve it.

Can anyone tell me what I must to do ?

Many thank in advance for your precious help.
Best regards.


[Non-text portions of this message have been removed]

Reply via email to