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.
Thank you for your post.
The SequeLink driver is expecting double quotes around field names that contain spaces. Therefore, the proper syntax would be:
SELECT Keywords, "Serial Number" FROM Inventory