General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only