Modify command table

Hello

I try to change command sql by whis way:

IDatabase database = reportClientDocument.getDatabaseController().getDatabase();

int command = database.getTables().findByAlias("Command");

ITable table = database.getTables().getTable(command);

if (table instanceof CommandTable) {

CommandTable commandTable = (CommandTable) table;

commandTable.setCommandText(commandTable.getCommandText() + " where pperid ='000000001'");

}

}

But nothing changed. What am I doing wrong?

Best regards

Edited by: punkers84 on Jun 16, 2011 4:51 PM