SQLite 错误:“s"附近:语法错误 [英] SQLite Error: near "s": syntax error

问题描述

我总是收到这个错误

s"附近:语法错误

我的实现:

litecon.ConnectionString = "Data Source=" + AppAddress + "\\database\\mynew22.db;Version=3;UTF16Encoding=True";

此方法收到错误 -> liteda.Fill(dt);

error recived form this method -> liteda.Fill(dt);

        if (lang == "FaToMe")
            liteda.SelectCommand = new SQLiteCommand("select * from mey where trans like '%" + str + "%'", litecon);
        else
            liteda.SelectCommand = new SQLiteCommand("select * from mey where pe like '%" + str + "%'", litecon);

        DataTable dt = new DataTable();
        liteda.Fill(dt); //liteda is SQLiteDataAdapter

这个选择命令没有区别...

no difference between this select commands...

"select * from mey where pe like '%" + str + "%'"

或

"select eng "

总是在s"附近说:语法错误

always say near "s": syntax error

我正在使用这个库http://adodotnetsqlite.sourceforge.net/

推荐答案

问题解决了！

使用了这些库，问题就解决了...http://www.devart.com/dotconnect/sqlite/download.html

used these library and The problem was solved... http://www.devart.com/dotconnect/sqlite/download.html

谢谢各位

这篇关于SQLite 错误:“s"附近:语法错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！