1 Reply Latest reply on Dec 3, 2009 1:20 PM by TSGal

    Trouble to using JDBC to query filed with space in field name

    whiteb

      Title

      Trouble to using JDBC to query filed with space in field name

      Post

      Third party's database has some data field names with space. I am not allowed to changed these names.

       

      When I use jdbc to query FileMaker database, I got trouble to query these data fields.

       

      For example, using following query:

      SELECT Keywords, `Serial Number` FROM Inventory

       

      I get error: java.sql.SQLException: [DataDirect][SequeLink JDBC Driver][ODBC Socket][DataDirect][ODBC FileMaker driver][FileMaker]Parse Error in SQL

       

      I have tried  "SELECT Keywords, [Serial Number] FROM Inventor", I get same error message.

       

      Please advise how to solve this problem.

       

      Thanks in advance for your help.