Double Quoted TableNames for numeric leading tables.

sse

sse

Member²
Does anyone know how to make Direct Oracle Access work with queries involving tables that lead with numeric characters?

The original tables were created with double quotes and we form our queries with double quotes around the table names. But DOA purposefully strips the double quotes when performing its internal/intermediate queries (ref, TOracleDataset.GetUpdatingTable). This leads to access violations in our application.

Unfortunately, modifying the tablenames at this point is not feasible.

Has anyone else experienced this, and if so, how have you gotten around the problem.

This is an older system and the double quoted table names are pervasive.

Thank you!!
 
Table names that require quotes are indeed not supported by the TOracleDataSet. You would need to modify the TOracleDataset.GetUpdatingTable function to add support.
 
Thank you Marco. I feared that. Since Oracle supports double quoted tablenames, I believe it is reasonable to expect DOA to also support them, or at least not to remove them when they are present.

Is this something you would consider adding. Or are there other wrinkles to be concerned about.

Thank you,

Shereif

 
Hi Marco,

Just following up on my response from last week. Will you be able to provide us with a patch for this issue?

Thank you,

Shereif
 
We're looking into this. Does the table also have column names with leading numeric characters, mixed case characters, or special characters that would require quotes?
 
Ok, Wonderful!

There are no columns with leading numerics, mixed cases, or special characters. That said, it is possible for a client to setup user defined columns. We would discourage them from creating such columns, but it would be good to protect this code too.

Thank you again,

Shereif

 
Hi Marco,

Just following up again. Can you provide an eta for this patch.

Thank you,

Shereif
 
You must log in or register to reply here.
Back
Top