Client Server Workspace: Query Window Results Limitation (Warehousing)

In the Client Server Workspace the Query Window's results viewer has a limitation on how many columns can be viewed at one time.  If a query results in more than 127 columns, nothing will be displayed.  This is caused by the edit table limit of 127 columns.

For example:  After a data source is configured, open the Query Window and type a select statement.  In the select statement specify 127 columns and run the query.  For example:  "select col_1, col_2, …, col_126, col_127 from table"; (if you do not have a table with a large number of columns, you can select the same column 127 times).  If syntactically correct, the query will display 127 columns successfully.  However, adding another column to the select statement will cause the results viewer to be blank, even if data is returned.