Stuck on native database functions

[Devin Asay]

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 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:
> http://lists.runrev.com/mailman/listinfo/use-livecode

Devin Asay
Director
Office of Digital Humanities
Brigham Young University