Hi,
you must elaborate your code and find point where blob is converted to
varchar or numeric.
Probably in group by.
Also using blob (or varchar) in group by is a mistake and degrading
perfomance too much :(
For first, please compute invoice and after this fetch blob data like this:

SELECT FIRST 1 data1, data2 .... FROM table WHERE ...

Also try to simplify your test case, this will help us to read your code.

Slavek


-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of zzotnik
Sent: Tuesday, April 01, 2008 7:21 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Re: Overflow occured during datatype conversion.
Conversion error from string "BLOB"



Dear Slavek,

I'll try your suggestion.

But why do I have to convert the blob to varchar? Can't stored
procedures return blob data type variables?

Thanks!



__._,_.__
.

<http://geo.yahoo.com/serv?s=97359714/grpId=2442406/grpspId=1705115386/msgId
=93285/stime=1207074074/nc1=3848641/nc2=4025321/nc3=4836036>




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