Hi all
Quick question Should the - operator work in FTS in conjunction with the phrase operator i.e. router -"ip address" sqlite3_step returns SQLITE_ERROR which leads me to believe its invalid but the question is should it be invalid, it seems a perfectly valid use of the syntax to me. My code is sqlite3_stmt* pStatement; char* acSQLQuery = sqlite3_mprintf("SELECT * FROM data WHERE story MATCH '%q'",acQuery); nRet = sqlite3_prepare_v2(pDB,acSQLQuery,-1,&pStatement,0); nRet = sqlite3_step(pStatement); Thanks for any help or pointers, or even just letting me know it's a bug so I can raise a ticket. Mike _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users