method executeSQL

This method executes a SQL query. The resulting record set, if any, is returned as an EETable object.

    
// get localStorage factory
var factory = shell.serviceManager.localStorage.factory;
if (factory)
{
    // create a database object
    var SQLDatabase = factory.createSQLDatabaseForIdentity("johndoe");
    if (SQLDatabase)
    {
        // invoke executeSQL method with a select SQL statement
        var table = SQLDatabase.executeSQL("select * from MAIL_DETAILS");
        if (table)
        {
            //Table object is valid, use object interfaces to access the elements
            var value = table.getValueAt(1,2);
        }
    }
}