class_update_query.htm 21 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412
  1. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  2. <html xmlns="http://www.w3.org/1999/xhtml">
  3. <head>
  4. <meta http-equiv="Content-Type" content="text/xhtml;charset=UTF-8"/>
  5. <meta http-equiv="X-UA-Compatible" content="IE=9"/>
  6. <meta name="generator" content="Doxygen 1.8.14"/>
  7. <meta name="viewport" content="width=device-width, initial-scale=1"/>
  8. <title>EasyQtSql: UpdateQuery Class Reference</title>
  9. <link href="tabs.css" rel="stylesheet" type="text/css"/>
  10. <script type="text/javascript" src="jquery.js"></script>
  11. <script type="text/javascript" src="dynsections.js"></script>
  12. <link href="navtree.css" rel="stylesheet" type="text/css"/>
  13. <script type="text/javascript" src="resize.js"></script>
  14. <script type="text/javascript" src="navtreedata.js"></script>
  15. <script type="text/javascript" src="navtree.js"></script>
  16. <script type="text/javascript">
  17. /* @license magnet:?xt=urn:btih:cf05388f2679ee054f2beb29a391d25f4e673ac3&amp;dn=gpl-2.0.txt GPL-v2 */
  18. $(document).ready(initResizable);
  19. /* @license-end */</script>
  20. <link href="search/search.css" rel="stylesheet" type="text/css"/>
  21. <script type="text/javascript" src="search/searchdata.js"></script>
  22. <script type="text/javascript" src="search/search.js"></script>
  23. <link href="doxygen.css" rel="stylesheet" type="text/css" />
  24. </head>
  25. <body>
  26. <div id="top"><!-- do not remove this div, it is closed by doxygen! -->
  27. <div id="titlearea">
  28. <table cellspacing="0" cellpadding="0">
  29. <tbody>
  30. <tr style="height: 56px;">
  31. <td id="projectalign" style="padding-left: 0.5em;">
  32. <div id="projectname">EasyQtSql
  33. </div>
  34. <div id="projectbrief">Easy SQL data access helper for QtSql</div>
  35. </td>
  36. </tr>
  37. </tbody>
  38. </table>
  39. </div>
  40. <!-- end header part -->
  41. <!-- Generated by Doxygen 1.8.14 -->
  42. <script type="text/javascript">
  43. /* @license magnet:?xt=urn:btih:cf05388f2679ee054f2beb29a391d25f4e673ac3&amp;dn=gpl-2.0.txt GPL-v2 */
  44. var searchBox = new SearchBox("searchBox", "search",false,'Search');
  45. /* @license-end */
  46. </script>
  47. <script type="text/javascript" src="menudata.js"></script>
  48. <script type="text/javascript" src="menu.js"></script>
  49. <script type="text/javascript">
  50. /* @license magnet:?xt=urn:btih:cf05388f2679ee054f2beb29a391d25f4e673ac3&amp;dn=gpl-2.0.txt GPL-v2 */
  51. $(function() {
  52. initMenu('',true,false,'search.php','Search');
  53. $(document).ready(function() { init_search(); });
  54. });
  55. /* @license-end */</script>
  56. <div id="main-nav"></div>
  57. </div><!-- top -->
  58. <div id="side-nav" class="ui-resizable side-nav-resizable">
  59. <div id="nav-tree">
  60. <div id="nav-tree-contents">
  61. <div id="nav-sync" class="sync"></div>
  62. </div>
  63. </div>
  64. <div id="splitbar" style="-moz-user-select:none;"
  65. class="ui-resizable-handle">
  66. </div>
  67. </div>
  68. <script type="text/javascript">
  69. /* @license magnet:?xt=urn:btih:cf05388f2679ee054f2beb29a391d25f4e673ac3&amp;dn=gpl-2.0.txt GPL-v2 */
  70. $(document).ready(function(){initNavTree('class_update_query.htm','');});
  71. /* @license-end */
  72. </script>
  73. <div id="doc-content">
  74. <!-- window showing the filter options -->
  75. <div id="MSearchSelectWindow"
  76. onmouseover="return searchBox.OnSearchSelectShow()"
  77. onmouseout="return searchBox.OnSearchSelectHide()"
  78. onkeydown="return searchBox.OnSearchSelectKey(event)">
  79. </div>
  80. <!-- iframe showing the search results (closed by default) -->
  81. <div id="MSearchResultsWindow">
  82. <iframe src="javascript:void(0)" frameborder="0"
  83. name="MSearchResults" id="MSearchResults">
  84. </iframe>
  85. </div>
  86. <div class="header">
  87. <div class="summary">
  88. <a href="#pub-methods">Public Member Functions</a> &#124;
  89. <a href="class_update_query-members.htm">List of all members</a> </div>
  90. <div class="headertitle">
  91. <div class="title">UpdateQuery Class Reference</div> </div>
  92. </div><!--header-->
  93. <div class="contents">
  94. <p>QSqlQuery wrapper for <em>UPDATE ... SET ... WHERE ...</em> query execution.
  95. <a href="class_update_query.htm#details">More...</a></p>
  96. <p><code>#include &lt;<a class="el" href="_easy_qt_sql___update_query_8h_source.htm">EasyQtSql_UpdateQuery.h</a>&gt;</code></p>
  97. <table class="memberdecls">
  98. <tr class="heading"><td colspan="2"><h2 class="groupheader"><a name="pub-methods"></a>
  99. Public Member Functions</h2></td></tr>
  100. <tr class="memitem:a2a81be31fd760b73a5cda2182fb347f1"><td class="memItemLeft" align="right" valign="top">&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_update_query.htm#a2a81be31fd760b73a5cda2182fb347f1">UpdateQuery</a> (const QString &amp;table, const QSqlDatabase &amp;db)</td></tr>
  101. <tr class="separator:a2a81be31fd760b73a5cda2182fb347f1"><td class="memSeparator" colspan="2">&#160;</td></tr>
  102. <tr class="memitem:a7c1b4eaa45048ec8a3f6f7d4223f5ace"><td class="memItemLeft" align="right" valign="top"><a class="el" href="class_update_query.htm">UpdateQuery</a> &amp;&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_update_query.htm#a7c1b4eaa45048ec8a3f6f7d4223f5ace">set</a> (const QString &amp;field, const QVariant &amp;value)</td></tr>
  103. <tr class="memdesc:a7c1b4eaa45048ec8a3f6f7d4223f5ace"><td class="mdescLeft">&#160;</td><td class="mdescRight">Sets table <em>field</em> to <em>value</em> <a href="#a7c1b4eaa45048ec8a3f6f7d4223f5ace">More...</a><br /></td></tr>
  104. <tr class="separator:a7c1b4eaa45048ec8a3f6f7d4223f5ace"><td class="memSeparator" colspan="2">&#160;</td></tr>
  105. <tr class="memitem:ab83ea43c6e98bd5534d9fa8ba0e5fe1b"><td class="memItemLeft" align="right" valign="top"><a class="el" href="class_update_query.htm">UpdateQuery</a> &amp;&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_update_query.htm#ab83ea43c6e98bd5534d9fa8ba0e5fe1b">set</a> (const QVariantMap &amp;map)</td></tr>
  106. <tr class="memdesc:ab83ea43c6e98bd5534d9fa8ba0e5fe1b"><td class="mdescLeft">&#160;</td><td class="mdescRight">Sets table fields to values from <em>map</em> <a href="#ab83ea43c6e98bd5534d9fa8ba0e5fe1b">More...</a><br /></td></tr>
  107. <tr class="separator:ab83ea43c6e98bd5534d9fa8ba0e5fe1b"><td class="memSeparator" colspan="2">&#160;</td></tr>
  108. <tr class="memitem:abb4c7b7502599a78699e3a1f4cb4cbda"><td class="memItemLeft" align="right" valign="top"><a class="el" href="class_non_query_result.htm">NonQueryResult</a>&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_update_query.htm#abb4c7b7502599a78699e3a1f4cb4cbda">where</a> (const QString &amp;expr)</td></tr>
  109. <tr class="memdesc:abb4c7b7502599a78699e3a1f4cb4cbda"><td class="mdescLeft">&#160;</td><td class="mdescRight">Executes update query with <em>expr</em> condition. <a href="#abb4c7b7502599a78699e3a1f4cb4cbda">More...</a><br /></td></tr>
  110. <tr class="separator:abb4c7b7502599a78699e3a1f4cb4cbda"><td class="memSeparator" colspan="2">&#160;</td></tr>
  111. <tr class="memitem:a666356b92d38bed265199b57bcd8c0e7"><td class="memItemLeft" align="right" valign="top"><a class="el" href="class_non_query_result.htm">NonQueryResult</a>&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_update_query.htm#a666356b92d38bed265199b57bcd8c0e7">where</a> (const QString &amp;expr, const QVariant &amp;last)</td></tr>
  112. <tr class="memdesc:a666356b92d38bed265199b57bcd8c0e7"><td class="mdescLeft">&#160;</td><td class="mdescRight">Executes update query with <em>expr</em> condition and <em>last</em> parameter binding. <a href="#a666356b92d38bed265199b57bcd8c0e7">More...</a><br /></td></tr>
  113. <tr class="separator:a666356b92d38bed265199b57bcd8c0e7"><td class="memSeparator" colspan="2">&#160;</td></tr>
  114. <tr class="memitem:a423087092ef6c17c5d97e6a268f85775"><td class="memTemplParams" colspan="2">template&lt;typename... Rest&gt; </td></tr>
  115. <tr class="memitem:a423087092ef6c17c5d97e6a268f85775"><td class="memTemplItemLeft" align="right" valign="top"><a class="el" href="class_non_query_result.htm">NonQueryResult</a>&#160;</td><td class="memTemplItemRight" valign="bottom"><a class="el" href="class_update_query.htm#a423087092ef6c17c5d97e6a268f85775">where</a> (const QString &amp;expr, const QVariant &amp;first, const Rest &amp;... rest)</td></tr>
  116. <tr class="separator:a423087092ef6c17c5d97e6a268f85775"><td class="memSeparator" colspan="2">&#160;</td></tr>
  117. <tr class="memitem:aa685f7d12dec7214a783be4289b39f4c"><td class="memItemLeft" align="right" valign="top"><a class="el" href="class_non_query_result.htm">NonQueryResult</a>&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_update_query.htm#aa685f7d12dec7214a783be4289b39f4c">exec</a> ()</td></tr>
  118. <tr class="memdesc:aa685f7d12dec7214a783be4289b39f4c"><td class="mdescLeft">&#160;</td><td class="mdescRight">Executes UPDATE query without conditions. <a href="#aa685f7d12dec7214a783be4289b39f4c">More...</a><br /></td></tr>
  119. <tr class="separator:aa685f7d12dec7214a783be4289b39f4c"><td class="memSeparator" colspan="2">&#160;</td></tr>
  120. </table>
  121. <a name="details" id="details"></a><h2 class="groupheader">Detailed Description</h2>
  122. <div class="textblock"><p>QSqlQuery wrapper for <em>UPDATE ... SET ... WHERE ...</em> query execution. </p>
  123. </div><h2 class="groupheader">Constructor &amp; Destructor Documentation</h2>
  124. <a id="a2a81be31fd760b73a5cda2182fb347f1"></a>
  125. <h2 class="memtitle"><span class="permalink"><a href="#a2a81be31fd760b73a5cda2182fb347f1">&#9670;&nbsp;</a></span>UpdateQuery()</h2>
  126. <div class="memitem">
  127. <div class="memproto">
  128. <table class="mlabels">
  129. <tr>
  130. <td class="mlabels-left">
  131. <table class="memname">
  132. <tr>
  133. <td class="memname">UpdateQuery::UpdateQuery </td>
  134. <td>(</td>
  135. <td class="paramtype">const QString &amp;&#160;</td>
  136. <td class="paramname"><em>table</em>, </td>
  137. </tr>
  138. <tr>
  139. <td class="paramkey"></td>
  140. <td></td>
  141. <td class="paramtype">const QSqlDatabase &amp;&#160;</td>
  142. <td class="paramname"><em>db</em>&#160;</td>
  143. </tr>
  144. <tr>
  145. <td></td>
  146. <td>)</td>
  147. <td></td><td></td>
  148. </tr>
  149. </table>
  150. </td>
  151. <td class="mlabels-right">
  152. <span class="mlabels"><span class="mlabel">inline</span></span> </td>
  153. </tr>
  154. </table>
  155. </div><div class="memdoc">
  156. </div>
  157. </div>
  158. <h2 class="groupheader">Member Function Documentation</h2>
  159. <a id="aa685f7d12dec7214a783be4289b39f4c"></a>
  160. <h2 class="memtitle"><span class="permalink"><a href="#aa685f7d12dec7214a783be4289b39f4c">&#9670;&nbsp;</a></span>exec()</h2>
  161. <div class="memitem">
  162. <div class="memproto">
  163. <table class="mlabels">
  164. <tr>
  165. <td class="mlabels-left">
  166. <table class="memname">
  167. <tr>
  168. <td class="memname"><a class="el" href="class_non_query_result.htm">NonQueryResult</a> UpdateQuery::exec </td>
  169. <td>(</td>
  170. <td class="paramname"></td><td>)</td>
  171. <td></td>
  172. </tr>
  173. </table>
  174. </td>
  175. <td class="mlabels-right">
  176. <span class="mlabels"><span class="mlabel">inline</span></span> </td>
  177. </tr>
  178. </table>
  179. </div><div class="memdoc">
  180. <p>Executes UPDATE query without conditions. </p>
  181. </div>
  182. </div>
  183. <a id="a7c1b4eaa45048ec8a3f6f7d4223f5ace"></a>
  184. <h2 class="memtitle"><span class="permalink"><a href="#a7c1b4eaa45048ec8a3f6f7d4223f5ace">&#9670;&nbsp;</a></span>set() <span class="overload">[1/2]</span></h2>
  185. <div class="memitem">
  186. <div class="memproto">
  187. <table class="mlabels">
  188. <tr>
  189. <td class="mlabels-left">
  190. <table class="memname">
  191. <tr>
  192. <td class="memname"><a class="el" href="class_update_query.htm">UpdateQuery</a>&amp; UpdateQuery::set </td>
  193. <td>(</td>
  194. <td class="paramtype">const QString &amp;&#160;</td>
  195. <td class="paramname"><em>field</em>, </td>
  196. </tr>
  197. <tr>
  198. <td class="paramkey"></td>
  199. <td></td>
  200. <td class="paramtype">const QVariant &amp;&#160;</td>
  201. <td class="paramname"><em>value</em>&#160;</td>
  202. </tr>
  203. <tr>
  204. <td></td>
  205. <td>)</td>
  206. <td></td><td></td>
  207. </tr>
  208. </table>
  209. </td>
  210. <td class="mlabels-right">
  211. <span class="mlabels"><span class="mlabel">inline</span></span> </td>
  212. </tr>
  213. </table>
  214. </div><div class="memdoc">
  215. <p>Sets table <em>field</em> to <em>value</em> </p>
  216. <dl class="params"><dt>Parameters</dt><dd>
  217. <table class="params">
  218. <tr><td class="paramname">field</td><td>Table field name </td></tr>
  219. <tr><td class="paramname">value</td><td>Value to set </td></tr>
  220. </table>
  221. </dd>
  222. </dl>
  223. <dl class="section return"><dt>Returns</dt><dd><a class="el" href="class_update_query.htm" title="QSqlQuery wrapper for UPDATE ... SET ... WHERE ... query execution. ">UpdateQuery</a> reference</dd></dl>
  224. <p>The method returns an <a class="el" href="class_update_query.htm" title="QSqlQuery wrapper for UPDATE ... SET ... WHERE ... query execution. ">UpdateQuery</a> reference so its call can be chained:</p>
  225. <div class="fragment"><div class="line"><span class="comment">//UPDATE table SET a=111, b=222</span></div><div class="line">t.<a class="code" href="class_database.htm#a2d8dad3df4134306749582216bd437e0">update</a>(<span class="stringliteral">&quot;table&quot;</span>)</div><div class="line"> .<a class="code" href="class_update_query.htm#a7c1b4eaa45048ec8a3f6f7d4223f5ace">set</a>(<span class="stringliteral">&quot;a&quot;</span>, 111) <span class="comment">//method chaining</span></div><div class="line"> .<a class="code" href="class_update_query.htm#a7c1b4eaa45048ec8a3f6f7d4223f5ace">set</a>(<span class="stringliteral">&quot;b&quot;</span>, 222)</div><div class="line"> .<a class="code" href="class_update_query.htm#aa685f7d12dec7214a783be4289b39f4c">exec</a>();</div></div><!-- fragment -->
  226. </div>
  227. </div>
  228. <a id="ab83ea43c6e98bd5534d9fa8ba0e5fe1b"></a>
  229. <h2 class="memtitle"><span class="permalink"><a href="#ab83ea43c6e98bd5534d9fa8ba0e5fe1b">&#9670;&nbsp;</a></span>set() <span class="overload">[2/2]</span></h2>
  230. <div class="memitem">
  231. <div class="memproto">
  232. <table class="mlabels">
  233. <tr>
  234. <td class="mlabels-left">
  235. <table class="memname">
  236. <tr>
  237. <td class="memname"><a class="el" href="class_update_query.htm">UpdateQuery</a>&amp; UpdateQuery::set </td>
  238. <td>(</td>
  239. <td class="paramtype">const QVariantMap &amp;&#160;</td>
  240. <td class="paramname"><em>map</em></td><td>)</td>
  241. <td></td>
  242. </tr>
  243. </table>
  244. </td>
  245. <td class="mlabels-right">
  246. <span class="mlabels"><span class="mlabel">inline</span></span> </td>
  247. </tr>
  248. </table>
  249. </div><div class="memdoc">
  250. <p>Sets table fields to values from <em>map</em> </p>
  251. <dl class="params"><dt>Parameters</dt><dd>
  252. <table class="params">
  253. <tr><td class="paramname">map</td><td>Values map. Map key is field name, map value is field value.</td></tr>
  254. </table>
  255. </dd>
  256. </dl>
  257. <p>The method returns an <a class="el" href="class_update_query.htm" title="QSqlQuery wrapper for UPDATE ... SET ... WHERE ... query execution. ">UpdateQuery</a> reference so its calls can be chained.</p>
  258. <div class="fragment"><div class="line"><span class="comment">//UPDATE table SET a=111, b=222</span></div><div class="line">t.<a class="code" href="class_database.htm#a2d8dad3df4134306749582216bd437e0">update</a>(<span class="stringliteral">&quot;table&quot;</span>)</div><div class="line"> .<a class="code" href="class_update_query.htm#a7c1b4eaa45048ec8a3f6f7d4223f5ace">set</a>(QVariantMap{ {<span class="stringliteral">&quot;a&quot;</span>, 111}, {<span class="stringliteral">&quot;b&quot;</span>, 222} })</div><div class="line"> .<a class="code" href="class_update_query.htm#aa685f7d12dec7214a783be4289b39f4c">exec</a>();</div></div><!-- fragment -->
  259. </div>
  260. </div>
  261. <a id="abb4c7b7502599a78699e3a1f4cb4cbda"></a>
  262. <h2 class="memtitle"><span class="permalink"><a href="#abb4c7b7502599a78699e3a1f4cb4cbda">&#9670;&nbsp;</a></span>where() <span class="overload">[1/3]</span></h2>
  263. <div class="memitem">
  264. <div class="memproto">
  265. <table class="mlabels">
  266. <tr>
  267. <td class="mlabels-left">
  268. <table class="memname">
  269. <tr>
  270. <td class="memname"><a class="el" href="class_non_query_result.htm">NonQueryResult</a> UpdateQuery::where </td>
  271. <td>(</td>
  272. <td class="paramtype">const QString &amp;&#160;</td>
  273. <td class="paramname"><em>expr</em></td><td>)</td>
  274. <td></td>
  275. </tr>
  276. </table>
  277. </td>
  278. <td class="mlabels-right">
  279. <span class="mlabels"><span class="mlabel">inline</span></span> </td>
  280. </tr>
  281. </table>
  282. </div><div class="memdoc">
  283. <p>Executes update query with <em>expr</em> condition. </p>
  284. <dl class="params"><dt>Parameters</dt><dd>
  285. <table class="params">
  286. <tr><td class="paramname">expr</td><td>WHERE condition</td></tr>
  287. </table>
  288. </dd>
  289. </dl>
  290. <div class="fragment"><div class="line"><span class="comment">//UPDATE table SET a=111, b=222 WHERE a=1 AND b=2</span></div><div class="line">t.<a class="code" href="class_database.htm#a2d8dad3df4134306749582216bd437e0">update</a>(<span class="stringliteral">&quot;table&quot;</span>)</div><div class="line"> .<a class="code" href="class_update_query.htm#a7c1b4eaa45048ec8a3f6f7d4223f5ace">set</a>(QVariantMap{ {<span class="stringliteral">&quot;a&quot;</span>, 111}, {<span class="stringliteral">&quot;b&quot;</span>, 222} })</div><div class="line"> .<a class="code" href="class_update_query.htm#abb4c7b7502599a78699e3a1f4cb4cbda">where</a>(<span class="stringliteral">&quot;a=1 AND b=2&quot;</span>);</div></div><!-- fragment -->
  291. </div>
  292. </div>
  293. <a id="a666356b92d38bed265199b57bcd8c0e7"></a>
  294. <h2 class="memtitle"><span class="permalink"><a href="#a666356b92d38bed265199b57bcd8c0e7">&#9670;&nbsp;</a></span>where() <span class="overload">[2/3]</span></h2>
  295. <div class="memitem">
  296. <div class="memproto">
  297. <table class="mlabels">
  298. <tr>
  299. <td class="mlabels-left">
  300. <table class="memname">
  301. <tr>
  302. <td class="memname"><a class="el" href="class_non_query_result.htm">NonQueryResult</a> UpdateQuery::where </td>
  303. <td>(</td>
  304. <td class="paramtype">const QString &amp;&#160;</td>
  305. <td class="paramname"><em>expr</em>, </td>
  306. </tr>
  307. <tr>
  308. <td class="paramkey"></td>
  309. <td></td>
  310. <td class="paramtype">const QVariant &amp;&#160;</td>
  311. <td class="paramname"><em>last</em>&#160;</td>
  312. </tr>
  313. <tr>
  314. <td></td>
  315. <td>)</td>
  316. <td></td><td></td>
  317. </tr>
  318. </table>
  319. </td>
  320. <td class="mlabels-right">
  321. <span class="mlabels"><span class="mlabel">inline</span></span> </td>
  322. </tr>
  323. </table>
  324. </div><div class="memdoc">
  325. <p>Executes update query with <em>expr</em> condition and <em>last</em> parameter binding. </p>
  326. <dl class="params"><dt>Parameters</dt><dd>
  327. <table class="params">
  328. <tr><td class="paramname">expr</td><td>WHERE condition </td></tr>
  329. <tr><td class="paramname">last</td><td>Parameter to bind on WHERE expression</td></tr>
  330. </table>
  331. </dd>
  332. </dl>
  333. <p>The method supports variable count of QVariant parameters. Parameters are bound with <em>QSqlQuery::addBindValue</em>. </p><div class="fragment"><div class="line"><span class="comment">//UPDATE table SET a=111, b=222 WHERE a=1 AND b=2</span></div><div class="line">t.<a class="code" href="class_database.htm#a2d8dad3df4134306749582216bd437e0">update</a>(<span class="stringliteral">&quot;table&quot;</span>)</div><div class="line"> .<a class="code" href="class_update_query.htm#a7c1b4eaa45048ec8a3f6f7d4223f5ace">set</a>(QVariantMap{ {<span class="stringliteral">&quot;a&quot;</span>, 111}, {<span class="stringliteral">&quot;b&quot;</span>, 222} })</div><div class="line"> .<a class="code" href="class_update_query.htm#abb4c7b7502599a78699e3a1f4cb4cbda">where</a>(<span class="stringliteral">&quot;a=? AND b=?&quot;</span>, 1, 2);</div></div><!-- fragment -->
  334. </div>
  335. </div>
  336. <a id="a423087092ef6c17c5d97e6a268f85775"></a>
  337. <h2 class="memtitle"><span class="permalink"><a href="#a423087092ef6c17c5d97e6a268f85775">&#9670;&nbsp;</a></span>where() <span class="overload">[3/3]</span></h2>
  338. <div class="memitem">
  339. <div class="memproto">
  340. <div class="memtemplate">
  341. template&lt;typename... Rest&gt; </div>
  342. <table class="mlabels">
  343. <tr>
  344. <td class="mlabels-left">
  345. <table class="memname">
  346. <tr>
  347. <td class="memname"><a class="el" href="class_non_query_result.htm">NonQueryResult</a> UpdateQuery::where </td>
  348. <td>(</td>
  349. <td class="paramtype">const QString &amp;&#160;</td>
  350. <td class="paramname"><em>expr</em>, </td>
  351. </tr>
  352. <tr>
  353. <td class="paramkey"></td>
  354. <td></td>
  355. <td class="paramtype">const QVariant &amp;&#160;</td>
  356. <td class="paramname"><em>first</em>, </td>
  357. </tr>
  358. <tr>
  359. <td class="paramkey"></td>
  360. <td></td>
  361. <td class="paramtype">const Rest &amp;...&#160;</td>
  362. <td class="paramname"><em>rest</em>&#160;</td>
  363. </tr>
  364. <tr>
  365. <td></td>
  366. <td>)</td>
  367. <td></td><td></td>
  368. </tr>
  369. </table>
  370. </td>
  371. <td class="mlabels-right">
  372. <span class="mlabels"><span class="mlabel">inline</span></span> </td>
  373. </tr>
  374. </table>
  375. </div><div class="memdoc">
  376. </div>
  377. </div>
  378. <hr/>The documentation for this class was generated from the following file:<ul>
  379. <li>EasyQtSql/<a class="el" href="_easy_qt_sql___update_query_8h_source.htm">EasyQtSql_UpdateQuery.h</a></li>
  380. </ul>
  381. </div><!-- contents -->
  382. </div><!-- doc-content -->
  383. <!-- start footer part -->
  384. <div id="nav-path" class="navpath"><!-- id is needed for treeview function! -->
  385. <ul>
  386. <li class="navelem"><a class="el" href="class_update_query.htm">UpdateQuery</a></li>
  387. <li class="footer">Generated by
  388. <a href="http://www.doxygen.org/index.html">
  389. <img class="footer" src="doxygen.png" alt="doxygen"/></a> 1.8.14 </li>
  390. </ul>
  391. </div>
  392. </body>
  393. </html>