Seems my sql statement has a little error, but it does not change the
error. The statement groups by remarks but does not include remarks
in the return list. Even when remarks is in the return list however
the error is the same.

I also noted that this was kinda stupid to group by remarks sense
they'll all be different. I changed the 'sum(hours)' to just 'hours'
and removed the group by entirly. It works fine that way.

Appears group by blob may be the problem??

-Andy

--- In ib-support@y..., "andycolson" <andycolson@y...> wrote:
> I just changed a varchar to a blob, now this sql statement gives
the
> error: "Overflow occured during data type conversion. conversion
> error from string "BLOB"
>
> select customers.organization as cust, jobs.descr as jd,
tasks.descr
> as td,
> sum(times.hours) as hours, customers.cid as cid, idate as pdate
> from times
> join jobs on (times.jobid=jobs.jobid)
> join tasks on (times.taskid = tasks.taskid)
> join customers on (times.custid = customers.custid)
> where times.empid = 8
> group by idate, customers.organization, customers.cid, jobs.descr,
> tasks.descr, remarks
> order by customers.organization, idate
>
>
> Tables:
> CREATE TABLE TIMES (
> EMPID INTEGER NOT NULL,
> IDATE DATE NOT NULL,
> JOBID INTEGER NOT NULL,
> TASKID INTEGER NOT NULL,
> HOURS NUMERIC (9, 2),
> CUSTID INTEGER NOT NULL,
> REMARKS BLOB sub_type 1 segment size 80);
>
>
> Remarks used to be a varchar 500, but I switched to blob. I'm
> running Firebird 1 RC2 (Version is LI-T6.2.681 Firebird RC 2)
>
> I backuped the database and restored it on an IB6.0 server and the
> query seemed to work ok.
>
> Is this a problem with my sql or perhaps a firebird bug?