SELECT Field with Points and Special characters

dietmarruef

Hi!

I want to Select a Field with Special characters like "." and "-"
from an externally Program.
I want to do that with SQL and JDBC but it dosn`t work.

For Example: "SELECT 'No.', Description, Class FROM Item";

When I start the Program then this SELECT I get the Error:
java.sql.SQLException: Column name: No. cannot be found in result set

Know anyone a solution for this Problem???

Best regards

Dietmar

Luc_VanDyck

Did you create a Navision-ODBC datasource? There is an option to convert the names of the tables and fields which contains characters as a dot or a space. You have the option to convert this to _ (underscore) so the field "No." becomes "No_"

dietmarruef

Thank you! It works great!