Trouble to using JDBC to query filed with space in field name
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.