Forum Discussion

CaptJack's avatar
CaptJack
New Contributor II
1 day ago
Solved

SICResults Table Name

We are having an issue with many of our Data Adapters.

The Results Table Name continues to return as "SICResults".  They are using a DataSet BR.  Not all of them have this issue, even though others are using the same DBConn Connection.
This does not happen when using the External SQL Connection
This is an issue when we try using 2 adapters on the same Report Component.
We cannot have 2 data sources with the same name.

Of the 4 ways to change this name:
1) Place the table name in the call of a New DataTable()
2) Use the TableName property after a new DataTable is made
3) Name the query result "Select .......... AS TableName"
4) Use the Results Table Name within the data adapter.

Our code has no reference to "SICResults" anywhere.  None of our code does.  

We just upgrade to 9.2

  • So, the solution came out to be set the DataTable.TableName property AFTER you fill the table with SIC Data.

1 Reply

  • CaptJack's avatar
    CaptJack
    New Contributor II

    So, the solution came out to be set the DataTable.TableName property AFTER you fill the table with SIC Data.