Howdy guys,
I'm migrating my data access layer from OLE DB to .Net Provider (V5R3)
and now I've an issue, some of my tables have columns names within a
special character $ (for instance, SD$9INID ).
When I execute a commandText
Select SD$9INID From MYLIBRARY.MYTABLE
OLE DB returns a table with a column named SD$9INID and .Net Provider
returns a table with a column named "SD$9INID" and then my internal
business logic is broken!
Any ideas?... I need to enforce .Net Provider returns the same table
shema returned by OLE DB.
Tks.
Charlie - 27 Jan 2006 20:15 GMT
Ok.. I did a workaround.. after the execute the DataAdapter Fill
method, I rename all columns with Columns.ColumnName =
Column.ColumnName.Replace(sComma,sBlank).