Bob, 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: revExecuteSQL “aRecordData” Not tested, but I’m pretty sure if you sort these things it will start to work for you. - Devin > On Jul 6, 2021, at 5:06 PM, 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 Devin Asay Director Office of Digital Humanities Brigham Young University _______________________________________________ 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
