S
Sheila Stewart
Guest
We are using the OpenAccess server SDK to provide SQL access to a database which has a case-sensitive schema. To do this we implemented the IP using the dynamic schema option, however because the IP does not recognize any column names which differ only by case, it is not possible to SELECT the "different" column names by name; only the first instance is viewable. For some reason, it is still possible to UPDATE the "different"column values, or to select the columns via "SELECT *"; just not SELECT them by name or use them in a condition statement. Renaming the columns for this database is not an option because the naming convention is not within our control and thus cannot be enforced; therefore I would like to request that the OpenAcess SDK be enhanced to support case-sensitive database schemas, or at least support for the use of delimited identifiers with identifiers that differ only by case, specifically for when the IP implements dynamic schemas. Otherwise our only option is to tell our customers that they will not be able to access all of the data in their databases.
Continue reading...
Continue reading...