I recently used SQLite for framework testing and encountered a problem during query. First, let's take a look at my statements:
Results of SQL statement query in SQLite develop:
PassProgramQuery statement:
Testeo EOO = m_testdao.load ("Select * from Main. [testeo] Where id = '0534ce32-6685-45c7-9f6f-72b03444ffe5'");
Results of parameterized query:
Dbparameter P = m_testdao.db.createparameter ();
P. parametername ="@ Param1";
P. sourcecolumn ="ID";
P. value ="0534ce32-6685-45c7-9f6f-72b03444ffe5";
P. dbtype = dbtype. String;
Testeo EOO = m_testdao.load ("Select * from Main. [testeo] Where id = @ param1",NewDbparameter [] {p}, commandtype. Text );
The result is: the results obtained through SQL statements are empty, and the results obtained through parameterized query are normal.
Does SQLite not support SQL queries? Thank you for your advice!