ERROR: ID in Update-Statements in Connector JAVA Version

Suite and Optimus Suite 5
#1

We had a problem with dataprocessor: SQL was not valid because the generated sql included the id field (autoincrement db field) in the update statement. We fixed it by adding this code:com.dhtmlx.connector.DBDataWrapper [code]private String update_query(DataAction data, DataRequest source) {
StringBuffer sql = new StringBuffer();
sql.append(“UPDATE “+source.get_source()+” SET “);
for (int i=0; i<config.text.size(); i++){
//new coding here if (config.text.get(i).db_name.equals(config.id.db_name)) {
continue;
}// end new coding
if (i!=0) sql.append(”,”);

		ConnectorField field = config.text.get(i);
		sql.append(field.db_name+"='"+escape(data.get_value(field.name))+"'");
	}
	sql.append(" WHERE "+config.id.db_name+"='"+escape(data.get_id())+"' ");
	//if we have limited set - set constraints
	String where = build_where(source.get_filters(),source.get_relation());
	if (!where.equals(""))
		sql.append(" AND ("+where+")");
	
	return sql.toString();
}[/code]
#2

Thanks