lcSQLStatement='INSERT INTO tasklist (department,detail) ' + ;
'VALUES (CHR(34) + thisform.txtDept.Value + CHR(34)+ ',' + CHR(34) + thisform.edtDetail.value + CHR(34) + ')' && Detail is a memo field.
SPT command not support CHR(0),CHR(13),... characters.
You have to use the VFP parameter expressions.
lcSQLStatement="INSERT INTO tasklist (department,detail);
VALUES(?thisform.txtDept.Value,?thisform.edtDetail.value)"