SQLite syntax error - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

SQLite syntax error

Author

Topic

romo_daneghyan
Starting Member

1 Post

Posted - 2014-09-18 : 10:44:01

Hey Guys. I am new to sqlite, and I have such a query, but when executing it I am getting some syntax error. PLease check the syntax .
;"

"ATTACH DATABASE 'E:\\LangS.s3db' AS 'Lang' INSERT INTO LangS.Translations(text, English, Russian, Armenian, French, Spanish, Arabic) SELECT text, English, Russian, Armenian, French, Spanish, Arabic FROM main.Translations where Soft=1

I am getting this kind of error .
SQL logic error or missing database

near "INSERT": syntax error

Can't understand what is the problem :/

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-09-18 : 11:11:58

Hi romo, you should post your question on a site that specializes in SQLite. SQLTeam.com is for Microsoft SQL Server. Judging by the syntax you posted, the SQL language is not similar enough for us to help.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources