Issue Details (XML | Word | Printable)

Key: CORE-4197
Type: Bug Bug
Status: Open Open
Priority: Major Major
Assignee: Unassigned
Reporter: Márson de Paula
Votes: 0
Watchers: 1
Operations

If you were logged in you would be able to see more operations.
Firebird Core

SQL error code = -206

Created: 29/Aug/13 02:48 PM   Updated: 29/Aug/13 04:29 PM
Component/s: ISQL
Affects Version/s: 2.5.1
Fix Version/s: None

Environment: Windows 7, IBExpert


 Description  « Hide
I'm trying to insert a record but the error occurs:

can't format message 13:794 -- message file C:\Windows\firebird.msg not found.
Dynamic SQL Error.
SQL error code = -206.
Column unknown.
VCST.
At line 1, column 108.

to this SQL:

insert into MOVESTOQUE (CDLOJA, CDPOS, CDPRODUTO, CDHISTORICO, FLGMOVIMENTO, QUANTIDADE, DATA, HORA, QTDEANTERIOR,
                        QTDEATUAL, NRDOCUMENTO, VLRCUSTOCIMP, CDFORNCLI, LJFORNECEDOR, VLRCUSTMEDCIMP, VLRCUSTMEDCONT,
                        VLRCONTABIL, VLRSUGERIDO, SEQUENCIA)
values (77, 9, 8994, 15, 'E', -1, '28.08.2013', '15:09:00', -3,- 3, 'VCST',1.1449996948, 0, 0, 7.8600001335144,
        7.61999988555908, 8.18000030517578, 12.2700004577637, 3)

And, this the table's DDL:

/******************************************************************************/
/*** Following SET SQL DIALECT is just for the Database Comparer ***/
/******************************************************************************/
SET SQL DIALECT 3;



/******************************************************************************/
/*** Tables ***/
/******************************************************************************/


CREATE GENERATOR GEN_MOVESTOQUE;

CREATE TABLE MOVESTOQUE (
    CDPOS INTEGER NOT NULL,
    CDMOVIMENTO INTEGER NOT NULL,
    CDLOJA INTEGER NOT NULL,
    CDPRODUTO INTEGER,
    CDHISTORICO INTEGER DEFAULT 0,
    DATA TIMESTAMP,
    HORA VARCHAR(8),
    QUANTIDADE FLOAT DEFAULT 0,
    FLGMOVIMENTO VARCHAR(1),
    QTDEANTERIOR FLOAT,
    QTDEATUAL FLOAT,
    CDFORNCLI CODIGO /* CODIGO = INTEGER */,
    NRDOCUMENTO VARCHAR(20),
    VLRCUSTOCIMP VALOR /* VALOR = DECIMAL(18,2) */,
    VLRCUSTMEDCIMP VALOR /* VALOR = DECIMAL(18,2) */,
    LJFORNECEDOR CODIGO /* CODIGO = INTEGER */,
    VLRCUSTMEDUNIT VALOR /* VALOR = DECIMAL(18,2) */,
    VLRCUSTMEDCONT VALOR /* VALOR = DECIMAL(18,2) */,
    FLGESTORNADO FLAG /* FLAG = VARCHAR(1) */,
    VLRCONTABIL VALOR /* VALOR = DECIMAL(18,2) */,
    VLRSUGERIDO VALOR /* VALOR = DECIMAL(18,2) */,
    FLGALTERADO FLAG /* FLAG = VARCHAR(1) */,
    FLGSIST FLAG /* FLAG = VARCHAR(1) */,
    MD5 VARCHAR(40),
    SEQUENCIA CODIGO /* CODIGO = INTEGER */
);




/******************************************************************************/
/*** Primary Keys ***/
/******************************************************************************/

ALTER TABLE MOVESTOQUE ADD PRIMARY KEY (CDMOVIMENTO, CDPOS, CDLOJA);


/******************************************************************************/
/*** Foreign Keys ***/
/******************************************************************************/

ALTER TABLE MOVESTOQUE ADD FOREIGN KEY (CDPRODUTO) REFERENCES PRODUTOS (CDPRODUTO);
ALTER TABLE MOVESTOQUE ADD FOREIGN KEY (CDPOS, CDLOJA) REFERENCES POS (CDPOS, CDLOJA);
ALTER TABLE MOVESTOQUE ADD FOREIGN KEY (CDHISTORICO) REFERENCES HISTORICOS (CDHISTORICO);


/******************************************************************************/
/*** Indices ***/
/******************************************************************************/

CREATE INDEX XIE1MOVESTOQUE ON MOVESTOQUE (CDLOJA);
CREATE INDEX XIE2MOVESTOQUE ON MOVESTOQUE (DATA);
CREATE INDEX XIE3MOVESTOQUE ON MOVESTOQUE (FLGMOVIMENTO);
CREATE INDEX XIE4MOVESTOQUE ON MOVESTOQUE (CDPRODUTO);
CREATE INDEX XIE5MOVESTOQUE ON MOVESTOQUE (NRDOCUMENTO);
CREATE INDEX XIE6MOVESTOQUE ON MOVESTOQUE (CDFORNCLI);
CREATE INDEX XIE7MOVESTOQUE ON MOVESTOQUE (CDHISTORICO);
CREATE INDEX XIE8MOVESTOQUE ON MOVESTOQUE (CDMOVIMENTO);
CREATE INDEX XIE9MOVESTOQUE ON MOVESTOQUE (CDFORNCLI, LJFORNECEDOR);
CREATE INDEX XIF90MOVESTOQUE ON MOVESTOQUE (CDPOS, CDLOJA);
CREATE INDEX XIF91MOVESTOQUE ON MOVESTOQUE (CDPRODUTO);

Any idea?

 All   Comments   Change History   Subversion Commits      Sort Order: Descending order - Click to sort in ascending order
Dmitry Yemanov added a comment - 29/Aug/13 04:29 PM
Please don't post support questions to the tracker, use the appropriate mailing list instead.