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