Poco中的SQLite UPDATE记录语法

Question

我在这里找不到语法;有没有更多POCO-SQLite的例子？

我得到一个波科::例外， sendErrorResponse HTTP_INTERNAL_SERVER_ERROR

    Poco::Data::SQLite::Connector::registerConnector(); 
        // create a new session 
        Session updsession("SQLite", managers); 
        facilities UnitFacility; 

        Statement updateRecord(updsession); 

        updsession << "UPDATE facilities SET name = nameString, address = addressString, phone = phoneString WHERE facilityNumber = 3;"; 
        updateRecord.execute(); 

//更新时间：简体带或不带[]仍然没有去。

    Poco::Data::SQLite::Connector::registerConnector(); 
        Session updsession("SQLite", managers); 
        Statement updateRecord(updsession); 
        updsession << "UPDATE facilities SET Name = 'Frank' WHERE [FacilityNumber = 1];",now; 
        updateRecord.execute(); 

Answer 1

这两个SQL查询都是无效的。

原始查询：

UPDATE facilities SET name = nameString, address = addressString, phone = phoneString WHERE facilityNumber = 3 

结果：

no such column: nameString: UPDATE facilities SET name = nameString, address = addressString, phone = phoneString WHERE facilityNumber = 3 

固定查询：

UPDATE facilities SET name = 'nameString', address = 'addressString', phone = 'phoneString' WHERE facilityNumber = 3 

结果：

Query executed successfully: UPDATE facilities SET name = 'nameString', address = 'addressString', phone = 'phoneString' WHERE facilityNumber = 3 (took 0ms, 1 rows affected) 

原始查询：

UPDATE facilities SET Name = 'Frank' WHERE [FacilityNumber = 1] 

结果：

no such column: FacilityNumber = 1: UPDATE facilities SET Name = 'Frank' WHERE [FacilityNumber = 1] 

固定查询：

UPDATE facilities SET Name = 'Frank' WHERE FacilityNumber = 1 

结果：

Query executed successfully: UPDATE facilities SET Name = 'Frank' WHERE FacilityNumber = 1 (took 0ms, 1 rows affected) 

目前尚不清楚是什么问题，有使用HTTP。