Stuck on native database functions

[Mark Smith]

Currently I have this working

(Content of tSQL :)
INSERT into TABLE1 ("complete", "todo", "itemDate", "category", "purgeDate", "dgOrder") values(:1, :2, :3, :4, :5, :6)


revExecuteSQL gConnectID, tSQL, "ptheRowA[complete]", "ptheRowA[todo]", "ptheRowA[itemDate]", "ptheRowA[category]", "ptheRowA[purgeDate]", "ptheRowA[dgOrder]”

I am not passing the entire array because there are some array elements that I am not saving. If I did want to save/insert the whole array then I would write something like:

revExecuteSQL gConnectID, tSQL, “ptheRowA”

Hope that helps,
Mark



> On Jul 7, 2021, at 12:06 AM, Bob Sneidar via use-livecode <use-livecode at lists.runrev.com> wrote:
> 
> Hi all. 
> 
> I assemble an SQL statement that looks like this: 
> 
> insert into ObjectProperties (recordid,rect,controlname,owner,visible) VALUES (:1,:2,:3,:4,:5)
> 
> I then execute this statement: 
> 
> revExecuteSQL tDBID, tInsertSQL, aRecordData
> 
> I get records but with no data in them. I checked aRecordData and it has all 5 columns as keys and data in each of them. 
> 
> I am at a complete loss. I was sure this was working before, now it is not. 
> 
> Bob S
> 
> 
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode