I have little problem with my code and i need advice how to make it work right way.
In my code i am collecting IDs to array in loop. Final array is transformed to string "scorersStr" and can looks like here {1,2,2,1,8,9,5,2}
Finally I am increasing values for this IDs
Code: Select all
wxString sql88;
sql88.Printf("update players set goals = goals +1 where id_player in (" + scorersStr + ")" );
wxSQLite3ResultSet Res88 = this->DB->ExecuteQuery(sql88);
My question: Is there way how to perform this task correctly in one query?? Thanks