Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement