Hi Jason,
Strange I changed the Collate of pt_br to pt_pt and worked !

Alexandre

From: IBO Support List
Sent: Wednesday, June 05, 2013 7:11 PM
To: IBObjects@yahoogroups.com
Subject: RE: [IBO] Insert error in TIBOQuery


What is the size of your column in the table?
What is it's character set?

This error is coming from the server itself so there is something it doesn't
like about the data you are sending it.

It could also be due to something that happens due to a trigger firing and
causing an exception you may not be immediately aware of how or why.

Jason
www.ibobjects.com

-----Original Message-----
From: mailto:IBObjects%40yahoogroups.com [mailto:mailto:IBObjects%40yahoogroups.com] On Behalf
Of Alexandre
Sent: Wednesday, June 5, 2013 3:29 PM
To: mailto:IBObjects%40yahoogroups.com
Subject: [IBO] Insert error in TIBOQuery

Hi Guys,

I am trying to insert a record into my database with TIBOQuery, but the
following error is occurring:

ISC ERROR MESSAGE
conversion error from string "test"
STATEMENT:
<no name>.<no name>(TIB_UpdateDSQL)
STATEMENT:
tb_times.IBOqrtb_times(TIBOInternalDataset)

My code is:

data_module.tb_times.Insert;
data_module.tb_timesTIMES_NOMEDOTIME.Value:=edit1.Text;
data_module.tb_times.Post;

Some idea ?

Thanks
Alexandre

[Non-text portions of this message have been removed]

------------------------------------

__________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
__________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !
Yahoo! Groups Links




Nenhum vírus encontrado nessa mensagem.
Verificado por AVG - www.avgbrasil.com.br
Versão: 2013.0.2904 / Banco de dados de vírus: 3184/6389 - Data de Lançamento: 06/06/13


[Non-text portions of this message have been removed]