Subject Re: [IBO] Re: TIBOQuery param AsFloat strange behaviour
Author Carlos H. Cantu
Post date 2018-06-21T19:22:48Z
Re: [IBO] Re: TIBOQuery param AsFloat strange behaviour Understood.

Anyway, seems that I was wrong with my previous test. The problem only happens if value is set to zero, and only in the first execution (following executions works fine, even with zero value).

[]s
Carlos H. Cantu
eBook Guia de Migração para o FB 3 - www.firebase.com.br/guiafb3.php
www.FireBase.com.br - www.firebirdnews.org - blog.firebase.com.br


Hi Carlos,

Actually replacing the components solves but as we are doing a legacy system migration, there are several places tied to TIBOQuery we would have to replace and redo the tests systematically by the same as it is used for DML is also used connected to the TDB components. Apart from this problem, so far we have not found any other errors to be reviewed in relation to the IBO.

As it is a version error we have decided that we will wait for Jason to release an old version for us as soon as it returns. Unfortunately the download site only allows to download the latest compiled version.

Thank you very much.


2018-06-21 13:49 GMT-04:00 listas@... [IBObjects] <IBObjects@yahoogroups.com>:

  
I did some tests and it seems that IBO is sending the old parameter's buffer value to Firebird.

For example, if I set the parameter to zero, at the first execution, IBO is sending null.
If before the second execution I set the parameter to 1, IBO is sending "0" (the previous value), and so on...

This is a bug for sure, but I don't think IBOQuery is the right component to run DML statements. For that, IB_DSQL should be used (and it doesn't have this bug)..

Carlos
www.firebirdnews.org
www.firebase.com.br



--
Whanderson S. Rodrigues
Engenheiro de Software / M.e em Agronegócio - UFGD
Softgran Informática Ltda.
Fone: (67) 3427-2040