System.db.refresh not working in template instance?


I have a Power Table where I use the onCellEdited Extension Function to add editing capability to the table. The Extension Function looks like this:

[code]id =, self.updateTableIdName)

query = “UPDATE [%s] SET [%s] = ? WHERE [%s] = ?” % (self.updateTableName, colName, self.updateTableIdName)

args = [newValue, id]

system.db.runPrepUpdate(query, args)

system.db.refresh(self, “data”)

updateTableIdName and updateTableName are custom properties on the power table.

I’ve then created a template using this Power Table. The template has 3 template parameters:

  1. Data {DataSet}
  2. updateTableIdName {String}
  3. updateTableName {String}

I then bind the Power Table’s (in the template) Data, updateTableIdName updateTableName to the template parameters I just mentioned.

Edits get written to the database in both the non templated and templated Power Tables. However, only the non templated Power Table is refreshed.

Thanks in advance,


Got some help from Paolo at tech support.

Changing “system.db.refresh(self, “data”)” to “system.db.refresh(self.parent.parent, “data”)” did the trick.