Can not edit table/columns with names containing lower case letters (using double quotes)

Claus Pedersen

Member³
I have created a table "MyTable" in the table editor with one column "Col1".
The table and column names are entered with mixed case using double quotes.

When I rightclick on the column in the object browser, the options to rename and drop the column are not there. Why?

When I use the table editor to rename the column to e.g. "Col2", a new table MYTABLE is created. That was not my intention. PLD apparently forgets to include double quotes in "MyTable", and I can not add them manually as the field for table name is write protected.

If I add a new column, PLD also fails, because it will try to add the column to MYTABLE, which does not exist.
 
Back
Top