Re: SQL Query not working

2018-01-05 Thread Dr. Hawkins via use-livecode
On Fri, Jan 5, 2018 at 11:04 AM, Bob Sneidar via use-livecode < use-livecode@lists.runrev.com> wrote: > > put revOpenDatabase("sqlite", "MEMORY") into tDBID -- verified tDBID > returns a number > > I think you need ":MEMORY:" rather than "MEMORY" -- Dr. Richard E. Hawkins, Esq. (702) 508-8462 _

Re: SQL Query not working

2018-01-05 Thread Bob Sneidar via use-livecode
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 > wrote: > > Hi all. > > I know I'm missing something here, but this query works in an SQL editor, but > does NOT work with revDBExecute(

SQL Query not working

2018-01-05 Thread Bob Sneidar via use-livecode
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("sql