SQL Query not working

Bob Sneidar bobsneidar at iotecdigital.com
Fri Jan 5 14:04:44 EST 2018


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



More information about the use-livecode mailing list