>... >mproperty15 = ALLTRIM(STRTRAN(NTR_desc,"'","")) >... >LcInsert = "Insert into NominalTransaction(NominalBatchNum, NominalStage, NominalJournalNum, NominalTranType, NominalDate," + ; > "NominalPeriod, NominalPeriodFirst, NominalPeriodLast, NominalRelease, NominalCostCentreCode, " + ; > "NominalCode, NominalDaybook, NominalJournalRef, NominalValue, NominalJournalDesc, " + ; > "NominalDesc, NominalPeriodInput, NominalMode, NominalMemo01, NominalLink, " + ; > "InsertUser, UpdateUser" + ; > ")" + ; > " VALUES (" + mProperty01 + "," + mProperty02 + "," + mProperty03 + ",'" + mProperty04 + "','" + mProperty05 + "'," + ; > mProperty06 + "," + mProperty07 + "," + mProperty08 + "," + mProperty09 + ",'" + mProperty10 + "','" + ; > mProperty11 + "','" + mProperty12 + "','" + mProperty13 + "'," + mProperty14 + ",'" + mProperty15 + "','" + ; > mProperty16 + "'," + mProperty17 + "," + mProperty18 + ",'" + mProperty19 + "'," + mProperty20 + ",'" + ; > mnomuser + "','" + mnomuser + "'" + ; > ")" >Gregory provided you with the correct way of using parameters. One possible gotcha - check out the types of the parameters, quite often VFP sends them wrongly (say, float for numeric, etc.) In those cases you can use CAST to correct type inside the ?mproperty, e.g.