class_query_result.htm 107 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703170417051706170717081709171017111712171317141715171617171718171917201721172217231724172517261727172817291730173117321733173417351736173717381739174017411742174317441745174617471748174917501751175217531754175517561757175817591760176117621763176417651766176717681769177017711772177317741775177617771778177917801781178217831784178517861787178817891790179117921793179417951796179717981799180018011802180318041805180618071808180918101811181218131814181518161817181818191820182118221823182418251826182718281829183018311832183318341835183618371838183918401841184218431844184518461847184818491850185118521853185418551856185718581859186018611862186318641865186618671868186918701871187218731874187518761877187818791880188118821883188418851886188718881889189018911892189318941895189618971898189919001901190219031904190519061907190819091910191119121913191419151916191719181919192019211922192319241925192619271928192919301931193219331934193519361937193819391940194119421943194419451946194719481949195019511952195319541955195619571958195919601961196219631964196519661967196819691970197119721973197419751976197719781979198019811982198319841985198619871988198919901991199219931994199519961997199819992000200120022003200420052006200720082009201020112012201320142015201620172018201920202021202220232024202520262027202820292030203120322033203420352036203720382039
  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: QueryResult 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_query_result.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="#friends">Friends</a> &#124;
  90. <a href="class_query_result-members.htm">List of all members</a> </div>
  91. <div class="headertitle">
  92. <div class="title">QueryResult Class Reference</div> </div>
  93. </div><!--header-->
  94. <div class="contents">
  95. <p>QSqlQuery wrapper with handy data fetch methods.
  96. <a href="class_query_result.htm#details">More...</a></p>
  97. <p><code>#include &lt;<a class="el" href="_easy_qt_sql___query_result_8h_source.htm">EasyQtSql_QueryResult.h</a>&gt;</code></p>
  98. <table class="memberdecls">
  99. <tr class="heading"><td colspan="2"><h2 class="groupheader"><a name="pub-methods"></a>
  100. Public Member Functions</h2></td></tr>
  101. <tr class="memitem:afcffce24fb54a5b94c74d304a36fc317"><td class="memItemLeft" align="right" valign="top">QSqlQuery &amp;&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_query_result.htm#afcffce24fb54a5b94c74d304a36fc317">unwrappedQuery</a> ()</td></tr>
  102. <tr class="memdesc:afcffce24fb54a5b94c74d304a36fc317"><td class="mdescLeft">&#160;</td><td class="mdescRight">Returns reference on wrapped QSqlQuery. <a href="#afcffce24fb54a5b94c74d304a36fc317">More...</a><br /></td></tr>
  103. <tr class="separator:afcffce24fb54a5b94c74d304a36fc317"><td class="memSeparator" colspan="2">&#160;</td></tr>
  104. <tr class="memitem:a1c756382c20c126979b28715d529c054"><td class="memItemLeft" align="right" valign="top">bool&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_query_result.htm#a1c756382c20c126979b28715d529c054">next</a> ()</td></tr>
  105. <tr class="memdesc:a1c756382c20c126979b28715d529c054"><td class="mdescLeft">&#160;</td><td class="mdescRight">Retrieves the next record in the result, if available, and positions the query on the retrieved record. <a href="#a1c756382c20c126979b28715d529c054">More...</a><br /></td></tr>
  106. <tr class="separator:a1c756382c20c126979b28715d529c054"><td class="memSeparator" colspan="2">&#160;</td></tr>
  107. <tr class="memitem:a9325bfaca721378e6bafa50fd7839197"><td class="memItemLeft" align="right" valign="top">bool&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_query_result.htm#a9325bfaca721378e6bafa50fd7839197">previous</a> ()</td></tr>
  108. <tr class="memdesc:a9325bfaca721378e6bafa50fd7839197"><td class="mdescLeft">&#160;</td><td class="mdescRight">Retrieves the previous record in the result, if available, and positions the query on the retrieved record. <a href="#a9325bfaca721378e6bafa50fd7839197">More...</a><br /></td></tr>
  109. <tr class="separator:a9325bfaca721378e6bafa50fd7839197"><td class="memSeparator" colspan="2">&#160;</td></tr>
  110. <tr class="memitem:a9ed922784c015b27b7fb53fafb10b391"><td class="memItemLeft" align="right" valign="top">bool&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_query_result.htm#a9ed922784c015b27b7fb53fafb10b391">nextResult</a> ()</td></tr>
  111. <tr class="memdesc:a9ed922784c015b27b7fb53fafb10b391"><td class="mdescLeft">&#160;</td><td class="mdescRight">Discards the current result set and navigates to the next if available (if database is capable of returning multiple result sets) <a href="#a9ed922784c015b27b7fb53fafb10b391">More...</a><br /></td></tr>
  112. <tr class="separator:a9ed922784c015b27b7fb53fafb10b391"><td class="memSeparator" colspan="2">&#160;</td></tr>
  113. <tr class="memitem:a406abd3501b2f3d89bf6bb7e5e8cd7c3"><td class="memItemLeft" align="right" valign="top">bool&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_query_result.htm#a406abd3501b2f3d89bf6bb7e5e8cd7c3">first</a> ()</td></tr>
  114. <tr class="memdesc:a406abd3501b2f3d89bf6bb7e5e8cd7c3"><td class="mdescLeft">&#160;</td><td class="mdescRight">Retrieves the first record in the result, if available, and positions the query on the retrieved record. <a href="#a406abd3501b2f3d89bf6bb7e5e8cd7c3">More...</a><br /></td></tr>
  115. <tr class="separator:a406abd3501b2f3d89bf6bb7e5e8cd7c3"><td class="memSeparator" colspan="2">&#160;</td></tr>
  116. <tr class="memitem:a0e5a5d108da1d03b0f624e18330a10f5"><td class="memItemLeft" align="right" valign="top">bool&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_query_result.htm#a0e5a5d108da1d03b0f624e18330a10f5">last</a> ()</td></tr>
  117. <tr class="memdesc:a0e5a5d108da1d03b0f624e18330a10f5"><td class="mdescLeft">&#160;</td><td class="mdescRight">Retrieves the last record in the result, if available, and positions the query on the retrieved record. <a href="#a0e5a5d108da1d03b0f624e18330a10f5">More...</a><br /></td></tr>
  118. <tr class="separator:a0e5a5d108da1d03b0f624e18330a10f5"><td class="memSeparator" colspan="2">&#160;</td></tr>
  119. <tr class="memitem:aff65a998f1c8be8c1dd630438a820158"><td class="memItemLeft" align="right" valign="top">bool&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_query_result.htm#aff65a998f1c8be8c1dd630438a820158">seek</a> (int index, bool relative=false)</td></tr>
  120. <tr class="memdesc:aff65a998f1c8be8c1dd630438a820158"><td class="mdescLeft">&#160;</td><td class="mdescRight">Retrieves the record at position index, if available, and positions the query on the retrieved record. <a href="#aff65a998f1c8be8c1dd630438a820158">More...</a><br /></td></tr>
  121. <tr class="separator:aff65a998f1c8be8c1dd630438a820158"><td class="memSeparator" colspan="2">&#160;</td></tr>
  122. <tr class="memitem:af49cf244de53dd4340b486990f38c553"><td class="memItemLeft" align="right" valign="top">int&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_query_result.htm#af49cf244de53dd4340b486990f38c553">at</a> () const</td></tr>
  123. <tr class="memdesc:af49cf244de53dd4340b486990f38c553"><td class="mdescLeft">&#160;</td><td class="mdescRight">Returns the current internal position of the query. The first record is at position zero. <a href="#af49cf244de53dd4340b486990f38c553">More...</a><br /></td></tr>
  124. <tr class="separator:af49cf244de53dd4340b486990f38c553"><td class="memSeparator" colspan="2">&#160;</td></tr>
  125. <tr class="memitem:a46b374177ab23d8f9d7dc9366eb57655"><td class="memItemLeft" align="right" valign="top">bool&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_query_result.htm#a46b374177ab23d8f9d7dc9366eb57655">isActive</a> () const</td></tr>
  126. <tr class="memdesc:a46b374177ab23d8f9d7dc9366eb57655"><td class="mdescLeft">&#160;</td><td class="mdescRight">Returns true if the query is active. An active QSqlQuery is one that has been exec()'d successfully but not yet finished with. <a href="#a46b374177ab23d8f9d7dc9366eb57655">More...</a><br /></td></tr>
  127. <tr class="separator:a46b374177ab23d8f9d7dc9366eb57655"><td class="memSeparator" colspan="2">&#160;</td></tr>
  128. <tr class="memitem:ae9ec64a1171aba3f7cef8b081c8158be"><td class="memItemLeft" align="right" valign="top">bool&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_query_result.htm#ae9ec64a1171aba3f7cef8b081c8158be">isValid</a> () const</td></tr>
  129. <tr class="memdesc:ae9ec64a1171aba3f7cef8b081c8158be"><td class="mdescLeft">&#160;</td><td class="mdescRight">Returns true if the query is currently positioned on a valid record; otherwise returns false. <a href="#ae9ec64a1171aba3f7cef8b081c8158be">More...</a><br /></td></tr>
  130. <tr class="separator:ae9ec64a1171aba3f7cef8b081c8158be"><td class="memSeparator" colspan="2">&#160;</td></tr>
  131. <tr class="memitem:a5b6ef75a4da642c0c467d0110ce1701a"><td class="memItemLeft" align="right" valign="top">bool&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_query_result.htm#a5b6ef75a4da642c0c467d0110ce1701a">isForwardOnly</a> () const</td></tr>
  132. <tr class="memdesc:a5b6ef75a4da642c0c467d0110ce1701a"><td class="mdescLeft">&#160;</td><td class="mdescRight">Returns true if you can only scroll forward through a result set; otherwise returns false. <a href="#a5b6ef75a4da642c0c467d0110ce1701a">More...</a><br /></td></tr>
  133. <tr class="separator:a5b6ef75a4da642c0c467d0110ce1701a"><td class="memSeparator" colspan="2">&#160;</td></tr>
  134. <tr class="memitem:ad46ba52de7f43f45c19d4b7eecabca4b"><td class="memItemLeft" align="right" valign="top">int&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_query_result.htm#ad46ba52de7f43f45c19d4b7eecabca4b">size</a> () const</td></tr>
  135. <tr class="memdesc:ad46ba52de7f43f45c19d4b7eecabca4b"><td class="mdescLeft">&#160;</td><td class="mdescRight">Returns the size of the result (number of rows returned), or -1 if the size cannot be determined or if the database does not support reporting information about query sizes. <a href="#ad46ba52de7f43f45c19d4b7eecabca4b">More...</a><br /></td></tr>
  136. <tr class="separator:ad46ba52de7f43f45c19d4b7eecabca4b"><td class="memSeparator" colspan="2">&#160;</td></tr>
  137. <tr class="memitem:a26baf17cd661ec312918f660ac9e4b1a"><td class="memItemLeft" align="right" valign="top">int&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_query_result.htm#a26baf17cd661ec312918f660ac9e4b1a">numRowsAffected</a> () const</td></tr>
  138. <tr class="memdesc:a26baf17cd661ec312918f660ac9e4b1a"><td class="mdescLeft">&#160;</td><td class="mdescRight">Returns the number of rows affected by the result's SQL statement, or -1 if it cannot be determined. <a href="#a26baf17cd661ec312918f660ac9e4b1a">More...</a><br /></td></tr>
  139. <tr class="separator:a26baf17cd661ec312918f660ac9e4b1a"><td class="memSeparator" colspan="2">&#160;</td></tr>
  140. <tr class="memitem:ac56dbe38b558a9e55591f645d50eacde"><td class="memItemLeft" align="right" valign="top">QSqlError&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_query_result.htm#ac56dbe38b558a9e55591f645d50eacde">lastError</a> () const</td></tr>
  141. <tr class="memdesc:ac56dbe38b558a9e55591f645d50eacde"><td class="mdescLeft">&#160;</td><td class="mdescRight">Returns error information about the last error (if any) that occurred with this query. <a href="#ac56dbe38b558a9e55591f645d50eacde">More...</a><br /></td></tr>
  142. <tr class="separator:ac56dbe38b558a9e55591f645d50eacde"><td class="memSeparator" colspan="2">&#160;</td></tr>
  143. <tr class="memitem:af86eb1e97db39a70d504389494e2b329"><td class="memItemLeft" align="right" valign="top">QString&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_query_result.htm#af86eb1e97db39a70d504389494e2b329">lastQuery</a> () const</td></tr>
  144. <tr class="memdesc:af86eb1e97db39a70d504389494e2b329"><td class="mdescLeft">&#160;</td><td class="mdescRight">Returns the text of the current query being used, or an empty string if there is no current query text. <a href="#af86eb1e97db39a70d504389494e2b329">More...</a><br /></td></tr>
  145. <tr class="separator:af86eb1e97db39a70d504389494e2b329"><td class="memSeparator" colspan="2">&#160;</td></tr>
  146. <tr class="memitem:abfc27e5ad56a2da113bdb804b3fd682c"><td class="memItemLeft" align="right" valign="top">QString&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_query_result.htm#abfc27e5ad56a2da113bdb804b3fd682c">executedQuery</a> () const</td></tr>
  147. <tr class="memdesc:abfc27e5ad56a2da113bdb804b3fd682c"><td class="mdescLeft">&#160;</td><td class="mdescRight">Returns the last query that was successfully executed. <a href="#abfc27e5ad56a2da113bdb804b3fd682c">More...</a><br /></td></tr>
  148. <tr class="separator:abfc27e5ad56a2da113bdb804b3fd682c"><td class="memSeparator" colspan="2">&#160;</td></tr>
  149. <tr class="memitem:a74350f3ed705c8768bd748fe942438de"><td class="memItemLeft" align="right" valign="top">QVariant&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_query_result.htm#a74350f3ed705c8768bd748fe942438de">value</a> (int column) const</td></tr>
  150. <tr class="memdesc:a74350f3ed705c8768bd748fe942438de"><td class="mdescLeft">&#160;</td><td class="mdescRight">Returns the value of field index in the current record. <a href="#a74350f3ed705c8768bd748fe942438de">More...</a><br /></td></tr>
  151. <tr class="separator:a74350f3ed705c8768bd748fe942438de"><td class="memSeparator" colspan="2">&#160;</td></tr>
  152. <tr class="memitem:a90ec24d07326aaa31e5372cfa377c985"><td class="memItemLeft" align="right" valign="top">QVariant&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_query_result.htm#a90ec24d07326aaa31e5372cfa377c985">value</a> (const QString &amp;colName) const</td></tr>
  153. <tr class="memdesc:a90ec24d07326aaa31e5372cfa377c985"><td class="mdescLeft">&#160;</td><td class="mdescRight">Returns the value of the field called name in the current record. If field name does not exist an invalid variant is returned. <a href="#a90ec24d07326aaa31e5372cfa377c985">More...</a><br /></td></tr>
  154. <tr class="separator:a90ec24d07326aaa31e5372cfa377c985"><td class="memSeparator" colspan="2">&#160;</td></tr>
  155. <tr class="memitem:ad09b4730fecad00984e32e7f3defa76e"><td class="memItemLeft" align="right" valign="top">QVariant&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_query_result.htm#ad09b4730fecad00984e32e7f3defa76e">boundValue</a> (int column) const</td></tr>
  156. <tr class="memdesc:ad09b4730fecad00984e32e7f3defa76e"><td class="mdescLeft">&#160;</td><td class="mdescRight">Returns the value for the placeholder at position column. <a href="#ad09b4730fecad00984e32e7f3defa76e">More...</a><br /></td></tr>
  157. <tr class="separator:ad09b4730fecad00984e32e7f3defa76e"><td class="memSeparator" colspan="2">&#160;</td></tr>
  158. <tr class="memitem:a9e9ea76bfa4a3770e0ea885c797b5729"><td class="memItemLeft" align="right" valign="top">QVariant&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_query_result.htm#a9e9ea76bfa4a3770e0ea885c797b5729">boundValue</a> (const QString &amp;aliasName) const</td></tr>
  159. <tr class="memdesc:a9e9ea76bfa4a3770e0ea885c797b5729"><td class="mdescLeft">&#160;</td><td class="mdescRight">Returns the value for the placeholder with aliasName. <a href="#a9e9ea76bfa4a3770e0ea885c797b5729">More...</a><br /></td></tr>
  160. <tr class="separator:a9e9ea76bfa4a3770e0ea885c797b5729"><td class="memSeparator" colspan="2">&#160;</td></tr>
  161. <tr class="memitem:a540f4948af295e336c58a6fe30e48c0b"><td class="memItemLeft" align="right" valign="top">QVariantList&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_query_result.htm#a540f4948af295e336c58a6fe30e48c0b">boundValues</a> () const</td></tr>
  162. <tr class="memdesc:a540f4948af295e336c58a6fe30e48c0b"><td class="mdescLeft">&#160;</td><td class="mdescRight">Returns list of the bound values (with positional binding) <a href="#a540f4948af295e336c58a6fe30e48c0b">More...</a><br /></td></tr>
  163. <tr class="separator:a540f4948af295e336c58a6fe30e48c0b"><td class="memSeparator" colspan="2">&#160;</td></tr>
  164. <tr class="memitem:a023bd84f7010368d616d7dbb1b399a06"><td class="memItemLeft" align="right" valign="top">QVariantMap&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_query_result.htm#a023bd84f7010368d616d7dbb1b399a06">toMap</a> () const</td></tr>
  165. <tr class="memdesc:a023bd84f7010368d616d7dbb1b399a06"><td class="mdescLeft">&#160;</td><td class="mdescRight">Returns QVariantMap filled with values fetched from current result row. Key is QString (result column name) and value is QVariant value. <a href="#a023bd84f7010368d616d7dbb1b399a06">More...</a><br /></td></tr>
  166. <tr class="separator:a023bd84f7010368d616d7dbb1b399a06"><td class="memSeparator" colspan="2">&#160;</td></tr>
  167. <tr class="memitem:aa1595196bd3fd72c9ee95c6c0a82f711"><td class="memItemLeft" align="right" valign="top">QVariantList&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_query_result.htm#aa1595196bd3fd72c9ee95c6c0a82f711">toList</a> () const</td></tr>
  168. <tr class="memdesc:aa1595196bd3fd72c9ee95c6c0a82f711"><td class="mdescLeft">&#160;</td><td class="mdescRight">Returns QVariantList filled with values fetched from current result row. <a href="#aa1595196bd3fd72c9ee95c6c0a82f711">More...</a><br /></td></tr>
  169. <tr class="separator:aa1595196bd3fd72c9ee95c6c0a82f711"><td class="memSeparator" colspan="2">&#160;</td></tr>
  170. <tr class="memitem:a6831da3d942ccf741984f72d1d2eb57d"><td class="memItemLeft" align="right" valign="top">QStringList&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_query_result.htm#a6831da3d942ccf741984f72d1d2eb57d">toStringList</a> () const</td></tr>
  171. <tr class="memdesc:a6831da3d942ccf741984f72d1d2eb57d"><td class="mdescLeft">&#160;</td><td class="mdescRight">Returns QStringList filled with values fetched from current result row. SQL values converted to QString with QVariant::toString() method. <a href="#a6831da3d942ccf741984f72d1d2eb57d">More...</a><br /></td></tr>
  172. <tr class="separator:a6831da3d942ccf741984f72d1d2eb57d"><td class="memSeparator" colspan="2">&#160;</td></tr>
  173. <tr class="memitem:a9bebffe22ed2f023ef7c9540aa9164ea"><td class="memItemLeft" align="right" valign="top">QVector&lt; QVariant &gt;&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_query_result.htm#a9bebffe22ed2f023ef7c9540aa9164ea">toVector</a> () const</td></tr>
  174. <tr class="memdesc:a9bebffe22ed2f023ef7c9540aa9164ea"><td class="mdescLeft">&#160;</td><td class="mdescRight">Returns QVector&lt;QVariant&gt; filled with values fetched from current result row. SQL values not converted: QSqlQuery::value() return value used. <a href="#a9bebffe22ed2f023ef7c9540aa9164ea">More...</a><br /></td></tr>
  175. <tr class="separator:a9bebffe22ed2f023ef7c9540aa9164ea"><td class="memSeparator" colspan="2">&#160;</td></tr>
  176. <tr class="memitem:aa4f8c874ffb9e6b1285a69322aec61ea"><td class="memTemplParams" colspan="2">template&lt;typename T &gt; </td></tr>
  177. <tr class="memitem:aa4f8c874ffb9e6b1285a69322aec61ea"><td class="memTemplItemLeft" align="right" valign="top">QVector&lt; T &gt;&#160;</td><td class="memTemplItemRight" valign="bottom"><a class="el" href="class_query_result.htm#aa4f8c874ffb9e6b1285a69322aec61ea">toVector</a> (bool skipNullValues=false) const</td></tr>
  178. <tr class="memdesc:aa4f8c874ffb9e6b1285a69322aec61ea"><td class="mdescLeft">&#160;</td><td class="mdescRight">Returns QVector&lt;T&gt; filled with values fetched from current result row. SQL values converted with QVariant::value&lt;T&gt;(). QVector::canConvert&lt;T&gt;() method used for convertability check. Non-convertable values skipped. <a href="#aa4f8c874ffb9e6b1285a69322aec61ea">More...</a><br /></td></tr>
  179. <tr class="separator:aa4f8c874ffb9e6b1285a69322aec61ea"><td class="memSeparator" colspan="2">&#160;</td></tr>
  180. <tr class="memitem:a22bd0f401bbcc203adb03b874ef2c5d8"><td class="memItemLeft" align="right" valign="top">QVector&lt; int &gt;&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_query_result.htm#a22bd0f401bbcc203adb03b874ef2c5d8">parseToIntVector</a> (int base=10, bool skipNullValues=false) const</td></tr>
  181. <tr class="memdesc:a22bd0f401bbcc203adb03b874ef2c5d8"><td class="mdescLeft">&#160;</td><td class="mdescRight">Returns vector of (optionally parsed) integer values from currently active result row. <a href="#a22bd0f401bbcc203adb03b874ef2c5d8">More...</a><br /></td></tr>
  182. <tr class="separator:a22bd0f401bbcc203adb03b874ef2c5d8"><td class="memSeparator" colspan="2">&#160;</td></tr>
  183. <tr class="memitem:a5e3b49cb821efecac406606d9e3adb13"><td class="memTemplParams" colspan="2">template&lt;typename T &gt; </td></tr>
  184. <tr class="memitem:a5e3b49cb821efecac406606d9e3adb13"><td class="memTemplItemLeft" align="right" valign="top">T&#160;</td><td class="memTemplItemRight" valign="bottom"><a class="el" href="class_query_result.htm#a5e3b49cb821efecac406606d9e3adb13">scalar</a> () const</td></tr>
  185. <tr class="memdesc:a5e3b49cb821efecac406606d9e3adb13"><td class="mdescLeft">&#160;</td><td class="mdescRight">Returns scalar value converted to type T (the value of the first column of the current row) <a href="#a5e3b49cb821efecac406606d9e3adb13">More...</a><br /></td></tr>
  186. <tr class="separator:a5e3b49cb821efecac406606d9e3adb13"><td class="memSeparator" colspan="2">&#160;</td></tr>
  187. <tr class="memitem:abd683e71de31fbcf8e74e22249597322"><td class="memItemLeft" align="right" valign="top">QVariant&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_query_result.htm#abd683e71de31fbcf8e74e22249597322">scalar</a> () const</td></tr>
  188. <tr class="memdesc:abd683e71de31fbcf8e74e22249597322"><td class="mdescLeft">&#160;</td><td class="mdescRight">Returns scalar value (the value of the first column of the current row) <a href="#abd683e71de31fbcf8e74e22249597322">More...</a><br /></td></tr>
  189. <tr class="separator:abd683e71de31fbcf8e74e22249597322"><td class="memSeparator" colspan="2">&#160;</td></tr>
  190. <tr class="memitem:a0d6642a5d017d6f99e0f5cb06d6740ca"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_query_result.htm#a0d6642a5d017d6f99e0f5cb06d6740ca">fetchVars</a> (int &amp;<a class="el" href="class_query_result.htm#a74350f3ed705c8768bd748fe942438de">value</a>) const</td></tr>
  191. <tr class="memdesc:a0d6642a5d017d6f99e0f5cb06d6740ca"><td class="mdescLeft">&#160;</td><td class="mdescRight">Assigns a variable the value from the current record. <a href="#a0d6642a5d017d6f99e0f5cb06d6740ca">More...</a><br /></td></tr>
  192. <tr class="separator:a0d6642a5d017d6f99e0f5cb06d6740ca"><td class="memSeparator" colspan="2">&#160;</td></tr>
  193. <tr class="memitem:ac77eccf0a47750e309e11e7e66bb2d8a"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_query_result.htm#ac77eccf0a47750e309e11e7e66bb2d8a">fetchVars</a> (double &amp;<a class="el" href="class_query_result.htm#a74350f3ed705c8768bd748fe942438de">value</a>) const</td></tr>
  194. <tr class="memdesc:ac77eccf0a47750e309e11e7e66bb2d8a"><td class="mdescLeft">&#160;</td><td class="mdescRight">Assigns a variable the value from the current record. <a href="#ac77eccf0a47750e309e11e7e66bb2d8a">More...</a><br /></td></tr>
  195. <tr class="separator:ac77eccf0a47750e309e11e7e66bb2d8a"><td class="memSeparator" colspan="2">&#160;</td></tr>
  196. <tr class="memitem:a1a43faec4675b58bd0506a4de7c3976f"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_query_result.htm#a1a43faec4675b58bd0506a4de7c3976f">fetchVars</a> (QString &amp;<a class="el" href="class_query_result.htm#a74350f3ed705c8768bd748fe942438de">value</a>) const</td></tr>
  197. <tr class="memdesc:a1a43faec4675b58bd0506a4de7c3976f"><td class="mdescLeft">&#160;</td><td class="mdescRight">Assigns a variable the value from the current record. <a href="#a1a43faec4675b58bd0506a4de7c3976f">More...</a><br /></td></tr>
  198. <tr class="separator:a1a43faec4675b58bd0506a4de7c3976f"><td class="memSeparator" colspan="2">&#160;</td></tr>
  199. <tr class="memitem:af49ff273eb3efd184ca423df846ba507"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_query_result.htm#af49ff273eb3efd184ca423df846ba507">fetchVars</a> (bool &amp;<a class="el" href="class_query_result.htm#a74350f3ed705c8768bd748fe942438de">value</a>) const</td></tr>
  200. <tr class="memdesc:af49ff273eb3efd184ca423df846ba507"><td class="mdescLeft">&#160;</td><td class="mdescRight">Assigns a variable the value from the current record. <a href="#af49ff273eb3efd184ca423df846ba507">More...</a><br /></td></tr>
  201. <tr class="separator:af49ff273eb3efd184ca423df846ba507"><td class="memSeparator" colspan="2">&#160;</td></tr>
  202. <tr class="memitem:a50a5fa4850f774f301ed88a488a44726"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_query_result.htm#a50a5fa4850f774f301ed88a488a44726">fetchVars</a> (QDate &amp;<a class="el" href="class_query_result.htm#a74350f3ed705c8768bd748fe942438de">value</a>) const</td></tr>
  203. <tr class="memdesc:a50a5fa4850f774f301ed88a488a44726"><td class="mdescLeft">&#160;</td><td class="mdescRight">Assigns a variable the value from the current record. <a href="#a50a5fa4850f774f301ed88a488a44726">More...</a><br /></td></tr>
  204. <tr class="separator:a50a5fa4850f774f301ed88a488a44726"><td class="memSeparator" colspan="2">&#160;</td></tr>
  205. <tr class="memitem:a91d15081bc1d6eccefe089f4948438cb"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_query_result.htm#a91d15081bc1d6eccefe089f4948438cb">fetchVars</a> (QDateTime &amp;<a class="el" href="class_query_result.htm#a74350f3ed705c8768bd748fe942438de">value</a>) const</td></tr>
  206. <tr class="memdesc:a91d15081bc1d6eccefe089f4948438cb"><td class="mdescLeft">&#160;</td><td class="mdescRight">Assigns a variable the value from the current record. <a href="#a91d15081bc1d6eccefe089f4948438cb">More...</a><br /></td></tr>
  207. <tr class="separator:a91d15081bc1d6eccefe089f4948438cb"><td class="memSeparator" colspan="2">&#160;</td></tr>
  208. <tr class="memitem:af2870c71cd1b750c8151a7b4420903fa"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_query_result.htm#af2870c71cd1b750c8151a7b4420903fa">fetchVars</a> (QTime &amp;<a class="el" href="class_query_result.htm#a74350f3ed705c8768bd748fe942438de">value</a>) const</td></tr>
  209. <tr class="memdesc:af2870c71cd1b750c8151a7b4420903fa"><td class="mdescLeft">&#160;</td><td class="mdescRight">Assigns a variable the value from the current record. <a href="#af2870c71cd1b750c8151a7b4420903fa">More...</a><br /></td></tr>
  210. <tr class="separator:af2870c71cd1b750c8151a7b4420903fa"><td class="memSeparator" colspan="2">&#160;</td></tr>
  211. <tr class="memitem:aaeb262416e472885dc6a3c7c3c7c3306"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_query_result.htm#aaeb262416e472885dc6a3c7c3c7c3306">fetchVars</a> (QByteArray &amp;<a class="el" href="class_query_result.htm#a74350f3ed705c8768bd748fe942438de">value</a>) const</td></tr>
  212. <tr class="memdesc:aaeb262416e472885dc6a3c7c3c7c3306"><td class="mdescLeft">&#160;</td><td class="mdescRight">Assigns a variable the value from the current record. <a href="#aaeb262416e472885dc6a3c7c3c7c3306">More...</a><br /></td></tr>
  213. <tr class="separator:aaeb262416e472885dc6a3c7c3c7c3306"><td class="memSeparator" colspan="2">&#160;</td></tr>
  214. <tr class="memitem:a8c17bed4e4380137912a2baba19e5a30"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_query_result.htm#a8c17bed4e4380137912a2baba19e5a30">fetchVars</a> (QVariant &amp;<a class="el" href="class_query_result.htm#a74350f3ed705c8768bd748fe942438de">value</a>) const</td></tr>
  215. <tr class="memdesc:a8c17bed4e4380137912a2baba19e5a30"><td class="mdescLeft">&#160;</td><td class="mdescRight">Assigns a variable the value from the current record. <a href="#a8c17bed4e4380137912a2baba19e5a30">More...</a><br /></td></tr>
  216. <tr class="separator:a8c17bed4e4380137912a2baba19e5a30"><td class="memSeparator" colspan="2">&#160;</td></tr>
  217. <tr class="memitem:a5421dce74a177933675ede65a68972a0"><td class="memTemplParams" colspan="2">template&lt;typename... Rest&gt; </td></tr>
  218. <tr class="memitem:a5421dce74a177933675ede65a68972a0"><td class="memTemplItemLeft" align="right" valign="top">void&#160;</td><td class="memTemplItemRight" valign="bottom"><a class="el" href="class_query_result.htm#a5421dce74a177933675ede65a68972a0">fetchVars</a> (int &amp;<a class="el" href="class_query_result.htm#a74350f3ed705c8768bd748fe942438de">value</a>, Rest &amp;... rest) const</td></tr>
  219. <tr class="separator:a5421dce74a177933675ede65a68972a0"><td class="memSeparator" colspan="2">&#160;</td></tr>
  220. <tr class="memitem:a0b82a02ab7a45f1092e93d56a87dc67b"><td class="memTemplParams" colspan="2">template&lt;typename... Rest&gt; </td></tr>
  221. <tr class="memitem:a0b82a02ab7a45f1092e93d56a87dc67b"><td class="memTemplItemLeft" align="right" valign="top">void&#160;</td><td class="memTemplItemRight" valign="bottom"><a class="el" href="class_query_result.htm#a0b82a02ab7a45f1092e93d56a87dc67b">fetchVars</a> (double &amp;<a class="el" href="class_query_result.htm#a74350f3ed705c8768bd748fe942438de">value</a>, Rest &amp;... rest) const</td></tr>
  222. <tr class="separator:a0b82a02ab7a45f1092e93d56a87dc67b"><td class="memSeparator" colspan="2">&#160;</td></tr>
  223. <tr class="memitem:acf30d6c095e00eb7b1bc942563597d4b"><td class="memTemplParams" colspan="2">template&lt;typename... Rest&gt; </td></tr>
  224. <tr class="memitem:acf30d6c095e00eb7b1bc942563597d4b"><td class="memTemplItemLeft" align="right" valign="top">void&#160;</td><td class="memTemplItemRight" valign="bottom"><a class="el" href="class_query_result.htm#acf30d6c095e00eb7b1bc942563597d4b">fetchVars</a> (QString &amp;<a class="el" href="class_query_result.htm#a74350f3ed705c8768bd748fe942438de">value</a>, Rest &amp;... rest) const</td></tr>
  225. <tr class="separator:acf30d6c095e00eb7b1bc942563597d4b"><td class="memSeparator" colspan="2">&#160;</td></tr>
  226. <tr class="memitem:aa62c42135a62658a7e56426a024d0146"><td class="memTemplParams" colspan="2">template&lt;typename... Rest&gt; </td></tr>
  227. <tr class="memitem:aa62c42135a62658a7e56426a024d0146"><td class="memTemplItemLeft" align="right" valign="top">void&#160;</td><td class="memTemplItemRight" valign="bottom"><a class="el" href="class_query_result.htm#aa62c42135a62658a7e56426a024d0146">fetchVars</a> (bool &amp;<a class="el" href="class_query_result.htm#a74350f3ed705c8768bd748fe942438de">value</a>, Rest &amp;... rest) const</td></tr>
  228. <tr class="separator:aa62c42135a62658a7e56426a024d0146"><td class="memSeparator" colspan="2">&#160;</td></tr>
  229. <tr class="memitem:aadabff776f939dd7c3895318396ae59e"><td class="memTemplParams" colspan="2">template&lt;typename... Rest&gt; </td></tr>
  230. <tr class="memitem:aadabff776f939dd7c3895318396ae59e"><td class="memTemplItemLeft" align="right" valign="top">void&#160;</td><td class="memTemplItemRight" valign="bottom"><a class="el" href="class_query_result.htm#aadabff776f939dd7c3895318396ae59e">fetchVars</a> (QDate &amp;<a class="el" href="class_query_result.htm#a74350f3ed705c8768bd748fe942438de">value</a>, Rest &amp;... rest) const</td></tr>
  231. <tr class="separator:aadabff776f939dd7c3895318396ae59e"><td class="memSeparator" colspan="2">&#160;</td></tr>
  232. <tr class="memitem:aab68396b876b689f21109301cf350ee3"><td class="memTemplParams" colspan="2">template&lt;typename... Rest&gt; </td></tr>
  233. <tr class="memitem:aab68396b876b689f21109301cf350ee3"><td class="memTemplItemLeft" align="right" valign="top">void&#160;</td><td class="memTemplItemRight" valign="bottom"><a class="el" href="class_query_result.htm#aab68396b876b689f21109301cf350ee3">fetchVars</a> (QDateTime &amp;<a class="el" href="class_query_result.htm#a74350f3ed705c8768bd748fe942438de">value</a>, Rest &amp;... rest) const</td></tr>
  234. <tr class="separator:aab68396b876b689f21109301cf350ee3"><td class="memSeparator" colspan="2">&#160;</td></tr>
  235. <tr class="memitem:a462dc42f451155eca3b56b9239cf8535"><td class="memTemplParams" colspan="2">template&lt;typename... Rest&gt; </td></tr>
  236. <tr class="memitem:a462dc42f451155eca3b56b9239cf8535"><td class="memTemplItemLeft" align="right" valign="top">void&#160;</td><td class="memTemplItemRight" valign="bottom"><a class="el" href="class_query_result.htm#a462dc42f451155eca3b56b9239cf8535">fetchVars</a> (QTime &amp;<a class="el" href="class_query_result.htm#a74350f3ed705c8768bd748fe942438de">value</a>, Rest &amp;... rest) const</td></tr>
  237. <tr class="separator:a462dc42f451155eca3b56b9239cf8535"><td class="memSeparator" colspan="2">&#160;</td></tr>
  238. <tr class="memitem:a5efedd7a6e170ddeaddbac5428951085"><td class="memTemplParams" colspan="2">template&lt;typename... Rest&gt; </td></tr>
  239. <tr class="memitem:a5efedd7a6e170ddeaddbac5428951085"><td class="memTemplItemLeft" align="right" valign="top">void&#160;</td><td class="memTemplItemRight" valign="bottom"><a class="el" href="class_query_result.htm#a5efedd7a6e170ddeaddbac5428951085">fetchVars</a> (QByteArray &amp;<a class="el" href="class_query_result.htm#a74350f3ed705c8768bd748fe942438de">value</a>, Rest &amp;... rest) const</td></tr>
  240. <tr class="separator:a5efedd7a6e170ddeaddbac5428951085"><td class="memSeparator" colspan="2">&#160;</td></tr>
  241. <tr class="memitem:a0a381517b5fa64a68e4d10972b0ceefc"><td class="memTemplParams" colspan="2">template&lt;typename... Rest&gt; </td></tr>
  242. <tr class="memitem:a0a381517b5fa64a68e4d10972b0ceefc"><td class="memTemplItemLeft" align="right" valign="top">void&#160;</td><td class="memTemplItemRight" valign="bottom"><a class="el" href="class_query_result.htm#a0a381517b5fa64a68e4d10972b0ceefc">fetchVars</a> (QVariant &amp;<a class="el" href="class_query_result.htm#a74350f3ed705c8768bd748fe942438de">value</a>, Rest &amp;... rest) const</td></tr>
  243. <tr class="separator:a0a381517b5fa64a68e4d10972b0ceefc"><td class="memSeparator" colspan="2">&#160;</td></tr>
  244. <tr class="memitem:a79a40fde15ca3ceaa4f0c7b8ba649558"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_query_result.htm#a79a40fde15ca3ceaa4f0c7b8ba649558">fetchObject</a> (QObject &amp;object) const</td></tr>
  245. <tr class="memdesc:a79a40fde15ca3ceaa4f0c7b8ba649558"><td class="mdescLeft">&#160;</td><td class="mdescRight">Fills Q_OBJECT object properties with data fetched from current result row. <a href="#a79a40fde15ca3ceaa4f0c7b8ba649558">More...</a><br /></td></tr>
  246. <tr class="separator:a79a40fde15ca3ceaa4f0c7b8ba649558"><td class="memSeparator" colspan="2">&#160;</td></tr>
  247. <tr class="memitem:a53a94d8a3a9ca6916716d79b5fb48837"><td class="memTemplParams" colspan="2">template&lt;typename T &gt; </td></tr>
  248. <tr class="memitem:a53a94d8a3a9ca6916716d79b5fb48837"><td class="memTemplItemLeft" align="right" valign="top">void&#160;</td><td class="memTemplItemRight" valign="bottom"><a class="el" href="class_query_result.htm#a53a94d8a3a9ca6916716d79b5fb48837">fetchGadget</a> (T &amp;gadget) const</td></tr>
  249. <tr class="memdesc:a53a94d8a3a9ca6916716d79b5fb48837"><td class="mdescLeft">&#160;</td><td class="mdescRight">Fills Q_GADGET object properties with data fetched from current result row. <a href="#a53a94d8a3a9ca6916716d79b5fb48837">More...</a><br /></td></tr>
  250. <tr class="separator:a53a94d8a3a9ca6916716d79b5fb48837"><td class="memSeparator" colspan="2">&#160;</td></tr>
  251. <tr class="memitem:a0f79c838a9fcd4a5d48e61abc79612e9"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_query_result.htm#a0f79c838a9fcd4a5d48e61abc79612e9">fetchMap</a> (QVariantMap &amp;map) const</td></tr>
  252. <tr class="memdesc:a0f79c838a9fcd4a5d48e61abc79612e9"><td class="mdescLeft">&#160;</td><td class="mdescRight">Fills QVariantMap with values fetched from current result row. Key is QString (result column name) and value is QVariant value. <a href="#a0f79c838a9fcd4a5d48e61abc79612e9">More...</a><br /></td></tr>
  253. <tr class="separator:a0f79c838a9fcd4a5d48e61abc79612e9"><td class="memSeparator" colspan="2">&#160;</td></tr>
  254. <tr class="memitem:af62abbe3a59c25163c90e4a5fec632c7"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_query_result.htm#af62abbe3a59c25163c90e4a5fec632c7">fetchList</a> (QVariantList &amp;list) const</td></tr>
  255. <tr class="memdesc:af62abbe3a59c25163c90e4a5fec632c7"><td class="mdescLeft">&#160;</td><td class="mdescRight">Fills QVariantList with values fetched from current result row. SQL values not converted: QSqlQuery::value() return value used. <a href="#af62abbe3a59c25163c90e4a5fec632c7">More...</a><br /></td></tr>
  256. <tr class="separator:af62abbe3a59c25163c90e4a5fec632c7"><td class="memSeparator" colspan="2">&#160;</td></tr>
  257. <tr class="memitem:ad111370ab183d4d6a1522123c03f183d"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_query_result.htm#ad111370ab183d4d6a1522123c03f183d">fetchVector</a> (QVector&lt; QVariant &gt; &amp;vector) const</td></tr>
  258. <tr class="memdesc:ad111370ab183d4d6a1522123c03f183d"><td class="mdescLeft">&#160;</td><td class="mdescRight">Fills QVector&lt;QVariant&gt; with values fetched from current result row. SQL values not converted: QSqlQuery::value() return value used. <a href="#ad111370ab183d4d6a1522123c03f183d">More...</a><br /></td></tr>
  259. <tr class="separator:ad111370ab183d4d6a1522123c03f183d"><td class="memSeparator" colspan="2">&#160;</td></tr>
  260. <tr class="memitem:af49aaa8a26876c7a095326c8b2d5ba6a"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_query_result.htm#af49aaa8a26876c7a095326c8b2d5ba6a">fetchStringList</a> (QStringList &amp;list) const</td></tr>
  261. <tr class="memdesc:af49aaa8a26876c7a095326c8b2d5ba6a"><td class="mdescLeft">&#160;</td><td class="mdescRight">Fills QStringList with values fetched from current result row. SQL values converted to QString with QVariant::toString() method. <a href="#af49aaa8a26876c7a095326c8b2d5ba6a">More...</a><br /></td></tr>
  262. <tr class="separator:af49aaa8a26876c7a095326c8b2d5ba6a"><td class="memSeparator" colspan="2">&#160;</td></tr>
  263. </table><table class="memberdecls">
  264. <tr class="heading"><td colspan="2"><h2 class="groupheader"><a name="friends"></a>
  265. Friends</h2></td></tr>
  266. <tr class="memitem:a6efef52d7a939622bbc934ff6b90ffe0"><td class="memItemLeft" align="right" valign="top">class&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_query_result.htm#a6efef52d7a939622bbc934ff6b90ffe0">Database</a></td></tr>
  267. <tr class="separator:a6efef52d7a939622bbc934ff6b90ffe0"><td class="memSeparator" colspan="2">&#160;</td></tr>
  268. <tr class="memitem:a49982aa325e19f0956d42fde9132caa2"><td class="memItemLeft" align="right" valign="top">class&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_query_result.htm#a49982aa325e19f0956d42fde9132caa2">Transaction</a></td></tr>
  269. <tr class="separator:a49982aa325e19f0956d42fde9132caa2"><td class="memSeparator" colspan="2">&#160;</td></tr>
  270. <tr class="memitem:a86948d67f912f2e3e6d1a2674cd0814e"><td class="memItemLeft" align="right" valign="top">class&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_query_result.htm#a86948d67f912f2e3e6d1a2674cd0814e">PreparedQuery</a></td></tr>
  271. <tr class="separator:a86948d67f912f2e3e6d1a2674cd0814e"><td class="memSeparator" colspan="2">&#160;</td></tr>
  272. </table>
  273. <a name="details" id="details"></a><h2 class="groupheader">Detailed Description</h2>
  274. <div class="textblock"><p>QSqlQuery wrapper with handy data fetch methods. </p>
  275. </div><h2 class="groupheader">Member Function Documentation</h2>
  276. <a id="af49cf244de53dd4340b486990f38c553"></a>
  277. <h2 class="memtitle"><span class="permalink"><a href="#af49cf244de53dd4340b486990f38c553">&#9670;&nbsp;</a></span>at()</h2>
  278. <div class="memitem">
  279. <div class="memproto">
  280. <table class="mlabels">
  281. <tr>
  282. <td class="mlabels-left">
  283. <table class="memname">
  284. <tr>
  285. <td class="memname">int QueryResult::at </td>
  286. <td>(</td>
  287. <td class="paramname"></td><td>)</td>
  288. <td> const</td>
  289. </tr>
  290. </table>
  291. </td>
  292. <td class="mlabels-right">
  293. <span class="mlabels"><span class="mlabel">inline</span></span> </td>
  294. </tr>
  295. </table>
  296. </div><div class="memdoc">
  297. <p>Returns the current internal position of the query. The first record is at position zero. </p>
  298. <dl class="section return"><dt>Returns</dt><dd>If the position is invalid, the function returns QSql::BeforeFirstRow or QSql::AfterLastRow, which are special negative values.</dd></dl>
  299. <p>Wrapper over QSqlQuery::at() </p>
  300. </div>
  301. </div>
  302. <a id="ad09b4730fecad00984e32e7f3defa76e"></a>
  303. <h2 class="memtitle"><span class="permalink"><a href="#ad09b4730fecad00984e32e7f3defa76e">&#9670;&nbsp;</a></span>boundValue() <span class="overload">[1/2]</span></h2>
  304. <div class="memitem">
  305. <div class="memproto">
  306. <table class="mlabels">
  307. <tr>
  308. <td class="mlabels-left">
  309. <table class="memname">
  310. <tr>
  311. <td class="memname">QVariant QueryResult::boundValue </td>
  312. <td>(</td>
  313. <td class="paramtype">int&#160;</td>
  314. <td class="paramname"><em>column</em></td><td>)</td>
  315. <td> const</td>
  316. </tr>
  317. </table>
  318. </td>
  319. <td class="mlabels-right">
  320. <span class="mlabels"><span class="mlabel">inline</span></span> </td>
  321. </tr>
  322. </table>
  323. </div><div class="memdoc">
  324. <p>Returns the value for the placeholder at position column. </p>
  325. <p>Wrapper over QSqlQuery::boundValue() </p>
  326. </div>
  327. </div>
  328. <a id="a9e9ea76bfa4a3770e0ea885c797b5729"></a>
  329. <h2 class="memtitle"><span class="permalink"><a href="#a9e9ea76bfa4a3770e0ea885c797b5729">&#9670;&nbsp;</a></span>boundValue() <span class="overload">[2/2]</span></h2>
  330. <div class="memitem">
  331. <div class="memproto">
  332. <table class="mlabels">
  333. <tr>
  334. <td class="mlabels-left">
  335. <table class="memname">
  336. <tr>
  337. <td class="memname">QVariant QueryResult::boundValue </td>
  338. <td>(</td>
  339. <td class="paramtype">const QString &amp;&#160;</td>
  340. <td class="paramname"><em>aliasName</em></td><td>)</td>
  341. <td> const</td>
  342. </tr>
  343. </table>
  344. </td>
  345. <td class="mlabels-right">
  346. <span class="mlabels"><span class="mlabel">inline</span></span> </td>
  347. </tr>
  348. </table>
  349. </div><div class="memdoc">
  350. <p>Returns the value for the placeholder with aliasName. </p>
  351. <p>Use subclasses of <a class="el" href="struct_param_direction_wrapper.htm" title="Base parameters wrapper struct. ">ParamDirectionWrapper</a> class (<a class="el" href="struct_in.htm" title="Input SQL parameters wrapper. ">In</a>, <a class="el" href="struct_out.htm" title="Output SQL parameters wrapper. ">Out</a>, <a class="el" href="struct_in_out.htm" title="Bidirectional SQL parameters wrapper. ">InOut</a>) for aliased/directional parameter binding during <a class="el" href="class_prepared_query.htm#a1013aea1638d6d04868ce39130bc1b67">PreparedQuery::exec</a> execution</p>
  352. <p>Use <a class="el" href="struct_out.htm" title="Output SQL parameters wrapper. ">Out</a> and <a class="el" href="struct_in_out.htm" title="Bidirectional SQL parameters wrapper. ">InOut</a> wrappers if you need to read Stored Procedures return values (output parameters).</p>
  353. <dl class="section see"><dt>See also</dt><dd><a class="el" href="struct_in.htm" title="Input SQL parameters wrapper. ">In</a>, <a class="el" href="struct_out.htm" title="Output SQL parameters wrapper. ">Out</a>, <a class="el" href="struct_in_out.htm" title="Bidirectional SQL parameters wrapper. ">InOut</a>, <a class="el" href="class_prepared_query.htm#a1013aea1638d6d04868ce39130bc1b67">PreparedQuery::exec</a> </dd></dl>
  354. </div>
  355. </div>
  356. <a id="a540f4948af295e336c58a6fe30e48c0b"></a>
  357. <h2 class="memtitle"><span class="permalink"><a href="#a540f4948af295e336c58a6fe30e48c0b">&#9670;&nbsp;</a></span>boundValues()</h2>
  358. <div class="memitem">
  359. <div class="memproto">
  360. <table class="mlabels">
  361. <tr>
  362. <td class="mlabels-left">
  363. <table class="memname">
  364. <tr>
  365. <td class="memname">QVariantList QueryResult::boundValues </td>
  366. <td>(</td>
  367. <td class="paramname"></td><td>)</td>
  368. <td> const</td>
  369. </tr>
  370. </table>
  371. </td>
  372. <td class="mlabels-right">
  373. <span class="mlabels"><span class="mlabel">inline</span></span> </td>
  374. </tr>
  375. </table>
  376. </div><div class="memdoc">
  377. <p>Returns list of the bound values (with positional binding) </p>
  378. <p>Wrapper over QSqlQuery::boundValues() </p>
  379. </div>
  380. </div>
  381. <a id="abfc27e5ad56a2da113bdb804b3fd682c"></a>
  382. <h2 class="memtitle"><span class="permalink"><a href="#abfc27e5ad56a2da113bdb804b3fd682c">&#9670;&nbsp;</a></span>executedQuery()</h2>
  383. <div class="memitem">
  384. <div class="memproto">
  385. <table class="mlabels">
  386. <tr>
  387. <td class="mlabels-left">
  388. <table class="memname">
  389. <tr>
  390. <td class="memname">QString QueryResult::executedQuery </td>
  391. <td>(</td>
  392. <td class="paramname"></td><td>)</td>
  393. <td> const</td>
  394. </tr>
  395. </table>
  396. </td>
  397. <td class="mlabels-right">
  398. <span class="mlabels"><span class="mlabel">inline</span></span> </td>
  399. </tr>
  400. </table>
  401. </div><div class="memdoc">
  402. <p>Returns the last query that was successfully executed. </p>
  403. <p>Wrapper over QSqlQuery::executedQuery() </p>
  404. </div>
  405. </div>
  406. <a id="a53a94d8a3a9ca6916716d79b5fb48837"></a>
  407. <h2 class="memtitle"><span class="permalink"><a href="#a53a94d8a3a9ca6916716d79b5fb48837">&#9670;&nbsp;</a></span>fetchGadget()</h2>
  408. <div class="memitem">
  409. <div class="memproto">
  410. <div class="memtemplate">
  411. template&lt;typename T &gt; </div>
  412. <table class="mlabels">
  413. <tr>
  414. <td class="mlabels-left">
  415. <table class="memname">
  416. <tr>
  417. <td class="memname">void QueryResult::fetchGadget </td>
  418. <td>(</td>
  419. <td class="paramtype">T &amp;&#160;</td>
  420. <td class="paramname"><em>gadget</em></td><td>)</td>
  421. <td> const</td>
  422. </tr>
  423. </table>
  424. </td>
  425. <td class="mlabels-right">
  426. <span class="mlabels"><span class="mlabel">inline</span></span> </td>
  427. </tr>
  428. </table>
  429. </div><div class="memdoc">
  430. <p>Fills Q_GADGET object properties with data fetched from current result row. </p>
  431. <p>Qt Meta-Object System used. Only writable properties can be filled.</p>
  432. <p>C++ struct fields will be mapped on SQL result table by Q_PROPERTY member names. For example, if Q_GADGET struct contains Q_PROPERTY named "e" but SELECT query defines no "e" column, object property "e" not affected by the method.</p>
  433. <div class="fragment"><div class="line"><span class="keyword">struct </span>Row</div><div class="line">{</div><div class="line"> <span class="keywordtype">int</span> a;</div><div class="line"> <span class="keywordtype">int</span> b;</div><div class="line"> <span class="keywordtype">int</span> c;</div><div class="line"> QString d;</div><div class="line"> <span class="keywordtype">int</span> e;</div><div class="line"></div><div class="line"><span class="keyword">private</span>:</div><div class="line"> Q_GADGET</div><div class="line"></div><div class="line"> <span class="comment">//property &quot;a&quot; will be filled with &quot;a&quot; column of the Select SQL query result</span></div><div class="line"> Q_PROPERTY(<span class="keywordtype">int</span> a MEMBER a)</div><div class="line"> Q_PROPERTY(<span class="keywordtype">int</span> b MEMBER b)</div><div class="line"> Q_PROPERTY(<span class="keywordtype">int</span> c MEMBER c)</div><div class="line"> Q_PROPERTY(QString d MEMBER d)</div><div class="line"></div><div class="line"> <span class="comment">//property e will be ignored in the example because there is no e field in the Select SQL query result</span></div><div class="line"> Q_PROPERTY(<span class="keywordtype">int</span> e MEMBER e)</div><div class="line">};</div><div class="line"></div><div class="line"><span class="keywordtype">void</span> test()</div><div class="line">{</div><div class="line"> <a class="code" href="class_transaction.htm">Transaction</a> t;</div><div class="line"> <a class="code" href="class_query_result.htm">QueryResult</a> res = t.<a class="code" href="class_database.htm#a05c1ac255cdba9781f8bf306801bca70">execQuery</a>(<span class="stringliteral">&quot;SELECT a, b, c, d FROM table&quot;</span>);</div><div class="line"></div><div class="line"> <span class="keywordflow">while</span> (res.<a class="code" href="class_query_result.htm#a1c756382c20c126979b28715d529c054">next</a>())</div><div class="line"> {</div><div class="line"> <span class="comment">//Row instance (Q_GADGET structure)</span></div><div class="line"> Row testRow;</div><div class="line"></div><div class="line"> <span class="comment">//fetch testRow from current result row, properties a, b, c, d will be filled here:</span></div><div class="line"> res.<a class="code" href="class_query_result.htm#a53a94d8a3a9ca6916716d79b5fb48837">fetchGadget</a>(testRow);</div><div class="line"> }</div><div class="line">}</div></div><!-- fragment --><dl class="params"><dt>Parameters</dt><dd>
  434. <table class="params">
  435. <tr><td class="paramname">gadget</td><td>Q_GADGET reference </td></tr>
  436. </table>
  437. </dd>
  438. </dl>
  439. </div>
  440. </div>
  441. <a id="af62abbe3a59c25163c90e4a5fec632c7"></a>
  442. <h2 class="memtitle"><span class="permalink"><a href="#af62abbe3a59c25163c90e4a5fec632c7">&#9670;&nbsp;</a></span>fetchList()</h2>
  443. <div class="memitem">
  444. <div class="memproto">
  445. <table class="mlabels">
  446. <tr>
  447. <td class="mlabels-left">
  448. <table class="memname">
  449. <tr>
  450. <td class="memname">void QueryResult::fetchList </td>
  451. <td>(</td>
  452. <td class="paramtype">QVariantList &amp;&#160;</td>
  453. <td class="paramname"><em>list</em></td><td>)</td>
  454. <td> const</td>
  455. </tr>
  456. </table>
  457. </td>
  458. <td class="mlabels-right">
  459. <span class="mlabels"><span class="mlabel">inline</span></span> </td>
  460. </tr>
  461. </table>
  462. </div><div class="memdoc">
  463. <p>Fills QVariantList with values fetched from current result row. SQL values not converted: QSqlQuery::value() return value used. </p>
  464. <dl class="params"><dt>Parameters</dt><dd>
  465. <table class="params">
  466. <tr><td class="paramdir">[out]</td><td class="paramname">list</td><td>QVariantList </td></tr>
  467. </table>
  468. </dd>
  469. </dl>
  470. <dl class="section see"><dt>See also</dt><dd><a class="el" href="class_query_result.htm#aa1595196bd3fd72c9ee95c6c0a82f711" title="Returns QVariantList filled with values fetched from current result row. ">QueryResult::toList</a> </dd></dl>
  471. </div>
  472. </div>
  473. <a id="a0f79c838a9fcd4a5d48e61abc79612e9"></a>
  474. <h2 class="memtitle"><span class="permalink"><a href="#a0f79c838a9fcd4a5d48e61abc79612e9">&#9670;&nbsp;</a></span>fetchMap()</h2>
  475. <div class="memitem">
  476. <div class="memproto">
  477. <table class="mlabels">
  478. <tr>
  479. <td class="mlabels-left">
  480. <table class="memname">
  481. <tr>
  482. <td class="memname">void QueryResult::fetchMap </td>
  483. <td>(</td>
  484. <td class="paramtype">QVariantMap &amp;&#160;</td>
  485. <td class="paramname"><em>map</em></td><td>)</td>
  486. <td> const</td>
  487. </tr>
  488. </table>
  489. </td>
  490. <td class="mlabels-right">
  491. <span class="mlabels"><span class="mlabel">inline</span></span> </td>
  492. </tr>
  493. </table>
  494. </div><div class="memdoc">
  495. <p>Fills QVariantMap with values fetched from current result row. Key is QString (result column name) and value is QVariant value. </p>
  496. <dl class="params"><dt>Parameters</dt><dd>
  497. <table class="params">
  498. <tr><td class="paramdir">[out]</td><td class="paramname">map</td><td>QVariantMap </td></tr>
  499. </table>
  500. </dd>
  501. </dl>
  502. <dl class="section see"><dt>See also</dt><dd><a class="el" href="class_query_result.htm#a023bd84f7010368d616d7dbb1b399a06" title="Returns QVariantMap filled with values fetched from current result row. Key is QString (result column...">QueryResult::toMap</a> </dd></dl>
  503. </div>
  504. </div>
  505. <a id="a79a40fde15ca3ceaa4f0c7b8ba649558"></a>
  506. <h2 class="memtitle"><span class="permalink"><a href="#a79a40fde15ca3ceaa4f0c7b8ba649558">&#9670;&nbsp;</a></span>fetchObject()</h2>
  507. <div class="memitem">
  508. <div class="memproto">
  509. <table class="mlabels">
  510. <tr>
  511. <td class="mlabels-left">
  512. <table class="memname">
  513. <tr>
  514. <td class="memname">void QueryResult::fetchObject </td>
  515. <td>(</td>
  516. <td class="paramtype">QObject &amp;&#160;</td>
  517. <td class="paramname"><em>object</em></td><td>)</td>
  518. <td> const</td>
  519. </tr>
  520. </table>
  521. </td>
  522. <td class="mlabels-right">
  523. <span class="mlabels"><span class="mlabel">inline</span></span> </td>
  524. </tr>
  525. </table>
  526. </div><div class="memdoc">
  527. <p>Fills Q_OBJECT object properties with data fetched from current result row. </p>
  528. <p>Qt Meta-Object System used. Only writable properties can be filled.</p>
  529. <p>C++ class fields (properties) will be mapped on SQL result table by Q_PROPERTY member names. For example, if Q_OBJECT class contains Q_PROPERTY named "e" but SELECT query defines no "e" column, object property "e" not affected by the method.</p>
  530. <div class="fragment"><div class="line"><span class="keyword">class </span>TestObject : <span class="keyword">public</span> QObject</div><div class="line">{</div><div class="line"> Q_OBJECT</div><div class="line"></div><div class="line"> <span class="comment">//property &quot;a&quot; will be filled with &quot;a&quot; column of the Select SQL query result</span></div><div class="line"> Q_PROPERTY(<span class="keywordtype">int</span> a MEMBER a)</div><div class="line"> Q_PROPERTY(<span class="keywordtype">int</span> b MEMBER b)</div><div class="line"> Q_PROPERTY(<span class="keywordtype">int</span> c MEMBER c)</div><div class="line"> Q_PROPERTY(QString d MEMBER d)</div><div class="line"></div><div class="line"> <span class="comment">//property e will be ignored in the example because there is no e field in the Select SQL query result</span></div><div class="line"> Q_PROPERTY(<span class="keywordtype">int</span> e MEMBER e)</div><div class="line"></div><div class="line"><span class="keyword">private</span>:</div><div class="line"> <span class="keywordtype">int</span> a;</div><div class="line"> <span class="keywordtype">int</span> b;</div><div class="line"> <span class="keywordtype">int</span> c;</div><div class="line"> QString d;</div><div class="line"> <span class="keywordtype">int</span> e;</div><div class="line">};</div><div class="line"></div><div class="line"><span class="keywordtype">void</span> test()</div><div class="line">{</div><div class="line"> <a class="code" href="class_transaction.htm">Transaction</a> t;</div><div class="line"> <a class="code" href="class_query_result.htm">QueryResult</a> res = t.<a class="code" href="class_database.htm#a05c1ac255cdba9781f8bf306801bca70">execQuery</a>(<span class="stringliteral">&quot;SELECT a, b, c, d FROM table&quot;</span>);</div><div class="line"></div><div class="line"> <span class="keywordflow">while</span> (res.<a class="code" href="class_query_result.htm#a1c756382c20c126979b28715d529c054">next</a>())</div><div class="line"> {</div><div class="line"> <span class="comment">//TestObject instance (Q_OBJECT class)</span></div><div class="line"> TestObject testRow;</div><div class="line"> res.<a class="code" href="class_query_result.htm#a79a40fde15ca3ceaa4f0c7b8ba649558">fetchObject</a>(testRow);</div><div class="line"> }</div><div class="line">}</div></div><!-- fragment --><dl class="params"><dt>Parameters</dt><dd>
  531. <table class="params">
  532. <tr><td class="paramname">object</td><td>Q_OBJECT object reference </td></tr>
  533. </table>
  534. </dd>
  535. </dl>
  536. </div>
  537. </div>
  538. <a id="af49aaa8a26876c7a095326c8b2d5ba6a"></a>
  539. <h2 class="memtitle"><span class="permalink"><a href="#af49aaa8a26876c7a095326c8b2d5ba6a">&#9670;&nbsp;</a></span>fetchStringList()</h2>
  540. <div class="memitem">
  541. <div class="memproto">
  542. <table class="mlabels">
  543. <tr>
  544. <td class="mlabels-left">
  545. <table class="memname">
  546. <tr>
  547. <td class="memname">void QueryResult::fetchStringList </td>
  548. <td>(</td>
  549. <td class="paramtype">QStringList &amp;&#160;</td>
  550. <td class="paramname"><em>list</em></td><td>)</td>
  551. <td> const</td>
  552. </tr>
  553. </table>
  554. </td>
  555. <td class="mlabels-right">
  556. <span class="mlabels"><span class="mlabel">inline</span></span> </td>
  557. </tr>
  558. </table>
  559. </div><div class="memdoc">
  560. <p>Fills QStringList with values fetched from current result row. SQL values converted to QString with QVariant::toString() method. </p>
  561. <dl class="params"><dt>Parameters</dt><dd>
  562. <table class="params">
  563. <tr><td class="paramdir">[out]</td><td class="paramname">list</td><td>QStringList </td></tr>
  564. </table>
  565. </dd>
  566. </dl>
  567. <dl class="section see"><dt>See also</dt><dd><a class="el" href="class_query_result.htm#a6831da3d942ccf741984f72d1d2eb57d" title="Returns QStringList filled with values fetched from current result row. SQL values converted to QStri...">QueryResult::toStringList</a> </dd></dl>
  568. </div>
  569. </div>
  570. <a id="a0d6642a5d017d6f99e0f5cb06d6740ca"></a>
  571. <h2 class="memtitle"><span class="permalink"><a href="#a0d6642a5d017d6f99e0f5cb06d6740ca">&#9670;&nbsp;</a></span>fetchVars() <span class="overload">[1/18]</span></h2>
  572. <div class="memitem">
  573. <div class="memproto">
  574. <table class="mlabels">
  575. <tr>
  576. <td class="mlabels-left">
  577. <table class="memname">
  578. <tr>
  579. <td class="memname">void QueryResult::fetchVars </td>
  580. <td>(</td>
  581. <td class="paramtype">int &amp;&#160;</td>
  582. <td class="paramname"><em>value</em></td><td>)</td>
  583. <td> const</td>
  584. </tr>
  585. </table>
  586. </td>
  587. <td class="mlabels-right">
  588. <span class="mlabels"><span class="mlabel">inline</span></span> </td>
  589. </tr>
  590. </table>
  591. </div><div class="memdoc">
  592. <p>Assigns a variable the value from the current record. </p>
  593. <p>The method has a variable number of parameters, which allows filling the list of variables with values from the current record in single call.</p>
  594. <p>Overloaded <em>EasyQtSql::fetchVars</em> methods performs the corresponding type conversion with QVariant::to*() methods.</p>
  595. <p>Supported parameter types: <em>int</em>, <em>double</em>, <em>bool</em>, <em>QString</em>, <em>QDate</em>, <em>QDateTime</em>, <em>QTime</em>, <em>QByteArray</em>, <em>QVariant</em>.</p>
  596. <p>Variables of different types can be mixed.</p>
  597. <div class="fragment"><div class="line"><a class="code" href="class_transaction.htm">Transaction</a> t;</div><div class="line"><a class="code" href="class_query_result.htm">QueryResult</a> res = t.<a class="code" href="class_database.htm#a05c1ac255cdba9781f8bf306801bca70">execQuery</a>(<span class="stringliteral">&quot;SELECT a, b, c, d FROM table&quot;</span>);</div><div class="line"></div><div class="line"><span class="keywordflow">while</span> (res.<a class="code" href="class_query_result.htm#a1c756382c20c126979b28715d529c054">next</a>())</div><div class="line">{</div><div class="line"> <span class="keywordtype">int</span> a;</div><div class="line"> <span class="keywordtype">bool</span> b;</div><div class="line"> QString c;</div><div class="line"> QDateTime d;</div><div class="line"></div><div class="line"> res.<a class="code" href="class_query_result.htm#a0d6642a5d017d6f99e0f5cb06d6740ca">fetchVars</a>(a, b, c, d);</div><div class="line">}</div></div><!-- fragment --><dl class="section see"><dt>See also</dt><dd><a class="el" href="class_query_result.htm#a0d6642a5d017d6f99e0f5cb06d6740ca" title="Assigns a variable the value from the current record. ">QueryResult::fetchVars(int&amp;) const</a> , <a class="el" href="class_query_result.htm#ac77eccf0a47750e309e11e7e66bb2d8a" title="Assigns a variable the value from the current record. ">QueryResult::fetchVars(double&amp;) const</a> , <a class="el" href="class_query_result.htm#a1a43faec4675b58bd0506a4de7c3976f" title="Assigns a variable the value from the current record. ">QueryResult::fetchVars(QString&amp;) const</a> , <a class="el" href="class_query_result.htm#af49ff273eb3efd184ca423df846ba507" title="Assigns a variable the value from the current record. ">QueryResult::fetchVars(bool&amp;) const</a> , <a class="el" href="class_query_result.htm#a50a5fa4850f774f301ed88a488a44726" title="Assigns a variable the value from the current record. ">QueryResult::fetchVars(QDate&amp;) const</a> , <a class="el" href="class_query_result.htm#a91d15081bc1d6eccefe089f4948438cb" title="Assigns a variable the value from the current record. ">QueryResult::fetchVars(QDateTime&amp;) const</a> , <a class="el" href="class_query_result.htm#af2870c71cd1b750c8151a7b4420903fa" title="Assigns a variable the value from the current record. ">QueryResult::fetchVars(QTime&amp;) const</a> , <a class="el" href="class_query_result.htm#aaeb262416e472885dc6a3c7c3c7c3306" title="Assigns a variable the value from the current record. ">QueryResult::fetchVars(QByteArray&amp;) const</a> , <a class="el" href="class_query_result.htm#a8c17bed4e4380137912a2baba19e5a30" title="Assigns a variable the value from the current record. ">QueryResult::fetchVars(QVariant&amp;) const</a> </dd></dl>
  598. </div>
  599. </div>
  600. <a id="ac77eccf0a47750e309e11e7e66bb2d8a"></a>
  601. <h2 class="memtitle"><span class="permalink"><a href="#ac77eccf0a47750e309e11e7e66bb2d8a">&#9670;&nbsp;</a></span>fetchVars() <span class="overload">[2/18]</span></h2>
  602. <div class="memitem">
  603. <div class="memproto">
  604. <table class="mlabels">
  605. <tr>
  606. <td class="mlabels-left">
  607. <table class="memname">
  608. <tr>
  609. <td class="memname">void QueryResult::fetchVars </td>
  610. <td>(</td>
  611. <td class="paramtype">double &amp;&#160;</td>
  612. <td class="paramname"><em>value</em></td><td>)</td>
  613. <td> const</td>
  614. </tr>
  615. </table>
  616. </td>
  617. <td class="mlabels-right">
  618. <span class="mlabels"><span class="mlabel">inline</span></span> </td>
  619. </tr>
  620. </table>
  621. </div><div class="memdoc">
  622. <p>Assigns a variable the value from the current record. </p>
  623. <dl class="section see"><dt>See also</dt><dd><a class="el" href="class_query_result.htm#a0d6642a5d017d6f99e0f5cb06d6740ca" title="Assigns a variable the value from the current record. ">QueryResult::fetchVars(int&amp;) const</a> </dd></dl>
  624. </div>
  625. </div>
  626. <a id="a1a43faec4675b58bd0506a4de7c3976f"></a>
  627. <h2 class="memtitle"><span class="permalink"><a href="#a1a43faec4675b58bd0506a4de7c3976f">&#9670;&nbsp;</a></span>fetchVars() <span class="overload">[3/18]</span></h2>
  628. <div class="memitem">
  629. <div class="memproto">
  630. <table class="mlabels">
  631. <tr>
  632. <td class="mlabels-left">
  633. <table class="memname">
  634. <tr>
  635. <td class="memname">void QueryResult::fetchVars </td>
  636. <td>(</td>
  637. <td class="paramtype">QString &amp;&#160;</td>
  638. <td class="paramname"><em>value</em></td><td>)</td>
  639. <td> const</td>
  640. </tr>
  641. </table>
  642. </td>
  643. <td class="mlabels-right">
  644. <span class="mlabels"><span class="mlabel">inline</span></span> </td>
  645. </tr>
  646. </table>
  647. </div><div class="memdoc">
  648. <p>Assigns a variable the value from the current record. </p>
  649. <dl class="section see"><dt>See also</dt><dd><a class="el" href="class_query_result.htm#a0d6642a5d017d6f99e0f5cb06d6740ca" title="Assigns a variable the value from the current record. ">QueryResult::fetchVars(int&amp;) const</a> </dd></dl>
  650. </div>
  651. </div>
  652. <a id="af49ff273eb3efd184ca423df846ba507"></a>
  653. <h2 class="memtitle"><span class="permalink"><a href="#af49ff273eb3efd184ca423df846ba507">&#9670;&nbsp;</a></span>fetchVars() <span class="overload">[4/18]</span></h2>
  654. <div class="memitem">
  655. <div class="memproto">
  656. <table class="mlabels">
  657. <tr>
  658. <td class="mlabels-left">
  659. <table class="memname">
  660. <tr>
  661. <td class="memname">void QueryResult::fetchVars </td>
  662. <td>(</td>
  663. <td class="paramtype">bool &amp;&#160;</td>
  664. <td class="paramname"><em>value</em></td><td>)</td>
  665. <td> const</td>
  666. </tr>
  667. </table>
  668. </td>
  669. <td class="mlabels-right">
  670. <span class="mlabels"><span class="mlabel">inline</span></span> </td>
  671. </tr>
  672. </table>
  673. </div><div class="memdoc">
  674. <p>Assigns a variable the value from the current record. </p>
  675. <dl class="section see"><dt>See also</dt><dd><a class="el" href="class_query_result.htm#a0d6642a5d017d6f99e0f5cb06d6740ca" title="Assigns a variable the value from the current record. ">QueryResult::fetchVars(int&amp;) const</a> </dd></dl>
  676. </div>
  677. </div>
  678. <a id="a50a5fa4850f774f301ed88a488a44726"></a>
  679. <h2 class="memtitle"><span class="permalink"><a href="#a50a5fa4850f774f301ed88a488a44726">&#9670;&nbsp;</a></span>fetchVars() <span class="overload">[5/18]</span></h2>
  680. <div class="memitem">
  681. <div class="memproto">
  682. <table class="mlabels">
  683. <tr>
  684. <td class="mlabels-left">
  685. <table class="memname">
  686. <tr>
  687. <td class="memname">void QueryResult::fetchVars </td>
  688. <td>(</td>
  689. <td class="paramtype">QDate &amp;&#160;</td>
  690. <td class="paramname"><em>value</em></td><td>)</td>
  691. <td> const</td>
  692. </tr>
  693. </table>
  694. </td>
  695. <td class="mlabels-right">
  696. <span class="mlabels"><span class="mlabel">inline</span></span> </td>
  697. </tr>
  698. </table>
  699. </div><div class="memdoc">
  700. <p>Assigns a variable the value from the current record. </p>
  701. <dl class="section see"><dt>See also</dt><dd><a class="el" href="class_query_result.htm#a0d6642a5d017d6f99e0f5cb06d6740ca" title="Assigns a variable the value from the current record. ">QueryResult::fetchVars(int&amp;) const</a> </dd></dl>
  702. </div>
  703. </div>
  704. <a id="a91d15081bc1d6eccefe089f4948438cb"></a>
  705. <h2 class="memtitle"><span class="permalink"><a href="#a91d15081bc1d6eccefe089f4948438cb">&#9670;&nbsp;</a></span>fetchVars() <span class="overload">[6/18]</span></h2>
  706. <div class="memitem">
  707. <div class="memproto">
  708. <table class="mlabels">
  709. <tr>
  710. <td class="mlabels-left">
  711. <table class="memname">
  712. <tr>
  713. <td class="memname">void QueryResult::fetchVars </td>
  714. <td>(</td>
  715. <td class="paramtype">QDateTime &amp;&#160;</td>
  716. <td class="paramname"><em>value</em></td><td>)</td>
  717. <td> const</td>
  718. </tr>
  719. </table>
  720. </td>
  721. <td class="mlabels-right">
  722. <span class="mlabels"><span class="mlabel">inline</span></span> </td>
  723. </tr>
  724. </table>
  725. </div><div class="memdoc">
  726. <p>Assigns a variable the value from the current record. </p>
  727. <dl class="section see"><dt>See also</dt><dd><a class="el" href="class_query_result.htm#a0d6642a5d017d6f99e0f5cb06d6740ca" title="Assigns a variable the value from the current record. ">QueryResult::fetchVars(int&amp;) const</a> </dd></dl>
  728. </div>
  729. </div>
  730. <a id="af2870c71cd1b750c8151a7b4420903fa"></a>
  731. <h2 class="memtitle"><span class="permalink"><a href="#af2870c71cd1b750c8151a7b4420903fa">&#9670;&nbsp;</a></span>fetchVars() <span class="overload">[7/18]</span></h2>
  732. <div class="memitem">
  733. <div class="memproto">
  734. <table class="mlabels">
  735. <tr>
  736. <td class="mlabels-left">
  737. <table class="memname">
  738. <tr>
  739. <td class="memname">void QueryResult::fetchVars </td>
  740. <td>(</td>
  741. <td class="paramtype">QTime &amp;&#160;</td>
  742. <td class="paramname"><em>value</em></td><td>)</td>
  743. <td> const</td>
  744. </tr>
  745. </table>
  746. </td>
  747. <td class="mlabels-right">
  748. <span class="mlabels"><span class="mlabel">inline</span></span> </td>
  749. </tr>
  750. </table>
  751. </div><div class="memdoc">
  752. <p>Assigns a variable the value from the current record. </p>
  753. <dl class="section see"><dt>See also</dt><dd><a class="el" href="class_query_result.htm#a0d6642a5d017d6f99e0f5cb06d6740ca" title="Assigns a variable the value from the current record. ">QueryResult::fetchVars(int&amp;) const</a> </dd></dl>
  754. </div>
  755. </div>
  756. <a id="aaeb262416e472885dc6a3c7c3c7c3306"></a>
  757. <h2 class="memtitle"><span class="permalink"><a href="#aaeb262416e472885dc6a3c7c3c7c3306">&#9670;&nbsp;</a></span>fetchVars() <span class="overload">[8/18]</span></h2>
  758. <div class="memitem">
  759. <div class="memproto">
  760. <table class="mlabels">
  761. <tr>
  762. <td class="mlabels-left">
  763. <table class="memname">
  764. <tr>
  765. <td class="memname">void QueryResult::fetchVars </td>
  766. <td>(</td>
  767. <td class="paramtype">QByteArray &amp;&#160;</td>
  768. <td class="paramname"><em>value</em></td><td>)</td>
  769. <td> const</td>
  770. </tr>
  771. </table>
  772. </td>
  773. <td class="mlabels-right">
  774. <span class="mlabels"><span class="mlabel">inline</span></span> </td>
  775. </tr>
  776. </table>
  777. </div><div class="memdoc">
  778. <p>Assigns a variable the value from the current record. </p>
  779. <dl class="section see"><dt>See also</dt><dd><a class="el" href="class_query_result.htm#a0d6642a5d017d6f99e0f5cb06d6740ca" title="Assigns a variable the value from the current record. ">QueryResult::fetchVars(int&amp;) const</a> </dd></dl>
  780. </div>
  781. </div>
  782. <a id="a8c17bed4e4380137912a2baba19e5a30"></a>
  783. <h2 class="memtitle"><span class="permalink"><a href="#a8c17bed4e4380137912a2baba19e5a30">&#9670;&nbsp;</a></span>fetchVars() <span class="overload">[9/18]</span></h2>
  784. <div class="memitem">
  785. <div class="memproto">
  786. <table class="mlabels">
  787. <tr>
  788. <td class="mlabels-left">
  789. <table class="memname">
  790. <tr>
  791. <td class="memname">void QueryResult::fetchVars </td>
  792. <td>(</td>
  793. <td class="paramtype">QVariant &amp;&#160;</td>
  794. <td class="paramname"><em>value</em></td><td>)</td>
  795. <td> const</td>
  796. </tr>
  797. </table>
  798. </td>
  799. <td class="mlabels-right">
  800. <span class="mlabels"><span class="mlabel">inline</span></span> </td>
  801. </tr>
  802. </table>
  803. </div><div class="memdoc">
  804. <p>Assigns a variable the value from the current record. </p>
  805. <dl class="section see"><dt>See also</dt><dd><a class="el" href="class_query_result.htm#a0d6642a5d017d6f99e0f5cb06d6740ca" title="Assigns a variable the value from the current record. ">QueryResult::fetchVars(int&amp;) const</a> </dd></dl>
  806. </div>
  807. </div>
  808. <a id="a5421dce74a177933675ede65a68972a0"></a>
  809. <h2 class="memtitle"><span class="permalink"><a href="#a5421dce74a177933675ede65a68972a0">&#9670;&nbsp;</a></span>fetchVars() <span class="overload">[10/18]</span></h2>
  810. <div class="memitem">
  811. <div class="memproto">
  812. <div class="memtemplate">
  813. template&lt;typename... Rest&gt; </div>
  814. <table class="mlabels">
  815. <tr>
  816. <td class="mlabels-left">
  817. <table class="memname">
  818. <tr>
  819. <td class="memname">void QueryResult::fetchVars </td>
  820. <td>(</td>
  821. <td class="paramtype">int &amp;&#160;</td>
  822. <td class="paramname"><em>value</em>, </td>
  823. </tr>
  824. <tr>
  825. <td class="paramkey"></td>
  826. <td></td>
  827. <td class="paramtype">Rest &amp;...&#160;</td>
  828. <td class="paramname"><em>rest</em>&#160;</td>
  829. </tr>
  830. <tr>
  831. <td></td>
  832. <td>)</td>
  833. <td></td><td> const</td>
  834. </tr>
  835. </table>
  836. </td>
  837. <td class="mlabels-right">
  838. <span class="mlabels"><span class="mlabel">inline</span></span> </td>
  839. </tr>
  840. </table>
  841. </div><div class="memdoc">
  842. </div>
  843. </div>
  844. <a id="a0b82a02ab7a45f1092e93d56a87dc67b"></a>
  845. <h2 class="memtitle"><span class="permalink"><a href="#a0b82a02ab7a45f1092e93d56a87dc67b">&#9670;&nbsp;</a></span>fetchVars() <span class="overload">[11/18]</span></h2>
  846. <div class="memitem">
  847. <div class="memproto">
  848. <div class="memtemplate">
  849. template&lt;typename... Rest&gt; </div>
  850. <table class="mlabels">
  851. <tr>
  852. <td class="mlabels-left">
  853. <table class="memname">
  854. <tr>
  855. <td class="memname">void QueryResult::fetchVars </td>
  856. <td>(</td>
  857. <td class="paramtype">double &amp;&#160;</td>
  858. <td class="paramname"><em>value</em>, </td>
  859. </tr>
  860. <tr>
  861. <td class="paramkey"></td>
  862. <td></td>
  863. <td class="paramtype">Rest &amp;...&#160;</td>
  864. <td class="paramname"><em>rest</em>&#160;</td>
  865. </tr>
  866. <tr>
  867. <td></td>
  868. <td>)</td>
  869. <td></td><td> const</td>
  870. </tr>
  871. </table>
  872. </td>
  873. <td class="mlabels-right">
  874. <span class="mlabels"><span class="mlabel">inline</span></span> </td>
  875. </tr>
  876. </table>
  877. </div><div class="memdoc">
  878. </div>
  879. </div>
  880. <a id="acf30d6c095e00eb7b1bc942563597d4b"></a>
  881. <h2 class="memtitle"><span class="permalink"><a href="#acf30d6c095e00eb7b1bc942563597d4b">&#9670;&nbsp;</a></span>fetchVars() <span class="overload">[12/18]</span></h2>
  882. <div class="memitem">
  883. <div class="memproto">
  884. <div class="memtemplate">
  885. template&lt;typename... Rest&gt; </div>
  886. <table class="mlabels">
  887. <tr>
  888. <td class="mlabels-left">
  889. <table class="memname">
  890. <tr>
  891. <td class="memname">void QueryResult::fetchVars </td>
  892. <td>(</td>
  893. <td class="paramtype">QString &amp;&#160;</td>
  894. <td class="paramname"><em>value</em>, </td>
  895. </tr>
  896. <tr>
  897. <td class="paramkey"></td>
  898. <td></td>
  899. <td class="paramtype">Rest &amp;...&#160;</td>
  900. <td class="paramname"><em>rest</em>&#160;</td>
  901. </tr>
  902. <tr>
  903. <td></td>
  904. <td>)</td>
  905. <td></td><td> const</td>
  906. </tr>
  907. </table>
  908. </td>
  909. <td class="mlabels-right">
  910. <span class="mlabels"><span class="mlabel">inline</span></span> </td>
  911. </tr>
  912. </table>
  913. </div><div class="memdoc">
  914. </div>
  915. </div>
  916. <a id="aa62c42135a62658a7e56426a024d0146"></a>
  917. <h2 class="memtitle"><span class="permalink"><a href="#aa62c42135a62658a7e56426a024d0146">&#9670;&nbsp;</a></span>fetchVars() <span class="overload">[13/18]</span></h2>
  918. <div class="memitem">
  919. <div class="memproto">
  920. <div class="memtemplate">
  921. template&lt;typename... Rest&gt; </div>
  922. <table class="mlabels">
  923. <tr>
  924. <td class="mlabels-left">
  925. <table class="memname">
  926. <tr>
  927. <td class="memname">void QueryResult::fetchVars </td>
  928. <td>(</td>
  929. <td class="paramtype">bool &amp;&#160;</td>
  930. <td class="paramname"><em>value</em>, </td>
  931. </tr>
  932. <tr>
  933. <td class="paramkey"></td>
  934. <td></td>
  935. <td class="paramtype">Rest &amp;...&#160;</td>
  936. <td class="paramname"><em>rest</em>&#160;</td>
  937. </tr>
  938. <tr>
  939. <td></td>
  940. <td>)</td>
  941. <td></td><td> const</td>
  942. </tr>
  943. </table>
  944. </td>
  945. <td class="mlabels-right">
  946. <span class="mlabels"><span class="mlabel">inline</span></span> </td>
  947. </tr>
  948. </table>
  949. </div><div class="memdoc">
  950. </div>
  951. </div>
  952. <a id="aadabff776f939dd7c3895318396ae59e"></a>
  953. <h2 class="memtitle"><span class="permalink"><a href="#aadabff776f939dd7c3895318396ae59e">&#9670;&nbsp;</a></span>fetchVars() <span class="overload">[14/18]</span></h2>
  954. <div class="memitem">
  955. <div class="memproto">
  956. <div class="memtemplate">
  957. template&lt;typename... Rest&gt; </div>
  958. <table class="mlabels">
  959. <tr>
  960. <td class="mlabels-left">
  961. <table class="memname">
  962. <tr>
  963. <td class="memname">void QueryResult::fetchVars </td>
  964. <td>(</td>
  965. <td class="paramtype">QDate &amp;&#160;</td>
  966. <td class="paramname"><em>value</em>, </td>
  967. </tr>
  968. <tr>
  969. <td class="paramkey"></td>
  970. <td></td>
  971. <td class="paramtype">Rest &amp;...&#160;</td>
  972. <td class="paramname"><em>rest</em>&#160;</td>
  973. </tr>
  974. <tr>
  975. <td></td>
  976. <td>)</td>
  977. <td></td><td> const</td>
  978. </tr>
  979. </table>
  980. </td>
  981. <td class="mlabels-right">
  982. <span class="mlabels"><span class="mlabel">inline</span></span> </td>
  983. </tr>
  984. </table>
  985. </div><div class="memdoc">
  986. </div>
  987. </div>
  988. <a id="aab68396b876b689f21109301cf350ee3"></a>
  989. <h2 class="memtitle"><span class="permalink"><a href="#aab68396b876b689f21109301cf350ee3">&#9670;&nbsp;</a></span>fetchVars() <span class="overload">[15/18]</span></h2>
  990. <div class="memitem">
  991. <div class="memproto">
  992. <div class="memtemplate">
  993. template&lt;typename... Rest&gt; </div>
  994. <table class="mlabels">
  995. <tr>
  996. <td class="mlabels-left">
  997. <table class="memname">
  998. <tr>
  999. <td class="memname">void QueryResult::fetchVars </td>
  1000. <td>(</td>
  1001. <td class="paramtype">QDateTime &amp;&#160;</td>
  1002. <td class="paramname"><em>value</em>, </td>
  1003. </tr>
  1004. <tr>
  1005. <td class="paramkey"></td>
  1006. <td></td>
  1007. <td class="paramtype">Rest &amp;...&#160;</td>
  1008. <td class="paramname"><em>rest</em>&#160;</td>
  1009. </tr>
  1010. <tr>
  1011. <td></td>
  1012. <td>)</td>
  1013. <td></td><td> const</td>
  1014. </tr>
  1015. </table>
  1016. </td>
  1017. <td class="mlabels-right">
  1018. <span class="mlabels"><span class="mlabel">inline</span></span> </td>
  1019. </tr>
  1020. </table>
  1021. </div><div class="memdoc">
  1022. </div>
  1023. </div>
  1024. <a id="a462dc42f451155eca3b56b9239cf8535"></a>
  1025. <h2 class="memtitle"><span class="permalink"><a href="#a462dc42f451155eca3b56b9239cf8535">&#9670;&nbsp;</a></span>fetchVars() <span class="overload">[16/18]</span></h2>
  1026. <div class="memitem">
  1027. <div class="memproto">
  1028. <div class="memtemplate">
  1029. template&lt;typename... Rest&gt; </div>
  1030. <table class="mlabels">
  1031. <tr>
  1032. <td class="mlabels-left">
  1033. <table class="memname">
  1034. <tr>
  1035. <td class="memname">void QueryResult::fetchVars </td>
  1036. <td>(</td>
  1037. <td class="paramtype">QTime &amp;&#160;</td>
  1038. <td class="paramname"><em>value</em>, </td>
  1039. </tr>
  1040. <tr>
  1041. <td class="paramkey"></td>
  1042. <td></td>
  1043. <td class="paramtype">Rest &amp;...&#160;</td>
  1044. <td class="paramname"><em>rest</em>&#160;</td>
  1045. </tr>
  1046. <tr>
  1047. <td></td>
  1048. <td>)</td>
  1049. <td></td><td> const</td>
  1050. </tr>
  1051. </table>
  1052. </td>
  1053. <td class="mlabels-right">
  1054. <span class="mlabels"><span class="mlabel">inline</span></span> </td>
  1055. </tr>
  1056. </table>
  1057. </div><div class="memdoc">
  1058. </div>
  1059. </div>
  1060. <a id="a5efedd7a6e170ddeaddbac5428951085"></a>
  1061. <h2 class="memtitle"><span class="permalink"><a href="#a5efedd7a6e170ddeaddbac5428951085">&#9670;&nbsp;</a></span>fetchVars() <span class="overload">[17/18]</span></h2>
  1062. <div class="memitem">
  1063. <div class="memproto">
  1064. <div class="memtemplate">
  1065. template&lt;typename... Rest&gt; </div>
  1066. <table class="mlabels">
  1067. <tr>
  1068. <td class="mlabels-left">
  1069. <table class="memname">
  1070. <tr>
  1071. <td class="memname">void QueryResult::fetchVars </td>
  1072. <td>(</td>
  1073. <td class="paramtype">QByteArray &amp;&#160;</td>
  1074. <td class="paramname"><em>value</em>, </td>
  1075. </tr>
  1076. <tr>
  1077. <td class="paramkey"></td>
  1078. <td></td>
  1079. <td class="paramtype">Rest &amp;...&#160;</td>
  1080. <td class="paramname"><em>rest</em>&#160;</td>
  1081. </tr>
  1082. <tr>
  1083. <td></td>
  1084. <td>)</td>
  1085. <td></td><td> const</td>
  1086. </tr>
  1087. </table>
  1088. </td>
  1089. <td class="mlabels-right">
  1090. <span class="mlabels"><span class="mlabel">inline</span></span> </td>
  1091. </tr>
  1092. </table>
  1093. </div><div class="memdoc">
  1094. </div>
  1095. </div>
  1096. <a id="a0a381517b5fa64a68e4d10972b0ceefc"></a>
  1097. <h2 class="memtitle"><span class="permalink"><a href="#a0a381517b5fa64a68e4d10972b0ceefc">&#9670;&nbsp;</a></span>fetchVars() <span class="overload">[18/18]</span></h2>
  1098. <div class="memitem">
  1099. <div class="memproto">
  1100. <div class="memtemplate">
  1101. template&lt;typename... Rest&gt; </div>
  1102. <table class="mlabels">
  1103. <tr>
  1104. <td class="mlabels-left">
  1105. <table class="memname">
  1106. <tr>
  1107. <td class="memname">void QueryResult::fetchVars </td>
  1108. <td>(</td>
  1109. <td class="paramtype">QVariant &amp;&#160;</td>
  1110. <td class="paramname"><em>value</em>, </td>
  1111. </tr>
  1112. <tr>
  1113. <td class="paramkey"></td>
  1114. <td></td>
  1115. <td class="paramtype">Rest &amp;...&#160;</td>
  1116. <td class="paramname"><em>rest</em>&#160;</td>
  1117. </tr>
  1118. <tr>
  1119. <td></td>
  1120. <td>)</td>
  1121. <td></td><td> const</td>
  1122. </tr>
  1123. </table>
  1124. </td>
  1125. <td class="mlabels-right">
  1126. <span class="mlabels"><span class="mlabel">inline</span></span> </td>
  1127. </tr>
  1128. </table>
  1129. </div><div class="memdoc">
  1130. </div>
  1131. </div>
  1132. <a id="ad111370ab183d4d6a1522123c03f183d"></a>
  1133. <h2 class="memtitle"><span class="permalink"><a href="#ad111370ab183d4d6a1522123c03f183d">&#9670;&nbsp;</a></span>fetchVector()</h2>
  1134. <div class="memitem">
  1135. <div class="memproto">
  1136. <table class="mlabels">
  1137. <tr>
  1138. <td class="mlabels-left">
  1139. <table class="memname">
  1140. <tr>
  1141. <td class="memname">void QueryResult::fetchVector </td>
  1142. <td>(</td>
  1143. <td class="paramtype">QVector&lt; QVariant &gt; &amp;&#160;</td>
  1144. <td class="paramname"><em>vector</em></td><td>)</td>
  1145. <td> const</td>
  1146. </tr>
  1147. </table>
  1148. </td>
  1149. <td class="mlabels-right">
  1150. <span class="mlabels"><span class="mlabel">inline</span></span> </td>
  1151. </tr>
  1152. </table>
  1153. </div><div class="memdoc">
  1154. <p>Fills QVector&lt;QVariant&gt; with values fetched from current result row. SQL values not converted: QSqlQuery::value() return value used. </p>
  1155. <dl class="params"><dt>Parameters</dt><dd>
  1156. <table class="params">
  1157. <tr><td class="paramdir">[out]</td><td class="paramname">vector</td><td>QVector&lt;QVariant&gt; </td></tr>
  1158. </table>
  1159. </dd>
  1160. </dl>
  1161. <dl class="section see"><dt>See also</dt><dd><a class="el" href="class_query_result.htm#a9bebffe22ed2f023ef7c9540aa9164ea" title="Returns QVector&lt;QVariant&gt; filled with values fetched from current result row. SQL values not converte...">QueryResult::toVector</a> </dd></dl>
  1162. </div>
  1163. </div>
  1164. <a id="a406abd3501b2f3d89bf6bb7e5e8cd7c3"></a>
  1165. <h2 class="memtitle"><span class="permalink"><a href="#a406abd3501b2f3d89bf6bb7e5e8cd7c3">&#9670;&nbsp;</a></span>first()</h2>
  1166. <div class="memitem">
  1167. <div class="memproto">
  1168. <table class="mlabels">
  1169. <tr>
  1170. <td class="mlabels-left">
  1171. <table class="memname">
  1172. <tr>
  1173. <td class="memname">bool QueryResult::first </td>
  1174. <td>(</td>
  1175. <td class="paramname"></td><td>)</td>
  1176. <td></td>
  1177. </tr>
  1178. </table>
  1179. </td>
  1180. <td class="mlabels-right">
  1181. <span class="mlabels"><span class="mlabel">inline</span></span> </td>
  1182. </tr>
  1183. </table>
  1184. </div><div class="memdoc">
  1185. <p>Retrieves the first record in the result, if available, and positions the query on the retrieved record. </p>
  1186. <p>Wrapper over QSqlQuery::first() </p>
  1187. </div>
  1188. </div>
  1189. <a id="a46b374177ab23d8f9d7dc9366eb57655"></a>
  1190. <h2 class="memtitle"><span class="permalink"><a href="#a46b374177ab23d8f9d7dc9366eb57655">&#9670;&nbsp;</a></span>isActive()</h2>
  1191. <div class="memitem">
  1192. <div class="memproto">
  1193. <table class="mlabels">
  1194. <tr>
  1195. <td class="mlabels-left">
  1196. <table class="memname">
  1197. <tr>
  1198. <td class="memname">bool QueryResult::isActive </td>
  1199. <td>(</td>
  1200. <td class="paramname"></td><td>)</td>
  1201. <td> const</td>
  1202. </tr>
  1203. </table>
  1204. </td>
  1205. <td class="mlabels-right">
  1206. <span class="mlabels"><span class="mlabel">inline</span></span> </td>
  1207. </tr>
  1208. </table>
  1209. </div><div class="memdoc">
  1210. <p>Returns true if the query is active. An active QSqlQuery is one that has been exec()'d successfully but not yet finished with. </p>
  1211. <p>Wrapper over QSqlQuery::isActive() </p>
  1212. </div>
  1213. </div>
  1214. <a id="a5b6ef75a4da642c0c467d0110ce1701a"></a>
  1215. <h2 class="memtitle"><span class="permalink"><a href="#a5b6ef75a4da642c0c467d0110ce1701a">&#9670;&nbsp;</a></span>isForwardOnly()</h2>
  1216. <div class="memitem">
  1217. <div class="memproto">
  1218. <table class="mlabels">
  1219. <tr>
  1220. <td class="mlabels-left">
  1221. <table class="memname">
  1222. <tr>
  1223. <td class="memname">bool QueryResult::isForwardOnly </td>
  1224. <td>(</td>
  1225. <td class="paramname"></td><td>)</td>
  1226. <td> const</td>
  1227. </tr>
  1228. </table>
  1229. </td>
  1230. <td class="mlabels-right">
  1231. <span class="mlabels"><span class="mlabel">inline</span></span> </td>
  1232. </tr>
  1233. </table>
  1234. </div><div class="memdoc">
  1235. <p>Returns true if you can only scroll forward through a result set; otherwise returns false. </p>
  1236. <p>Wrapper over QSqlQuery::isForwardOnly() </p>
  1237. </div>
  1238. </div>
  1239. <a id="ae9ec64a1171aba3f7cef8b081c8158be"></a>
  1240. <h2 class="memtitle"><span class="permalink"><a href="#ae9ec64a1171aba3f7cef8b081c8158be">&#9670;&nbsp;</a></span>isValid()</h2>
  1241. <div class="memitem">
  1242. <div class="memproto">
  1243. <table class="mlabels">
  1244. <tr>
  1245. <td class="mlabels-left">
  1246. <table class="memname">
  1247. <tr>
  1248. <td class="memname">bool QueryResult::isValid </td>
  1249. <td>(</td>
  1250. <td class="paramname"></td><td>)</td>
  1251. <td> const</td>
  1252. </tr>
  1253. </table>
  1254. </td>
  1255. <td class="mlabels-right">
  1256. <span class="mlabels"><span class="mlabel">inline</span></span> </td>
  1257. </tr>
  1258. </table>
  1259. </div><div class="memdoc">
  1260. <p>Returns true if the query is currently positioned on a valid record; otherwise returns false. </p>
  1261. <p>Wrapper over QSqlQuery::isValid() </p>
  1262. </div>
  1263. </div>
  1264. <a id="a0e5a5d108da1d03b0f624e18330a10f5"></a>
  1265. <h2 class="memtitle"><span class="permalink"><a href="#a0e5a5d108da1d03b0f624e18330a10f5">&#9670;&nbsp;</a></span>last()</h2>
  1266. <div class="memitem">
  1267. <div class="memproto">
  1268. <table class="mlabels">
  1269. <tr>
  1270. <td class="mlabels-left">
  1271. <table class="memname">
  1272. <tr>
  1273. <td class="memname">bool QueryResult::last </td>
  1274. <td>(</td>
  1275. <td class="paramname"></td><td>)</td>
  1276. <td></td>
  1277. </tr>
  1278. </table>
  1279. </td>
  1280. <td class="mlabels-right">
  1281. <span class="mlabels"><span class="mlabel">inline</span></span> </td>
  1282. </tr>
  1283. </table>
  1284. </div><div class="memdoc">
  1285. <p>Retrieves the last record in the result, if available, and positions the query on the retrieved record. </p>
  1286. <p>Wrapper over QSqlQuery::last() </p>
  1287. </div>
  1288. </div>
  1289. <a id="ac56dbe38b558a9e55591f645d50eacde"></a>
  1290. <h2 class="memtitle"><span class="permalink"><a href="#ac56dbe38b558a9e55591f645d50eacde">&#9670;&nbsp;</a></span>lastError()</h2>
  1291. <div class="memitem">
  1292. <div class="memproto">
  1293. <table class="mlabels">
  1294. <tr>
  1295. <td class="mlabels-left">
  1296. <table class="memname">
  1297. <tr>
  1298. <td class="memname">QSqlError QueryResult::lastError </td>
  1299. <td>(</td>
  1300. <td class="paramname"></td><td>)</td>
  1301. <td> const</td>
  1302. </tr>
  1303. </table>
  1304. </td>
  1305. <td class="mlabels-right">
  1306. <span class="mlabels"><span class="mlabel">inline</span></span> </td>
  1307. </tr>
  1308. </table>
  1309. </div><div class="memdoc">
  1310. <p>Returns error information about the last error (if any) that occurred with this query. </p>
  1311. <p>Wrapper over QSqlQuery::lastError() </p>
  1312. </div>
  1313. </div>
  1314. <a id="af86eb1e97db39a70d504389494e2b329"></a>
  1315. <h2 class="memtitle"><span class="permalink"><a href="#af86eb1e97db39a70d504389494e2b329">&#9670;&nbsp;</a></span>lastQuery()</h2>
  1316. <div class="memitem">
  1317. <div class="memproto">
  1318. <table class="mlabels">
  1319. <tr>
  1320. <td class="mlabels-left">
  1321. <table class="memname">
  1322. <tr>
  1323. <td class="memname">QString QueryResult::lastQuery </td>
  1324. <td>(</td>
  1325. <td class="paramname"></td><td>)</td>
  1326. <td> const</td>
  1327. </tr>
  1328. </table>
  1329. </td>
  1330. <td class="mlabels-right">
  1331. <span class="mlabels"><span class="mlabel">inline</span></span> </td>
  1332. </tr>
  1333. </table>
  1334. </div><div class="memdoc">
  1335. <p>Returns the text of the current query being used, or an empty string if there is no current query text. </p>
  1336. <p>Wrapper over QSqlQuery::lastQuery() </p>
  1337. </div>
  1338. </div>
  1339. <a id="a1c756382c20c126979b28715d529c054"></a>
  1340. <h2 class="memtitle"><span class="permalink"><a href="#a1c756382c20c126979b28715d529c054">&#9670;&nbsp;</a></span>next()</h2>
  1341. <div class="memitem">
  1342. <div class="memproto">
  1343. <table class="mlabels">
  1344. <tr>
  1345. <td class="mlabels-left">
  1346. <table class="memname">
  1347. <tr>
  1348. <td class="memname">bool QueryResult::next </td>
  1349. <td>(</td>
  1350. <td class="paramname"></td><td>)</td>
  1351. <td></td>
  1352. </tr>
  1353. </table>
  1354. </td>
  1355. <td class="mlabels-right">
  1356. <span class="mlabels"><span class="mlabel">inline</span></span> </td>
  1357. </tr>
  1358. </table>
  1359. </div><div class="memdoc">
  1360. <p>Retrieves the next record in the result, if available, and positions the query on the retrieved record. </p>
  1361. <p>Wrapper over QSqlQuery::next() </p>
  1362. </div>
  1363. </div>
  1364. <a id="a9ed922784c015b27b7fb53fafb10b391"></a>
  1365. <h2 class="memtitle"><span class="permalink"><a href="#a9ed922784c015b27b7fb53fafb10b391">&#9670;&nbsp;</a></span>nextResult()</h2>
  1366. <div class="memitem">
  1367. <div class="memproto">
  1368. <table class="mlabels">
  1369. <tr>
  1370. <td class="mlabels-left">
  1371. <table class="memname">
  1372. <tr>
  1373. <td class="memname">bool QueryResult::nextResult </td>
  1374. <td>(</td>
  1375. <td class="paramname"></td><td>)</td>
  1376. <td></td>
  1377. </tr>
  1378. </table>
  1379. </td>
  1380. <td class="mlabels-right">
  1381. <span class="mlabels"><span class="mlabel">inline</span></span> </td>
  1382. </tr>
  1383. </table>
  1384. </div><div class="memdoc">
  1385. <p>Discards the current result set and navigates to the next if available (if database is capable of returning multiple result sets) </p>
  1386. <p>Wrapper over QSqlQuery::nextResult() </p>
  1387. </div>
  1388. </div>
  1389. <a id="a26baf17cd661ec312918f660ac9e4b1a"></a>
  1390. <h2 class="memtitle"><span class="permalink"><a href="#a26baf17cd661ec312918f660ac9e4b1a">&#9670;&nbsp;</a></span>numRowsAffected()</h2>
  1391. <div class="memitem">
  1392. <div class="memproto">
  1393. <table class="mlabels">
  1394. <tr>
  1395. <td class="mlabels-left">
  1396. <table class="memname">
  1397. <tr>
  1398. <td class="memname">int QueryResult::numRowsAffected </td>
  1399. <td>(</td>
  1400. <td class="paramname"></td><td>)</td>
  1401. <td> const</td>
  1402. </tr>
  1403. </table>
  1404. </td>
  1405. <td class="mlabels-right">
  1406. <span class="mlabels"><span class="mlabel">inline</span></span> </td>
  1407. </tr>
  1408. </table>
  1409. </div><div class="memdoc">
  1410. <p>Returns the number of rows affected by the result's SQL statement, or -1 if it cannot be determined. </p>
  1411. <p>Wrapper over QSqlQuery::numRowsAffected() </p>
  1412. </div>
  1413. </div>
  1414. <a id="a22bd0f401bbcc203adb03b874ef2c5d8"></a>
  1415. <h2 class="memtitle"><span class="permalink"><a href="#a22bd0f401bbcc203adb03b874ef2c5d8">&#9670;&nbsp;</a></span>parseToIntVector()</h2>
  1416. <div class="memitem">
  1417. <div class="memproto">
  1418. <table class="mlabels">
  1419. <tr>
  1420. <td class="mlabels-left">
  1421. <table class="memname">
  1422. <tr>
  1423. <td class="memname">QVector&lt;int&gt; QueryResult::parseToIntVector </td>
  1424. <td>(</td>
  1425. <td class="paramtype">int&#160;</td>
  1426. <td class="paramname"><em>base</em> = <code>10</code>, </td>
  1427. </tr>
  1428. <tr>
  1429. <td class="paramkey"></td>
  1430. <td></td>
  1431. <td class="paramtype">bool&#160;</td>
  1432. <td class="paramname"><em>skipNullValues</em> = <code>false</code>&#160;</td>
  1433. </tr>
  1434. <tr>
  1435. <td></td>
  1436. <td>)</td>
  1437. <td></td><td> const</td>
  1438. </tr>
  1439. </table>
  1440. </td>
  1441. <td class="mlabels-right">
  1442. <span class="mlabels"><span class="mlabel">inline</span></span> </td>
  1443. </tr>
  1444. </table>
  1445. </div><div class="memdoc">
  1446. <p>Returns vector of (optionally parsed) integer values from currently active result row. </p>
  1447. <p>Parsing with specified base will be performed if type of selected database field is String (varchar/text). Not successfully parsed string values are ignored.</p>
  1448. <dl class="params"><dt>Parameters</dt><dd>
  1449. <table class="params">
  1450. <tr><td class="paramname">base</td><td>Number base to parse int values from SQL string values. </td></tr>
  1451. <tr><td class="paramname">skipNullValues</td><td>Skip SQL NULL values. Resulting int value is 0 if skipNullValues = false. </td></tr>
  1452. </table>
  1453. </dd>
  1454. </dl>
  1455. </div>
  1456. </div>
  1457. <a id="a9325bfaca721378e6bafa50fd7839197"></a>
  1458. <h2 class="memtitle"><span class="permalink"><a href="#a9325bfaca721378e6bafa50fd7839197">&#9670;&nbsp;</a></span>previous()</h2>
  1459. <div class="memitem">
  1460. <div class="memproto">
  1461. <table class="mlabels">
  1462. <tr>
  1463. <td class="mlabels-left">
  1464. <table class="memname">
  1465. <tr>
  1466. <td class="memname">bool QueryResult::previous </td>
  1467. <td>(</td>
  1468. <td class="paramname"></td><td>)</td>
  1469. <td></td>
  1470. </tr>
  1471. </table>
  1472. </td>
  1473. <td class="mlabels-right">
  1474. <span class="mlabels"><span class="mlabel">inline</span></span> </td>
  1475. </tr>
  1476. </table>
  1477. </div><div class="memdoc">
  1478. <p>Retrieves the previous record in the result, if available, and positions the query on the retrieved record. </p>
  1479. <p>Wrapper over QSqlQuery::previous() </p>
  1480. </div>
  1481. </div>
  1482. <a id="a5e3b49cb821efecac406606d9e3adb13"></a>
  1483. <h2 class="memtitle"><span class="permalink"><a href="#a5e3b49cb821efecac406606d9e3adb13">&#9670;&nbsp;</a></span>scalar() <span class="overload">[1/2]</span></h2>
  1484. <div class="memitem">
  1485. <div class="memproto">
  1486. <div class="memtemplate">
  1487. template&lt;typename T &gt; </div>
  1488. <table class="mlabels">
  1489. <tr>
  1490. <td class="mlabels-left">
  1491. <table class="memname">
  1492. <tr>
  1493. <td class="memname">T QueryResult::scalar </td>
  1494. <td>(</td>
  1495. <td class="paramname"></td><td>)</td>
  1496. <td> const</td>
  1497. </tr>
  1498. </table>
  1499. </td>
  1500. <td class="mlabels-right">
  1501. <span class="mlabels"><span class="mlabel">inline</span></span> </td>
  1502. </tr>
  1503. </table>
  1504. </div><div class="memdoc">
  1505. <p>Returns scalar value converted to type T (the value of the first column of the current row) </p>
  1506. </div>
  1507. </div>
  1508. <a id="abd683e71de31fbcf8e74e22249597322"></a>
  1509. <h2 class="memtitle"><span class="permalink"><a href="#abd683e71de31fbcf8e74e22249597322">&#9670;&nbsp;</a></span>scalar() <span class="overload">[2/2]</span></h2>
  1510. <div class="memitem">
  1511. <div class="memproto">
  1512. <table class="mlabels">
  1513. <tr>
  1514. <td class="mlabels-left">
  1515. <table class="memname">
  1516. <tr>
  1517. <td class="memname">QVariant QueryResult::scalar </td>
  1518. <td>(</td>
  1519. <td class="paramname"></td><td>)</td>
  1520. <td> const</td>
  1521. </tr>
  1522. </table>
  1523. </td>
  1524. <td class="mlabels-right">
  1525. <span class="mlabels"><span class="mlabel">inline</span></span> </td>
  1526. </tr>
  1527. </table>
  1528. </div><div class="memdoc">
  1529. <p>Returns scalar value (the value of the first column of the current row) </p>
  1530. </div>
  1531. </div>
  1532. <a id="aff65a998f1c8be8c1dd630438a820158"></a>
  1533. <h2 class="memtitle"><span class="permalink"><a href="#aff65a998f1c8be8c1dd630438a820158">&#9670;&nbsp;</a></span>seek()</h2>
  1534. <div class="memitem">
  1535. <div class="memproto">
  1536. <table class="mlabels">
  1537. <tr>
  1538. <td class="mlabels-left">
  1539. <table class="memname">
  1540. <tr>
  1541. <td class="memname">bool QueryResult::seek </td>
  1542. <td>(</td>
  1543. <td class="paramtype">int&#160;</td>
  1544. <td class="paramname"><em>index</em>, </td>
  1545. </tr>
  1546. <tr>
  1547. <td class="paramkey"></td>
  1548. <td></td>
  1549. <td class="paramtype">bool&#160;</td>
  1550. <td class="paramname"><em>relative</em> = <code>false</code>&#160;</td>
  1551. </tr>
  1552. <tr>
  1553. <td></td>
  1554. <td>)</td>
  1555. <td></td><td></td>
  1556. </tr>
  1557. </table>
  1558. </td>
  1559. <td class="mlabels-right">
  1560. <span class="mlabels"><span class="mlabel">inline</span></span> </td>
  1561. </tr>
  1562. </table>
  1563. </div><div class="memdoc">
  1564. <p>Retrieves the record at position index, if available, and positions the query on the retrieved record. </p>
  1565. <p>Wrapper over QSqlQuery::seek() </p>
  1566. </div>
  1567. </div>
  1568. <a id="ad46ba52de7f43f45c19d4b7eecabca4b"></a>
  1569. <h2 class="memtitle"><span class="permalink"><a href="#ad46ba52de7f43f45c19d4b7eecabca4b">&#9670;&nbsp;</a></span>size()</h2>
  1570. <div class="memitem">
  1571. <div class="memproto">
  1572. <table class="mlabels">
  1573. <tr>
  1574. <td class="mlabels-left">
  1575. <table class="memname">
  1576. <tr>
  1577. <td class="memname">int QueryResult::size </td>
  1578. <td>(</td>
  1579. <td class="paramname"></td><td>)</td>
  1580. <td> const</td>
  1581. </tr>
  1582. </table>
  1583. </td>
  1584. <td class="mlabels-right">
  1585. <span class="mlabels"><span class="mlabel">inline</span></span> </td>
  1586. </tr>
  1587. </table>
  1588. </div><div class="memdoc">
  1589. <p>Returns the size of the result (number of rows returned), or -1 if the size cannot be determined or if the database does not support reporting information about query sizes. </p>
  1590. <p>Wrapper over QSqlQuery::size() </p>
  1591. </div>
  1592. </div>
  1593. <a id="aa1595196bd3fd72c9ee95c6c0a82f711"></a>
  1594. <h2 class="memtitle"><span class="permalink"><a href="#aa1595196bd3fd72c9ee95c6c0a82f711">&#9670;&nbsp;</a></span>toList()</h2>
  1595. <div class="memitem">
  1596. <div class="memproto">
  1597. <table class="mlabels">
  1598. <tr>
  1599. <td class="mlabels-left">
  1600. <table class="memname">
  1601. <tr>
  1602. <td class="memname">QVariantList QueryResult::toList </td>
  1603. <td>(</td>
  1604. <td class="paramname"></td><td>)</td>
  1605. <td> const</td>
  1606. </tr>
  1607. </table>
  1608. </td>
  1609. <td class="mlabels-right">
  1610. <span class="mlabels"><span class="mlabel">inline</span></span> </td>
  1611. </tr>
  1612. </table>
  1613. </div><div class="memdoc">
  1614. <p>Returns QVariantList filled with values fetched from current result row. </p>
  1615. <dl class="section see"><dt>See also</dt><dd><a class="el" href="class_query_result.htm#af62abbe3a59c25163c90e4a5fec632c7" title="Fills QVariantList with values fetched from current result row. SQL values not converted: QSqlQuery::...">QueryResult::fetchList</a> </dd></dl>
  1616. </div>
  1617. </div>
  1618. <a id="a023bd84f7010368d616d7dbb1b399a06"></a>
  1619. <h2 class="memtitle"><span class="permalink"><a href="#a023bd84f7010368d616d7dbb1b399a06">&#9670;&nbsp;</a></span>toMap()</h2>
  1620. <div class="memitem">
  1621. <div class="memproto">
  1622. <table class="mlabels">
  1623. <tr>
  1624. <td class="mlabels-left">
  1625. <table class="memname">
  1626. <tr>
  1627. <td class="memname">QVariantMap QueryResult::toMap </td>
  1628. <td>(</td>
  1629. <td class="paramname"></td><td>)</td>
  1630. <td> const</td>
  1631. </tr>
  1632. </table>
  1633. </td>
  1634. <td class="mlabels-right">
  1635. <span class="mlabels"><span class="mlabel">inline</span></span> </td>
  1636. </tr>
  1637. </table>
  1638. </div><div class="memdoc">
  1639. <p>Returns QVariantMap filled with values fetched from current result row. Key is QString (result column name) and value is QVariant value. </p>
  1640. <dl class="section see"><dt>See also</dt><dd><a class="el" href="class_query_result.htm#a0f79c838a9fcd4a5d48e61abc79612e9" title="Fills QVariantMap with values fetched from current result row. Key is QString (result column name) an...">QueryResult::fetchMap</a> </dd></dl>
  1641. </div>
  1642. </div>
  1643. <a id="a6831da3d942ccf741984f72d1d2eb57d"></a>
  1644. <h2 class="memtitle"><span class="permalink"><a href="#a6831da3d942ccf741984f72d1d2eb57d">&#9670;&nbsp;</a></span>toStringList()</h2>
  1645. <div class="memitem">
  1646. <div class="memproto">
  1647. <table class="mlabels">
  1648. <tr>
  1649. <td class="mlabels-left">
  1650. <table class="memname">
  1651. <tr>
  1652. <td class="memname">QStringList QueryResult::toStringList </td>
  1653. <td>(</td>
  1654. <td class="paramname"></td><td>)</td>
  1655. <td> const</td>
  1656. </tr>
  1657. </table>
  1658. </td>
  1659. <td class="mlabels-right">
  1660. <span class="mlabels"><span class="mlabel">inline</span></span> </td>
  1661. </tr>
  1662. </table>
  1663. </div><div class="memdoc">
  1664. <p>Returns QStringList filled with values fetched from current result row. SQL values converted to QString with QVariant::toString() method. </p>
  1665. <dl class="section see"><dt>See also</dt><dd><a class="el" href="class_query_result.htm#af49aaa8a26876c7a095326c8b2d5ba6a" title="Fills QStringList with values fetched from current result row. SQL values converted to QString with Q...">QueryResult::fetchStringList()</a> </dd></dl>
  1666. </div>
  1667. </div>
  1668. <a id="a9bebffe22ed2f023ef7c9540aa9164ea"></a>
  1669. <h2 class="memtitle"><span class="permalink"><a href="#a9bebffe22ed2f023ef7c9540aa9164ea">&#9670;&nbsp;</a></span>toVector() <span class="overload">[1/2]</span></h2>
  1670. <div class="memitem">
  1671. <div class="memproto">
  1672. <table class="mlabels">
  1673. <tr>
  1674. <td class="mlabels-left">
  1675. <table class="memname">
  1676. <tr>
  1677. <td class="memname">QVector&lt;QVariant&gt; QueryResult::toVector </td>
  1678. <td>(</td>
  1679. <td class="paramname"></td><td>)</td>
  1680. <td> const</td>
  1681. </tr>
  1682. </table>
  1683. </td>
  1684. <td class="mlabels-right">
  1685. <span class="mlabels"><span class="mlabel">inline</span></span> </td>
  1686. </tr>
  1687. </table>
  1688. </div><div class="memdoc">
  1689. <p>Returns QVector&lt;QVariant&gt; filled with values fetched from current result row. SQL values not converted: QSqlQuery::value() return value used. </p>
  1690. <dl class="section see"><dt>See also</dt><dd><a class="el" href="class_query_result.htm#ad111370ab183d4d6a1522123c03f183d" title="Fills QVector&lt;QVariant&gt; with values fetched from current result row. SQL values not converted: QSqlQu...">QueryResult::fetchVector</a> </dd></dl>
  1691. </div>
  1692. </div>
  1693. <a id="aa4f8c874ffb9e6b1285a69322aec61ea"></a>
  1694. <h2 class="memtitle"><span class="permalink"><a href="#aa4f8c874ffb9e6b1285a69322aec61ea">&#9670;&nbsp;</a></span>toVector() <span class="overload">[2/2]</span></h2>
  1695. <div class="memitem">
  1696. <div class="memproto">
  1697. <div class="memtemplate">
  1698. template&lt;typename T &gt; </div>
  1699. <table class="mlabels">
  1700. <tr>
  1701. <td class="mlabels-left">
  1702. <table class="memname">
  1703. <tr>
  1704. <td class="memname">QVector&lt;T&gt; QueryResult::toVector </td>
  1705. <td>(</td>
  1706. <td class="paramtype">bool&#160;</td>
  1707. <td class="paramname"><em>skipNullValues</em> = <code>false</code></td><td>)</td>
  1708. <td> const</td>
  1709. </tr>
  1710. </table>
  1711. </td>
  1712. <td class="mlabels-right">
  1713. <span class="mlabels"><span class="mlabel">inline</span></span> </td>
  1714. </tr>
  1715. </table>
  1716. </div><div class="memdoc">
  1717. <p>Returns QVector&lt;T&gt; filled with values fetched from current result row. SQL values converted with QVariant::value&lt;T&gt;(). QVector::canConvert&lt;T&gt;() method used for convertability check. Non-convertable values skipped. </p>
  1718. <dl class="params"><dt>Parameters</dt><dd>
  1719. <table class="params">
  1720. <tr><td class="paramname">skipNullValues</td><td>Skip SQL NULL values. Resulting value is default value if skipNullValues = false. </td></tr>
  1721. </table>
  1722. </dd>
  1723. </dl>
  1724. <dl class="section see"><dt>See also</dt><dd><a class="el" href="class_query_result.htm#a9bebffe22ed2f023ef7c9540aa9164ea" title="Returns QVector&lt;QVariant&gt; filled with values fetched from current result row. SQL values not converte...">QueryResult::toVector</a> </dd></dl>
  1725. </div>
  1726. </div>
  1727. <a id="afcffce24fb54a5b94c74d304a36fc317"></a>
  1728. <h2 class="memtitle"><span class="permalink"><a href="#afcffce24fb54a5b94c74d304a36fc317">&#9670;&nbsp;</a></span>unwrappedQuery()</h2>
  1729. <div class="memitem">
  1730. <div class="memproto">
  1731. <table class="mlabels">
  1732. <tr>
  1733. <td class="mlabels-left">
  1734. <table class="memname">
  1735. <tr>
  1736. <td class="memname">QSqlQuery&amp; QueryResult::unwrappedQuery </td>
  1737. <td>(</td>
  1738. <td class="paramname"></td><td>)</td>
  1739. <td></td>
  1740. </tr>
  1741. </table>
  1742. </td>
  1743. <td class="mlabels-right">
  1744. <span class="mlabels"><span class="mlabel">inline</span></span> </td>
  1745. </tr>
  1746. </table>
  1747. </div><div class="memdoc">
  1748. <p>Returns reference on wrapped QSqlQuery. </p>
  1749. </div>
  1750. </div>
  1751. <a id="a74350f3ed705c8768bd748fe942438de"></a>
  1752. <h2 class="memtitle"><span class="permalink"><a href="#a74350f3ed705c8768bd748fe942438de">&#9670;&nbsp;</a></span>value() <span class="overload">[1/2]</span></h2>
  1753. <div class="memitem">
  1754. <div class="memproto">
  1755. <table class="mlabels">
  1756. <tr>
  1757. <td class="mlabels-left">
  1758. <table class="memname">
  1759. <tr>
  1760. <td class="memname">QVariant QueryResult::value </td>
  1761. <td>(</td>
  1762. <td class="paramtype">int&#160;</td>
  1763. <td class="paramname"><em>column</em></td><td>)</td>
  1764. <td> const</td>
  1765. </tr>
  1766. </table>
  1767. </td>
  1768. <td class="mlabels-right">
  1769. <span class="mlabels"><span class="mlabel">inline</span></span> </td>
  1770. </tr>
  1771. </table>
  1772. </div><div class="memdoc">
  1773. <p>Returns the value of field index in the current record. </p>
  1774. <p>Wrapper over QSqlQuery::value() </p>
  1775. </div>
  1776. </div>
  1777. <a id="a90ec24d07326aaa31e5372cfa377c985"></a>
  1778. <h2 class="memtitle"><span class="permalink"><a href="#a90ec24d07326aaa31e5372cfa377c985">&#9670;&nbsp;</a></span>value() <span class="overload">[2/2]</span></h2>
  1779. <div class="memitem">
  1780. <div class="memproto">
  1781. <table class="mlabels">
  1782. <tr>
  1783. <td class="mlabels-left">
  1784. <table class="memname">
  1785. <tr>
  1786. <td class="memname">QVariant QueryResult::value </td>
  1787. <td>(</td>
  1788. <td class="paramtype">const QString &amp;&#160;</td>
  1789. <td class="paramname"><em>colName</em></td><td>)</td>
  1790. <td> const</td>
  1791. </tr>
  1792. </table>
  1793. </td>
  1794. <td class="mlabels-right">
  1795. <span class="mlabels"><span class="mlabel">inline</span></span> </td>
  1796. </tr>
  1797. </table>
  1798. </div><div class="memdoc">
  1799. <p>Returns the value of the field called name in the current record. If field name does not exist an invalid variant is returned. </p>
  1800. <p>Wrapper over QSqlQuery::value() </p>
  1801. </div>
  1802. </div>
  1803. <h2 class="groupheader">Friends And Related Function Documentation</h2>
  1804. <a id="a6efef52d7a939622bbc934ff6b90ffe0"></a>
  1805. <h2 class="memtitle"><span class="permalink"><a href="#a6efef52d7a939622bbc934ff6b90ffe0">&#9670;&nbsp;</a></span>Database</h2>
  1806. <div class="memitem">
  1807. <div class="memproto">
  1808. <table class="mlabels">
  1809. <tr>
  1810. <td class="mlabels-left">
  1811. <table class="memname">
  1812. <tr>
  1813. <td class="memname">friend class <a class="el" href="class_database.htm">Database</a></td>
  1814. </tr>
  1815. </table>
  1816. </td>
  1817. <td class="mlabels-right">
  1818. <span class="mlabels"><span class="mlabel">friend</span></span> </td>
  1819. </tr>
  1820. </table>
  1821. </div><div class="memdoc">
  1822. </div>
  1823. </div>
  1824. <a id="a86948d67f912f2e3e6d1a2674cd0814e"></a>
  1825. <h2 class="memtitle"><span class="permalink"><a href="#a86948d67f912f2e3e6d1a2674cd0814e">&#9670;&nbsp;</a></span>PreparedQuery</h2>
  1826. <div class="memitem">
  1827. <div class="memproto">
  1828. <table class="mlabels">
  1829. <tr>
  1830. <td class="mlabels-left">
  1831. <table class="memname">
  1832. <tr>
  1833. <td class="memname">friend class <a class="el" href="class_prepared_query.htm">PreparedQuery</a></td>
  1834. </tr>
  1835. </table>
  1836. </td>
  1837. <td class="mlabels-right">
  1838. <span class="mlabels"><span class="mlabel">friend</span></span> </td>
  1839. </tr>
  1840. </table>
  1841. </div><div class="memdoc">
  1842. </div>
  1843. </div>
  1844. <a id="a49982aa325e19f0956d42fde9132caa2"></a>
  1845. <h2 class="memtitle"><span class="permalink"><a href="#a49982aa325e19f0956d42fde9132caa2">&#9670;&nbsp;</a></span>Transaction</h2>
  1846. <div class="memitem">
  1847. <div class="memproto">
  1848. <table class="mlabels">
  1849. <tr>
  1850. <td class="mlabels-left">
  1851. <table class="memname">
  1852. <tr>
  1853. <td class="memname">friend class <a class="el" href="class_transaction.htm">Transaction</a></td>
  1854. </tr>
  1855. </table>
  1856. </td>
  1857. <td class="mlabels-right">
  1858. <span class="mlabels"><span class="mlabel">friend</span></span> </td>
  1859. </tr>
  1860. </table>
  1861. </div><div class="memdoc">
  1862. </div>
  1863. </div>
  1864. <hr/>The documentation for this class was generated from the following file:<ul>
  1865. <li>EasyQtSql/<a class="el" href="_easy_qt_sql___query_result_8h_source.htm">EasyQtSql_QueryResult.h</a></li>
  1866. </ul>
  1867. </div><!-- contents -->
  1868. </div><!-- doc-content -->
  1869. <!-- start footer part -->
  1870. <div id="nav-path" class="navpath"><!-- id is needed for treeview function! -->
  1871. <ul>
  1872. <li class="navelem"><a class="el" href="class_query_result.htm">QueryResult</a></li>
  1873. <li class="footer">Generated by
  1874. <a href="http://www.doxygen.org/index.html">
  1875. <img class="footer" src="doxygen.png" alt="doxygen"/></a> 1.8.14 </li>
  1876. </ul>
  1877. </div>
  1878. </body>
  1879. </html>