CSqlStatement *stcity = sqlite.Statement(_T("SELECT city FROM timezone WHERE country = "+"'"+selcountry+"'"));
该语句中selcountry是变量,查询语句单独写如下:
SELECT city FROM timezone WHERE country = '变量'
请指教
CString temp;
temp.Format("SELECT city FROM timezone WHERE country = '%s'", selcountry);
或者用sprintf也可以。
CString::Format