Stuck on native database functions
marksmithhfx at gmail.com
Wed Jul 7 06:29:46 EDT 2021
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,
> 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:
More information about the use-livecode