cSql = "Insert into table(field1, fields2) values (" cSql = cSql + "'" + oRec.Field1 + "', " && Field 1 contains a string, needs single quotes cSql = cSql + STR(oRec.Field2,5,0) + ")" && Field 2 contains a number, but we are creating a string here SQLEXEC(iCH,cSql)