It also seems to do the escaping for you as it handled text containing commas in the description
All the best Terry > On 7 Jul 2021, at 16:40, Terence Heaford via use-livecode > <[email protected]> wrote: > > The routine I have working is > > put "uniqueID,date,type,description,amount,balance,category" into tFields > > put merge("INSERT INTO [[tAccountName]] ([[tFields]]) > VALUES(:1,:2,:3,:4,:5,:6,:7)") into tSQL > > revExecuteSQL dbGetID(), tSQL, "tValues[uniqueID]", "tValues[date]", > "tValues[type]", "tValues[description]", "tValues[amount]", > "tValues[balance]","tValues[category]" > > put the result into tErr > > return tErr > > > It resolves the error I was getting relating to autoincrement. _______________________________________________ use-livecode mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
