SQL Query not working
bobsneidar at iotecdigital.com
Fri Jan 5 14:04:44 EST 2018
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,
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
No very descriptive.
More information about the use-livecode