Question

Iphone Currently I am writing my query like this

rs=[dblement Query:@ “SlectT * from FormData where flgActive=1 and FirstName as ?”,filcondition];

以上只是我们写全名时显示数据。

i 如果一个关键词一样,那么所有名字都应有适当的数据。

Answer 1

问题

 NSString stringWithFormat:@"SELECT * from FormData where flgActive=1 and FirstName like %@%%",prefixString];

Answer 2

 NSString *searchfilter = [NSString stringWithFormat:@"%@*",@"a"];
strValue = [NSString stringWithFormat:@"SELECT * FROM YuurTable where FirstName like[c] %@", searchfilter];

美国也可以直接使用“a”

These bottom lines are may not use for u

 const char *sql = [strValue UTF8String];

    NSString *requireddata=[NSString stringWithUTF8String:(char *)sqlite3_column_text(selectAllStmt, 3)];

友情链接