General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Peter,
Expand your constants in the SELECT statement to be the "width" you need them to be. That would be the "0.00" and the "0.0000". I'm not sure why it works now with values up to 9999.99.
Good luck,
JimN
>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
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