Subject | May be a bug in Firebird 2 |
---|---|
Author | Marco Castroo |
Post date | 2006-05-06T14:25:46Z |
Hello,
Can you explain why this query (that runs in FB1.5) is not running?
Insert Into NotasSaida (NotaSaida, Transportadora, Cliente, Filial,
Usuario, Serie, Tipo_Nota, Numero, DataEmissao, Transporte,
Quantidade, Especie, Peso, Desconto, Responsavel, Ultimo_Acesso,
Observacoes, CodOperacao, IRPJ, Vendedor, StatusFrete, Status,
DataAcerto, Gerar_Encomenda, Pedido, Caixa, Cancelada, ISS_Fonte,
Documento_Colecao, Box, Cancelada) Values (947657, NULL, 1491, 1,
18, 'U', 1, 317951, '05/06/2006 11:07:37', 0, 1.00, '', 0.00,
0.00, '', '05/06/2006 11:07:37', '', 1, 0.00, 1, 0, 0, '12/30/1899
00:00:00', 0, '', 0, 0, 0.00, 0, Null, 0)
The error message is:
Column does not belong to referenced table.
Dynamic SQL Error.
SQL error code = -206.
unknown ISC error 336397210.
unknown ISC error 336397208.
There is not trigger tied to this table.
If I query a select with the same table and columns, the query
works.
Thanks,
Marco Castro
Can you explain why this query (that runs in FB1.5) is not running?
Insert Into NotasSaida (NotaSaida, Transportadora, Cliente, Filial,
Usuario, Serie, Tipo_Nota, Numero, DataEmissao, Transporte,
Quantidade, Especie, Peso, Desconto, Responsavel, Ultimo_Acesso,
Observacoes, CodOperacao, IRPJ, Vendedor, StatusFrete, Status,
DataAcerto, Gerar_Encomenda, Pedido, Caixa, Cancelada, ISS_Fonte,
Documento_Colecao, Box, Cancelada) Values (947657, NULL, 1491, 1,
18, 'U', 1, 317951, '05/06/2006 11:07:37', 0, 1.00, '', 0.00,
0.00, '', '05/06/2006 11:07:37', '', 1, 0.00, 1, 0, 0, '12/30/1899
00:00:00', 0, '', 0, 0, 0.00, 0, Null, 0)
The error message is:
Column does not belong to referenced table.
Dynamic SQL Error.
SQL error code = -206.
unknown ISC error 336397210.
unknown ISC error 336397208.
There is not trigger tied to this table.
If I query a select with the same table and columns, the query
works.
Thanks,
Marco Castro