Get columns from a foundset

Classic Servoy
1

Hello,

I would like to iterate through the fields of a foundset to set them in a single for clause from another object. But I don’t find for the foundset some methods like:

foundset.getColumns()

or

foundset.getColumnNameAt(index); foundset.getColumnCount()

Anyone know how to do this? Except creating a dataset and get the columns from there! I would like to avoid this.

Thanks,
Bogdan.

2

Hi ,

var _table = databaseManager.getTable(foundset.getDataSource())
_table.getColumnNames()
_table.getColumn(name)

Regards,

3

Thanks,

Do you have any idea if extra requests are made to the server to get that table information?

Regards,
Bogdan.

4

No, if the result is correct and in time I don’t care and I don’t want to know…

That is the essence of layered programming (don’t care / look into lower (Servoy, javascript, java) levels)…

Regards,

5

table information is cached on the client, so those calls are not round trips.