// ************************************
// Compose and prepare update statement
sSQL = oColList.toString("=?,");
ListIterator oIter = getPrimaryKey().listIterator();
while (oIter.hasNext()) {
sCol = (String) oIter.next();
try {
sSQL = Gadgets.replace(sSQL, sCol + "=?,", "");
sSQL = Gadgets.replace(sSQL, sCol + "=?", "");
} catch (Exception neverthrown) {}
}
String[] aUpdtCols = Gadgets.split(sSQL, ",");
for (int c=0; c<aUpdtCols.length; c++) {
oUpdtColPos.put(Gadgets.dechomp(aUpdtCols[c],"=?").toLowerCase(),new Integer(c+1));
}
sSQL = "UPDATE "+getName()+" SET "+sSQL+ " WHERE ";
oIter = getPrimaryKey().listIterator();
int iPK=1;
while (oIter.hasNext()) {
sCol = (String) oIter.next();
oUpdtColPos.put(sCol.toLowerCase(),new Integer(aUpdtCols.length+iPK));
if (iPK>1) sSQL += " AND ";
sSQL += sCol+"=?";
iPK++;
}