N/APosted on - 12/26/2013
I am a beginner to SQLite finding very hard to trace the errors and solutions for it. This is the syntax error I am getting and I have this error for some of my other database too. So please help me to resolve this issue and help me to learn more. Here the syntax should end with period?
Sorry,SQLiteConnection Write returned an error.
Check the event log for details.
near “s”: syntax error
SQLite Connection Write returned an error
Hello There SQLite throws “SQLite error Near “s”: syntax error” to indicate there is something wrong in select statement. If you use select, it would say.. Near“x”. So check your query first, you did not put the query here, otherwise we could have tried to check it once.Actually, people who tend to use Oracle, MYSQL, DB2,SYBASE faces some issue with SQLite, because of syntactical difference. Escape characters are differently used also