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

Reply via email to