TQuery SQL EDBEngineError
Posted on 2002-03-05
I tried to make a SQL application and I have got the EDBEngineError message: General SQL error [Microsoft][ODBC Microsoft Access Driver]Syntax error (missing operator) in query expression in query expression 'Country where country >= F'.'.
There is a DataModule with Query1: TQery and the SQL-phrase is :
Query1.SQL.Add('select * from Country order by COUNTRY where COUNTRY >= ' + EditBox1.Text;
Something interesting is the end of error phrase: quote - point - qoute
meikl told me to replace the
but the resulted error message was the same.
Could somebody give me a new idea? I try to give more points later but now I have only this ten.