TOracleDataset with table name of '"'

[Tony Ng]

If we use "table a" as a table name, and place 'select * from "table a"' on TOracleDataset. It would be no problem. (In database, the table name is lowercase with space such as 'table a'.)

However, when we try to insert any record with TOracleNavigator, the insert statement will replace table name as 'TABLE'. Even I fill in the table name "table a" to UpdatingTable property. It remove the '"'.

Thanks,

Tony Ng

 

[Marco Kalter]

The TOracleDataSet currently does not support mixed case identifiers for table names and column names. We hope to address this in the next release.

The work around is to omit such identifiers, or to use a view to convert these identifiers.

------------------
Marco Kalter
Allround Automations