>I created a view similar as this one:
>
>CREATE VIEW AS ;
>SELECT Tipo_acoes.nome, Tipo_acoes.cod_tipo, Tipo_acoes.especie, ;
> C_v_acoes.data, C_v_acoes.quantidade, C_v_acoes.preco_unit, ;
> 0.00 AS Total, 0.0000 AS Price_Now ;
> FROM data1!c_v_acoes LEFT OUTER JOIN data1!tipo_acoes ;
> ON C_v_acoes.cod_acao = Tipo_acoes.codigo
>
>PROBLEM:
>If I want to change/insert a value in an field like Total or Price_Now
>in the view with values grater than 9999.99 it allway returns this message: "numeric owerflow, data was lost. "
>
>I must insert values greater than 99,999,999.99.
>
>Why this happens and how can I solve this problem ?
>
>TIA

Just put the appropriate number of 0's in front of your definitions such as 00000000.00.

Dan