DatabaseColumnValues return undefined value

Hi, I am trying to read data from sqlite using jscript, however DatabaseColumnValues function seems return undefined values, since there is no jscript example on DatabaseColumnValues, I am hoping someone can point me in the right direction.

Below is my code

function load()
{
DatabaseOpen(db, dbFilename, 6);
DatabasePrepare (db, "select * from rooms");
var names = DatabaseColumnNames (db);
var cols = DatabaseColumns (db);

Note("Columns = " + cols);
Note (DatabaseError(db));
var rc = DatabaseStep(db) ;
Note (DatabaseError(db));
while (rc == 100)
{
Note ("begin");
var values = DatabaseColumnValues(db);
for(var i = 0; i < cols; i++)
{
Note(names+"="+values);
}

var rc = DatabaseStep (db) ;
}

DatabaseFinalize (db);
DatabaseClose(db);
}

here is the result

Columns = 7
not an error
row ready
begin

undefined=undefined
undefined=undefined
undefined=undefined
undefined=undefined
undefined=undefined
undefined=undefined
undefined=undefined
begin

undefined=undefined
undefined=undefined
undefined=undefined
undefined=undefined
undefined=undefined
undefined=undefined
undefined=undefined
begin

undefined=undefined
undefined=undefined
undefined=undefined
undefined=undefined
undefined=undefined
undefined=undefined
undefined=undefined
begin

undefined=undefined
undefined=undefined
undefined=undefined
undefined=undefined
undefined=undefined
undefined=undefined
undefined=undefined
begin

undefined=undefined
undefined=undefined
undefined=undefined
undefined=undefined
undefined=undefined
undefined=undefined
undefined=undefined
begin

undefined=undefined
undefined=undefined
undefined=undefined
undefined=undefined
undefined=undefined
undefined=undefined
undefined=undefined


the row number and column number all match the database, but the values are always undefined.