Mega Code Archive

 

Categories / Delphi / ADO Database

 

syntax error in query incomplete query clause

Question: "Syntax error in query. Incomplete query clause" error: I get this error when I run a query against a table with a space in the table name. I have double quotes around the name but it still does not work. What am I doing wrong? Answer: You need to change the double quotes " " to brackets [ ] Example: SELECT * FROM "MY TABLE NAME" needs to change to SELECT * FROM [MY TABLE NAME]