<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">In the Valentina Viki is described method Valentina.CopyCursorToNewTable() with example:<div><br></div><div><span class="Apple-style-span" style="color: rgb(51, 51, 51); font-family: Geneva, Arail, Helvetica, sans-serif; font-size: 12px; line-height: 18px; "><pre class="code vb" style="padding-top: 2ex; padding-right: 2ex; padding-bottom: 2ex; padding-left: 2ex; margin-top: 2ex; margin-right: 0px; margin-bottom: 2ex; margin-left: 2ex; font-size: 12px; border-top-width: 1px; border-right-width: 1px; border-bottom-width: 1px; border-left-width: 1px; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-color: rgb(207, 207, 207); border-right-color: rgb(207, 207, 207); border-bottom-color: rgb(207, 207, 207); border-left-color: rgb(207, 207, 207); color: rgb(51, 51, 51); overflow-x: auto; overflow-y: auto; background-color: rgb(247, 249, 250); border-top-left-radius: 8px; border-top-right-radius: 8px; border-bottom-right-radius: 8px; border-bottom-left-radius: 8px; -webkit-box-shadow: rgb(223, 223, 223) 3px 3px 5px; box-shadow: rgb(223, 223, 223) 3px 3px 5px; width: auto !important; "><span class="co1" style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; color: rgb(128, 128, 128); font-style: italic; ">' Let db1 is a remote database under some Valentina Server.</span>
VCursor curs = db1.<span class="me1" style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; color: rgb(0, 102, 0); ">SqlSelect</span><span class="br0" style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; color: rgb(102, 204, 102); ">(</span>
<span class="st0" style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; color: rgb(255, 0, 0); ">"SELECT * FROM tblPerson WHERE fldAge = 25 and fldIsMarried = false"</span>,
kClientSide, kReadOnly <span class="br0" style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; color: rgb(102, 204, 102); ">)</span>
<span class="co1" style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; color: rgb(128, 128, 128); font-style: italic; ">' Create RAM based TMP database on client side:</span>
VDatabase pLocalRamDB = <span class="kw1" style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; color: rgb(177, 177, 0); ">new</span> VDatabase<span class="br0" style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; color: rgb(102, 204, 102); ">(</span> kRAM <span class="br0" style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; color: rgb(102, 204, 102); ">)</span>
pLocalRamDb.<span class="me1" style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; color: rgb(0, 102, 0); ">Create</span><span class="br0" style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; color: rgb(102, 204, 102); ">(</span> <span class="st0" style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; color: rgb(255, 0, 0); ">"DummyNameForRamDB"</span> <span class="br0" style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; color: rgb(102, 204, 102); ">)</span>
VTable pTblNotMarried25 = Valentina.<span class="me1" style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; color: rgb(0, 102, 0); ">CopyCursorToNewTable</span><span class="br0" style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; color: rgb(102, 204, 102); ">(</span> curs, pLocalRamDB, <span class="st0" style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; color: rgb(255, 0, 0); ">"tblNotMarried25"</span> <span class="br0" style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; color: rgb(102, 204, 102); ">)</span>
<span class="co1" style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; color: rgb(128, 128, 128); font-style: italic; ">' We can destroy cursor now, if it will not be used anymore.</span>
curs = nil</pre></span><div><br></div></div><div>How to use it in V4REV? Is it possible to use it in SQL way?</div><div><br></div><div>Marek</div></body></html>