How to UPDATE multiple tuples?

Jan 6, 2016 at 8:41 AM
hi,

I want to update multiple tuples. However, I found there is no "WhereIn" in DBUpdateQuery.

I use "WhereAny" like this :

DBComparison[] value = new DBComparison[2];
value[0] = DBComparison.Compare(DBField.Field("colID"), Compare.Equals, DBConst.String("1"));
value[1] = DBComparison.Compare(DBField.Field("colID"), Compare.Equals, DBConst.String("2"));
var qry = DBQuery.Update("DBTable").Set("col1", DBConst.String("aa")).WhereAny(value);

But it can not run successfully.
:(
Do you have some suggestions?