Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

SQL error code = -206 [CORE4197] #4522

Open
firebird-automations opened this issue Aug 29, 2013 · 3 comments
Open

SQL error code = -206 [CORE4197] #4522

firebird-automations opened this issue Aug 29, 2013 · 3 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Márson de Paula (marsonluis)

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?

@firebird-automations
Copy link
Collaborator Author

Modified by: Márson de Paula (marsonluis)

description: 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)

Any idea?

=>

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?

@firebird-automations
Copy link
Collaborator Author

Commented by: @dyemanov

Please don't post support questions to the tracker, use the appropriate mailing list instead.

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

priority: Critical [ 2 ] => Major [ 3 ]

security: Developers [ 10012 ] =>

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant