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
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
