AnsweredAssumed Answered

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

Question asked by whiteb on Nov 19, 2009
Latest reply on Dec 3, 2009 by TSGal

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.

Outcomes