Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
SQL7 money fields and nulls problem
I have a money field on a SQL7 table that is flagged to accept nulls. If i initialize a VFP textbox that's bound to the corresponding money field to NULL, and try to save the record (by calling an INSERT or UPDATE stored procedure), SQL gives the error:
"Implicit conversion from data type character to money is not allowed."
If i initialize the bound item to $0, SQL does NOT complain.
moneyfield = .null. ==> wont save
moneyfield = $0 ==> will save
Again, the field in SQL allows nulls.
Other (non-money) fields in the sql table accept nulls and there is no problem when saving records where these field values are nulls.
any ideas?
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