>>>... >>>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 + "'" + ; >>> ")" >>>>>
SET POINT TO ,I've seen it before, many people don't see the problems with the decimal point character used in other countries, which in VFP is determined by Set Point To and checked by Set('Point'). This is the best solution if mProperty is a string, as I see it:
cast(chrtran(mProperty ,',',set('Point')) as n(17,6))