I dont know if this request is already been made but I would like to have the option to select the value by columnname instead of column index.
For example now it is
- Code: Select all
var vSQL = databaseManager.getDataSetByQuery('server', 'SELECT * FROM table', null, -1);
// Lets loop trough the result set
for(i = 1; i < vSQL.getMaxRowIndex(); i++)
{
variable = vSQL.getValue(1,i);
}
But this is not usable because the order of the index could change or be different on any SQL installation. But you dont want to select the column manually if you need them all when you have about 80 columns or what.
So what I would like to see is
- Code: Select all
var vSQL = databaseManager.getDataSetByQuery('server', 'SELECT * FROM table', null, -1);
// Lets loop trough the result set
for(i = 1; i < vSQL.getMaxRowIndex(); i++)
{
variable = vSQL.getValue('pk',i);
}