Subject | How Resolve 902 Error |
---|---|
Author | Mourad Hedfi |
Post date | 2012-09-07T07:58:38Z |
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]
" 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]