When export or try to run a sql script into sqlite and have the "COMMENTS" keyword usage, sqlite arent able to procesed the script, due stupid developers does not handle support since many years:
LOOK HERE: http://sqlite.1065341.n5.nabble.com/Feature-request-add-support-for-COMMENT-statement-td69401.html
so the solution its to grep and replace (take easy, u can made it in geany of venenux) using a regular expresion:
1) open geany
2) load the script
3) menu->search->replace
4) marks use regular expr
5) the word to search will be COMMENT \'.*\'
6) the word to replace it will be empty
7) pull down avanced "Replace all" and select Document
8) that's all
now at least COMMENT keyword was eliminated from script and sqlite can procesed the sql.
LOOK HERE: http://sqlite.1065341.n5.nabble.com/Feature-request-add-support-for-COMMENT-statement-td69401.html
so the solution its to grep and replace (take easy, u can made it in geany of venenux) using a regular expresion:
1) open geany
2) load the script
3) menu->search->replace
4) marks use regular expr
5) the word to search will be COMMENT \'.*\'
6) the word to replace it will be empty
7) pull down avanced "Replace all" and select Document
8) that's all
now at least COMMENT keyword was eliminated from script and sqlite can procesed the sql.
Comentarios
Publicar un comentario
no stupid winbuntu users allowed!