It's much simpler with SPT parameters

cStr = "Insert Into PrtMst(ItmCod,ItmDes,Qty,GrpNo) Values " + ;
 		"(?cItmCod, ?cItmDes, ?nQty, ?nGrpNo)"
cSqlDb.Execute(cStr)

>
>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