forlano Messages: 1207 Registered: March 2006 Location: Italy
Senior Contributor
dolik.rce wrote on Sun, 30 December 2012 09:44
For the last piece of code you posted: You probably want the inserting into TEAMROUND to be done in single query too. You now know how, so it should be easy.
I tried but I am afraid this time it can't be done. In fact I am iserting in two tables (TEAMROUND and PLAYERROUND) and in the second one I need the 'id' of the record just inserted in the first table that is unknown before of query (or maybe yes ). So, after the query I get it by
int idTEAMROUND = SQL.GetInsertedId();
and then use it later in the final query.