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