Stuck on native database functions

Devin Asay devin_asay at
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:

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 at> 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
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:

Devin Asay
Office of Digital Humanities
Brigham Young University

More information about the use-livecode mailing list