Alan, it's blob to blob. The table is the same. I getting from one row
and inserting in another row (modifying pk, of course). And I forgot
I'm using FB 1.5 RC3.
Below the table and the insert statement:

create table releases (
releaseID objectID not null,
fileID objectID not null,
releaseOut boolean not null,
releaseOutTime timestamp,
releaseInTime timestamp,
taskID objectID,
developerID objectID,
releaseNum smallint default 1 not null check (releaseNum

> 0),

releaseAge timestamp not null,
releaseCrc integer,
releaseDescription text not null,
releaseSource binary not null,
constraint releasesPK primary key (releaseID)
);

...
insert into releases
select
:newReleaseID, :newFileID, 0, null, current_timestamp, null, null, 1,
releaseAge, releaseCrc, releaseDescription, releaseSource
from
releases
where
releaseID = :releaseID;


Alan McDonald wrote:

>sounds like you're trying to insert a blob into a stringfield? or vice
>versa? if so - can't be done without UDF.
>If it's blob to blob then it should work
>Alan
>
>
>
>>-----Original Message-----
>>From: Marcos Vinicius Dufloth [mailto:marvin@...]
>>Sent: Friday, 4 July 2003 10:58 PM
>>To: firebird-support@yahoogroups.com
>>Subject: [firebird-support] BLOBs and Triggers
>>
>>
>>Hi. I need insert some blob columns into a table inside a trigger. I
>>trying insert directly (by insert into ... select ... from ...) but I'm
>>get the error: 'conversion error from string "BLOB"'. How I can, inside
>>a trigger, select rows with BLOB columns and insert into another
>>row/table, without using UDFs?
>>
>>Regards,
>>--
>>
>>*__________________________________________________________________*
>>*Marcos Vinicius Dufloth*
>>*ICQ#: 128291190
>>
>>Tecnocyber, Ltda
>>Erechim - RS - Brasil
>>*
>>
>>*+* *Outras formas de contato * <http://wwp.icq.com/128291190>
>>*__________________________________________________________________*
>>
>>
>>
>>[Non-text portions of this message have been removed]
>>
>>
>>
>>To unsubscribe from this group, send an email to:
>>firebird-support-unsubscribe@yahoogroups.com
>>
>>
>>
>>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>>
>>
>>
>>
>
>
>
>
>To unsubscribe from this group, send an email to:
>firebird-support-unsubscribe@yahoogroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
>
>

--

*__________________________________________________________________*
*Marcos Vinicius Dufloth*
*ICQ#: 128291190

Tecnocyber, Ltda
Erechim - RS - Brasil
*

*+* *Outras formas de contato * <http://wwp.icq.com/128291190>
*__________________________________________________________________*



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