Stuck on native database functions

[Terence Heaford]

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 <use-livecode at lists.runrev.com> 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.