Stuck on native database functions
devin_asay at byu.edu
Tue Jul 6 19:14:51 EDT 2021
A couple of things: You should either be passing variable names, not variable contents, so put your variable names in quotes.
revExecuteSQL “tDBID", “tInsertSQL", “tControlName”, etc
OR you should be passing the name of an array variable, whose keys are numeric:
Not tested, but I’m pretty sure if you sort these things it will start to work for you.
> On Jul 6, 2021, at 5:06 PM, 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:
Office of Digital Humanities
Brigham Young University
More information about the use-livecode