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/
>
>