Information générale
Titre:
Data type mismatch err while updatting numeric field in Sql
Versions des environnements
Network:
Windows 2000 Server
Dear all
I m trying to insert a numeric and an integer value to the SQL Database
using SQL Execute Command all Charector type values are upadated properly
But, when it reach to numeric variable it shows an error that 'Data Type Mismatch Error'.
Then how will i insert numeric value in to the databse.
Sample code is given below
cItmCod = 'A1B1C1'
cItmDes = 'Mechine Part '
nQty = 100.000 (Numeric)
nGrpNo = 1 (Integer)
cSqlDb.BeginTrans()
cStr = "Insert Into PrtMst(ItmCod,ItmDes,Qty,GrpNo) Values
("+"'"+cItmCod+"',"+"'"+cItmDes +"',"+"'"+nQty +"','"+nGrpNo +"')"
cSqlDb.Execute(cStr)
cSqlDb.CommitTrans
Please help me anybody have a solution for it
Thanks and Regards
Abdulla
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