SQL Query not working

[Bob Sneidar]

OK So I just determined that I'm a moron. It's not revDBExecute it's revDB_Execute. DOH!

Bob S

> On Jan 5, 2018, at 11:04 , Bob Sneidar via use-livecode <use-livecode at lists.runrev.com> wrote:
> 
> Hi all. 
> 
> I know I'm missing something here, but this query works in an SQL editor, but does NOT work with revDBExecute():
> 
> create table "arraydata"
> ("recordid" NUMERIC PRIMARY KEY NOT NULL UNIQUE,
> "rect" VARCHAR,
> "controlname" VARCHAR,
> "owner" VARCHAR,
> "visible" VARCHAR)
> 
> put revOpenDatabase("sqlite", "MEMORY") into tDBID -- verified tDBID returns a number
> put revDBExecute(tDBID, tCreateCommand) into tResult -- verified tCreateCommand is EXACTLY what worked in SQL Editor
> 
> The error I get in a try/catch construct is 
> 219,1198,14,revDBExecute
> 
> 465,1198,14
> 
> No very descriptive. 
> 
> Any ideas?
> 
> 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