WhiteUnicorn

	#WhiteUnicorn/ StartPage/ Documentation/DelphiFAQ >

Frequently Asked Questions

'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]
 

	#WhiteUnicorn/ StartPage/ Documentation/DelphiFAQ >

	Anastasija aka WhiteUnicorn	LiveJournal PhotoFile