firebird-odbc-devel

[Firebird-odbc-devel] Conversion error from string run time error 2147467259

[Adriano <fad...@gm...>]

I've this update query
 query = "UPDATE Fatture SET IntestazioneFattura = '" &
TIntestazione.Text & "', Prestazione = '" & TPrestazione.Text & "',
Speseimponibili = '" & ValSpeseImponibili & "', " & _
 " Diritti = '" & ValDiritti & "', Onorari = '" & ValOnorari & "',
Spesegenerali = '" & ValSpeseGenerali & "', CPA = '" & ValCassaPrev &
"', TotaleImponibile = '" & ValTotaleImponibile & "', " & _
 " Iva = '" & ValIva & "', Spesenonimponibili = '" &
ValSpeseNonImponibili & "', TotaleFattura = '" & ValTotaleFattura &
"', Ritenutaacconto = '" & ValRitenutaAcconto & "', " & _
 " Totaledaversare = '" & ValTotaleVersare & "', Note = '" &
TNote.Text & "', Giorno = '" & Calendar.Day & "', Mese = '" &
Calendar.Month & "', Anno = '" & Calendar.Year & "', " & _
 " Trimestre = '" & Trimestre & "', Pagamento = '" & Pagato & "',
PraticaID = '" & txtFatturaPraticaID.Text & "' WHERE IdFattura = " +
record + ""

Some fields are BLOB field, other are integer value, other char, varchar.
The query pass correctly the data but when execute that i receive the
error in the subject

Any hints ?
Thanks
Adriano

Re: [Firebird-odbc-devel] Conversion error from string run time error 2147467259

[bill l. <cbi...@gm...>]

I think the problem is due to blob. The INSERT/UPDATE statements should be
pass-thru to firebird for execution. The reason why it failed should be a
problem of firebird engine but not odbc driver.

I don't know the proper syntax but you may post to [firebird-support] list and
asking how to insert/update blob fields using sql statement there.

BTW, ms access allows updating blob using the syntax you have given if I
remember correctly.

-- 
regards,
bill

Re: [Firebird-odbc-devel] Conversion error from string run time error 2147467259

[Adriano <fad...@gm...>]

Hi Bill,

>The reason why it failed should be a
> problem of firebird engine but not odbc driver.
The complete error message said
[odbc-firebird driver][firebird]conversion error from string

Thanks
Adriano

Re: [Firebird-odbc-devel] Conversion error from string run time error 2147467259

[bill l. <cbi...@gm...>]

Hi, Adriano:
>> The reason why it failed should be a
>> problem of firebird engine but not odbc driver.
> The complete error message said
> [odbc-firebird driver][firebird]conversion error from string

"conversion error from string": fbodbc does not contain this error message, but
you can find it inside firebird's "firebird.msg" file. So that the error did not
come from odbc driver itself.

use something like
  update t set blobimage=? where code='aaa'
and then supply the parameter when being asked.

I've not used VB for many years so I do not know the exact syntax, you may
specifically ask "how to update a blob using vb dao/ado?" in the
firebird-support list to see if anyone knows the exact syntax.

-- 
regards,
bill

Re: [Firebird-odbc-devel] Conversion error from string run time error2147467259

[Georgi V. <geo...@br...>]

Hi

I have had a similar problem with NUMERIC fields. I solved it with changing
the field to DOUBLE or FLOAT.

Regards,
Georgi

----- Original Message ----- 
From: "Adriano" <fad...@gm...>
To: <fir...@li...>
Sent: Wednesday, July 19, 2006 11:49 PM
Subject: [Firebird-odbc-devel] Conversion error from string run time
error2147467259


> I've this update query
>  query = "UPDATE Fatture SET IntestazioneFattura = '" &
> TIntestazione.Text & "', Prestazione = '" & TPrestazione.Text & "',
> Speseimponibili = '" & ValSpeseImponibili & "', " & _
>  " Diritti = '" & ValDiritti & "', Onorari = '" & ValOnorari & "',
> Spesegenerali = '" & ValSpeseGenerali & "', CPA = '" & ValCassaPrev &
> "', TotaleImponibile = '" & ValTotaleImponibile & "', " & _
>  " Iva = '" & ValIva & "', Spesenonimponibili = '" &
> ValSpeseNonImponibili & "', TotaleFattura = '" & ValTotaleFattura &
> "', Ritenutaacconto = '" & ValRitenutaAcconto & "', " & _
>  " Totaledaversare = '" & ValTotaleVersare & "', Note = '" &
> TNote.Text & "', Giorno = '" & Calendar.Day & "', Mese = '" &
> Calendar.Month & "', Anno = '" & Calendar.Year & "', " & _
>  " Trimestre = '" & Trimestre & "', Pagamento = '" & Pagato & "',
> PraticaID = '" & txtFatturaPraticaID.Text & "' WHERE IdFattura = " +
> record + ""
>
> Some fields are BLOB field, other are integer value, other char, varchar.
> The query pass correctly the data but when execute that i receive the
> error in the subject
>
> Any hints ?
> Thanks
> Adriano
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share
your
> opinions on IT & business topics through brief surveys -- and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Firebird-odbc-devel mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
>

Re: [Firebird-odbc-devel] Conversion error from string run time error

[Vladimir T. <pr...@hm...>]

Hi Adriano,

> Some fields are BLOB field, other are integer value, other char, varchar.
> The query pass correctly the data but when execute that i receive the
> error in the subject

    Please, send me ODBC trace log(zip)
    Probably I can specify issue.

--
Best regards,
Vladimir Tsvigun

Re: [Firebird-odbc-devel] Conversion error from string run time

[Vladimir T. <pr...@hm...>]

Hi Georgi,

> I have had a similar problem with NUMERIC fields. I solved it with
changing
> the field to DOUBLE or FLOAT.

  Please, send me ODBC trace log(zip)
  and sample small firebird database with table.
  and small App for example error.
  And no problem for fix issue :-)

PS:
  Yes. I know that there is issue. But I need an example.
--
Best regards,
Vladimir Tsvigun

Re: [Firebird-odbc-devel] Conversion error from string run time

[Georgi V. <geo...@br...>]

Hi Vladimir,
I will send information you require, but a little bit later because I'm very
busy now.

Best regards,
Georgi Varbanov

Re: [Firebird-odbc-devel] Conversion error from string run time

[Adriano <fad...@gm...>]

Hi Vladimir,
where is located the log file? i've searched on all my pc without find it.
thank you very much
best regards
adriano

Re: [Firebird-odbc-devel] Conversion error from string run time

[Vladimir T. <pr...@hm...>]

Hi Adriano,

> where is located the log file? i've searched on all my pc without find it.
> thank you very much

 1) Press "Start" -> "Control panel"
 2) run ODBC Administrator, select tab "Tracing" and press
     "Start Tracing Now" and select locate log file.
 3) run App.exe
>I've this update query  query = "UPDATE Fatture SET IntestazioneFattura =
'" &

 4) select ODBC Administrator, select tab "Tracing" and press
     "Stop Tracing Now".

 5) stop App.exe

--
Best regards,
Vladimir Tsvigun