Subject May be a bug in Firebird 2
Author Marco Castroo
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