azeotrope

Hi, for some reason I simply cannot get Tim Places' js implementation of Sqlite working in Max7 32 for Windows. Seems to work fine using Max5 for Windows, but not for Max7, it just throws an error. Its been a while since I've done any work in maxmsp so I'm guessing I'm missing something obvious.

/*
 * simpleDatabase.js
 * a simple wrapper around Max 5's JS support for SQLite databases.
 * by Tim Place
 * copyright © 2008, Cycling '74
 */

var sqlite = new SQLite;
var result = new SQLResult;


function opendb(x)
{
    sqlite.open(x,1); //open a file-based DB
}


function closedb()
{
    sqlite.close();
}


function exec(arg)
{
    // execute the SQL statement in arg, returning results in the 'result' object
    sqlite.exec(arg, result);

    // access information about the returned records by calling functions on the result object
    formatResultForCellblock();
}


function getversion()
{
    post("SQLite Version: " + sqlite.getversion() + "\n");
}


function formatResultForCellblock()
{
    var numfields = result.numfields();
    var numrecords = result.numrecords();
    var fieldnames = new Array(numfields);
    var values = new Array(numfields);

    outlet(0, "clear", "all");
    outlet(0, "cols", numfields);
    outlet(0, "rows", numrecords + 1);    // rows +1 so we can create a header row

    for(var i=0; i<numfields; i++)
        outlet(0, "set", i, 0, result.fieldname(i));

    for(var i=0; i<numrecords; i++){
        for(var j=0; j<numfields; j++)
            outlet(0, "set", j, i+1, result.value(j, i));
    }
}

Hi, for some reason I simply cannot get Tim Places' js implementation of Sqlite working in Max7 32 for Windows. Seems to work fine using Max5 for Windows, but not  for Max7, it just throws an error. Its been a while since I've done any work in maxmsp so I'm guessing I'm missing something obvious. 

/*
 * simpleDatabase.js
 * a simple wrapper around Max 5's JS support for SQLite databases.
 * by Tim Place
 * copyright © 2008, Cycling '74
 */

var sqlite = new SQLite;
var result = new SQLResult;


function opendb(x)
{
    sqlite.open(x,1); //open a file-based DB
}


function closedb()
{
	sqlite.close();
}


function exec(arg)
{
	// execute the SQL statement in arg, returning results in the 'result' object
	sqlite.exec(arg, result);

	// access information about the returned records by calling functions on the result object
	formatResultForCellblock();
}


function getversion()
{
	post("SQLite Version: " + sqlite.getversion() + "\n");
}


function formatResultForCellblock()
{
    var numfields = result.numfields();
    var numrecords = result.numrecords();
    var fieldnames = new Array(numfields);
    var values = new Array(numfields);

	outlet(0, "clear", "all");
	outlet(0, "cols", numfields);
	outlet(0, "rows", numrecords + 1);    // rows +1 so we can create a header row

	for(var i=0; i<numfields; i++)
		outlet(0, "set", i, 0, result.fieldname(i));

	for(var i=0; i<numrecords; i++){
		for(var j=0; j<numfields; j++)
			outlet(0, "set", j, i+1, result.value(j, i));
	}
}

Hi, for some reason I simply cannot get Tim Places' js implementation of Sqlite working in Max7 32 for Windows. Seems to work fine using Max

SQL in Max7 32 Windows 10