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