I have a table with a lot of columns that are completely empty, i'd like to exclude them, it's pretty easy when we talk about rows but here i really don't know, do you have an idea ?
You may create a for-loop over all fields of a table per nooffields() to get the fieldname() and within it an if-loop check per fieldvaluecount() if there is any content and if not to drop the field.
A better approach as the above may be not load the tables with a field-wildcard else to define the wanted ones explicitly.
You may create a for-loop over all fields of a table per nooffields() to get the fieldname() and within it an if-loop check per fieldvaluecount() if there is any content and if not to drop the field.
A better approach as the above may be not load the tables with a field-wildcard else to define the wanted ones explicitly.
