Handling database view with numeric column name
Posted: Tue May 15, 2007 1:18 pm
Hi,
I use the following method to register columns of table/view directly from a database:
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.
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);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.