• 0
Sign in to follow this  
mr.jango

Sql Error Code = -206

Question

Amigos, preciso um help dos conhecedores de firebird.

sou iniciante em FIREBIRD.

Criei um banco de dados ASTRO.GDB e no banco contem um tabela chamada fornecedor. Porem quando faço um consulta simples (select * from fornecedor) na tabela ele me retorna as informações, mas quanto a coisa cmeça a ficar complexa (select cd_for, nm_for from fornecedor order by cd_for;) ele me retorna o erro abaixo:

Column does not belong to referenced table.

Dynamic SQL Error.

SQL error code = -206.

Column unknown.

CD_FOT.

At line 1, column 35.

ouvir falar num tal de COLLATE PT_BR, beixei, mas não sei como instalar.

Atenciosamente,

João

Share this post


Link to post
Share on other sites

1 answer to this question

Recommended Posts

  • 0
Column does not belong to referenced table.

Dynamic SQL Error.

SQL error code = -206.

Column unknown.

CD_FOT.

At line 1, column 35.

Esse erro com Código -206 quase sempre é erro de sintaxe...

Não seria um erro na sintaxe? olha só... CD_FOR por CD_FOT?

Edited by paulo_linux

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this