Query Builder and special characters in column names

[Brian Baker]

If a column name contains spaces or other special characters (such as a slash), the Query Builder has two problems:

1. The generated SQL does not put quotes around the column name and does not use the correct capitalization that is required when using quoted column names.

2. The "X" does not stay checked next to the column name in the query builder.

 

[Stew Stryker]

I'll bite. What database are you using that allows table columns to be named this way?

 

[ScottMattes]

Oracle allows you to do this I think (at least I know that I have seen the field names in quotes before, with mixed case)

 

[Marco Kalter]

There are indeed some restrictions when using spaces in column names. We'll fix this in a future release.

 

[Stew Stryker]

Hmm, didn't know that! I guess that's what happens when your only experience with the database is from working for one company enhancing a vendor package. You don't need to work with some of the special Oracle features, so you forget they exist!

:-/

 

[Brian Baker]

Originally posted by Marco Kalter:
There are indeed some restrictions when using spaces in column names. We'll fix this in a future release.

Thanks Marco.

For the others -- I am trying to build a view to replace a table inside of an Access database. The people that designed that table didn't mind using non-standard characters.