HomeActive Query BuilderHidden columns are incorrectly selected

Hidden columns are incorrectly selected


Hi there,

I have implemented code to hide certain columns from a table with the following code (The table contains 7 columns in total):

MetadataTable table = (MetadataTable) queryBuilder.getMetadataContainer().findObjectByFullName("Config_User");
MetadataFieldList fieldsList = table.getFields();
fieldsList.remove(fieldsList.get(fieldsList.findFieldByName("password")));
fieldsList.remove(fieldsList.get(fieldsList.findFieldByName("super_user")));

When I drag/drop the table on the design area and do not select any of the rest of the columns, the SQL query generated in the text area is as follows:

SELECT * FROM Config_User

Shouldn't the generated query be something like: 'SELECT col1, col2, col,..etc etc.. FROM Config_User' listing the rest of the columns since I removed the two columns above?

Is there something that can be done programatically to correct this 'feature' ?

Kind Regards
lafkiotis | email
November 1 2011, 07:35 PM
Hello,

By hiding columns you just hide them from being visible from user. You may check all fields in a table using the code from this article:
http://www.activedbsoft.com/helpdesk/index.php?pg=kb.page&id=35
Sergey Smagin | email
2 weeks since original post
This topic is closed