In the section attributes there is an attribute "Automatically relate".
If this is unchecked then you can requery() the Virtual Table in the "ParentDataChanged" delegate.
Code:
ca = cursorAdaptor("the_alias_of_your_virtual_table")
ca.requery("amount > 0 and customer='{customers.name}'")
Lianja.getElementByID("id_of_your_grid").refresh()
Notice how i reference the parent section data using the {customers.name} macro which will be expanded in requery().
After requerying the MySQL data you then refresh() the grid by accessing it using Lianja.getElementByID().
Once your grid is refreshed, Lianja will then cascade the sections relationships down the page.
Now after telling you all that, unfortunately the "Automatically relate" attribute was disabled in RC8 but it is available in the latest RC9 build. Assuming you are on Windows we can make this available to you. If you are on linux you will need to wait for it.
Bookmarks