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@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@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
_______________________________________________
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
