Handling database view with numeric column name

[lcruiser]

Hi,

I use the following method to register columns of table/view directly from a database:

Code: Select all

StiSqlSource source = new StiSqlSource(databaseName, qualifiedName, qualifiedName,
                            "SELECT * FROM " + qualifiedName);

This works fine most of the time, on some occation the view contains numeric column name (for example the view Sales.vSalesPersonSalesByFiscalYears in the AdventureWorks SQL 2005 Server), this is causing problem for StimultReport. If I edit and enclose the numeric column name in square brackets in Designer Dictionary StimultReport will handle it with no problem.

Can StimultReport be enhanced to automatically enclosed numeric column name in square brackets? Or is there some way that to implement this in codes?

Thanks.

[Edward]

We planning to add this feature in a week.

We will inform you in this topic when the solution will be ready.

Thank you.