DBtreeview and Datasets

Classic Servoy
1

Hello,
Is it possible to use the treeview bean and bind it to a dataset rather than physical foundset ?

2

Not as far as I know.

3

Hi Phil,

I understand you don’t want to use a foundset of any form?
I think you have 2 options then.

First of all you can create a foundset based on a table on the fly. No need to use a foundset of any form.

var fs = databaseManager.getFoundSet('myServer', 'myTable');
fs.loadRecords("SELECT id FROM myTable WHERE myColumn=?, [myVariable]);

If I am not mistaken this will give you a ‘separate’ foundset. So one that is not linked to any other foundset using the same table.

Another option would be when you use 4.1 where you CAN use a dataset as datasource for a form.
See viewtopic.php?f=1&t=11
After loading this you can use this forms foundset for your DBTreeView bean.

Hope this helps.