I can solve this with a Cast(FieldBlob as Varchar(xxxx)), but there is some
other way??? I have a lot of Views in that situation…

Tanks for help…



Jean



_____

De: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] Em nome de Dmitry Yemanov
Enviada em: sábado, 2 de fevereiro de 2008 21:10
Para: firebird-support@yahoogroups.com
Assunto: Re: [firebird-support] Firebird 2.1 RC1



Jean Derrie Rigo wrote:

>
> I have a VIEW with UNION statement and on the SELECT's
> statements exists a BLOB field. In the last versions works fine, but on

this

> new RC1, I just get the message:
>
> Unsuccessful execution caused by system error that does not preclude
> successful execution of subsequent statements.
>
> Datatype BLOB is not supported for sorting operation.

This will be fixed in RC2.

> I don't have any ORDER BY, GROUP BY on the SELECT's.

UNION DISTINCT implies sorting.

Dmitry





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