At 11:01 AM 04-09-01 +0200, Rainer Queck wrote:

>I have the following query:
>
>select cast (Aribbon_speed_m_min as numeric(9,2)) /* SPACE HERE */as Aribbon_speed_m_min,
>Anet_width_inch,
>Aribbon_text,
>Astart_of_ribbon,
>Aend_of_ribbon,
>Astart_of_ribbon_txt,
>Aend_of_ribbon_txt,
>Aperformance,
>cast (Asquare_meters_jobs as numeric (15,2)) as Asquare_meters_jobs,
>cast (Asquare_meters_float as numeric (15,2)) as Asquare_meters_float,
>cast (Asquare_foot_jobs as numeric (15,2)) as Asquare_foot_jobs,
>cast (Asquare_foot_float as numeric (15,2)) as Asquare_foot_float,
>cast (Ayield as numeric (9,2)) as Ayield,
>cast (Aribbon_weight_in_tons as numeric (15,2)) as Aribbon_weight_in_tons,
>cast (Aribbon_weight_in_sh_tons as numeric (15,2)) as
>Aribbon_weight_in_sh_tons,
>Atime4ribbon,
>Apercent_of_float_time,
>Apackers
>from select_ribbon_values
> order by Anet_width_inch DESCENDING

At first look (if you copy-pasted this) I can see just the error in the first line.

As it's neither a metadata query nor an update query, I fail to see why you got the message "Metadata update statement is not allowed by the current database SQL
dialect 3".

For another thing, it's not an engine error that I recognise. What tool were you using at the time? It seems like a tool bug to me.

Regards,
Helen



All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________