"Usharani" <usha@...> wrote in message
news:3C632D46.40801@......

> Hai All
>
> when i executae the following query i am getting an error saying that
>
> Sting truncation,numeric overflow .can any body tell me why i will get
> this error in this situation. there is no null values in the columns.
>
>
> SELECT
> a.commodityid
> FROM
> jccommodity a
> LEFT JOIN test b on (a.commodityid=b.commodityid)
> GROUP BY
> a.commodityid
>
> test in the above query is the view the definition is
>
> CREATE VIEW test
> as
> SELECT commodityid from jcspec
> GROUP BY
> commodityid

Why? Because it's a bug. But the case cannot be reproduced if you don't post
the table definitions, at least the columns that are used. The simpler the
case, the better.

C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase® WebRing