<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Hi all,<div><br></div><div>Things are moving on well. But I am having a seniors moment with the VCursor.</div><div><br></div><div>In my old SQLite code, following a SELECT I have:</div><div><div> </div><div>RS.MoveNext</div><div><br></div><div>Which works. But, changing all my RecordSets to VCursors does not allow me to move to the next record, there appears to be no 'MoveNext' equivelant.</div><div><br></div><div>vCurs.MoveNext</div><div><br></div><div>Does not work. I used the RB autocomplete feature but can see nothing to allow a movement between records.</div><div><br></div><div>VTable on the other hand, DOES have a 'MoveNext'...Hmmmmmm</div><div><br></div><div>The <span class="Apple-style-span" style="font-family: 'Lucida Grande'; font-size: 12px; ">V4RB_Reference<span class="Apple-style-span" style="font-family: Helvetica; font-size: medium; "> says of VCursor "<span class="Apple-style-span" style="font-family: Arial; font-size: 11px; ">This class provides the result of the execution of a SQL SELECT statement. Valentina of-<span style="font: 12.0px Helvetica"> </span></span></span></span></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 11px/normal Arial; ">fers a cursor with a random access to the records.<span style="font: 12.0px Helvetica">" <span class="Apple-style-span" style="font-size: medium; ">So, it would appear that VCursor is the correct class to use, not VTable - but judjing by the evidence above, it looks as though I should be using VTable.</span></span></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 11px/normal Arial; "><font class="Apple-style-span" face="Helvetica"><span class="Apple-style-span" style="font-size: medium;"><br></span></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 11px/normal Arial; "><font class="Apple-style-span" face="Helvetica"><span class="Apple-style-span" style="font-size: medium;">If this is true why would Ruslan suggest that I change all my RecordSets to VCursors?</span></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 11px/normal Arial; "><font class="Apple-style-span" face="Helvetica"><span class="Apple-style-span" style="font-size: medium;"><br></span></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 11px/normal Arial; "><blockquote type="cite"><font class="Apple-style-span" face="Helvetica"><span class="Apple-style-span" style="font-size: medium;">RecordSets -- just do Find Replace over all project replace to VCursor</span></font></blockquote></div></div><br><div apple-content-edited="true"> <div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div>Yours as always in confusion,</div><div><br></div><div>Greg Olson-Hyde</div><div>Sydney Australia</div><div><br class="khtml-block-placeholder"></div><div><div><div>2.8 GHz Quad-Core Mac Pro</div><div>Mac OS X 10.5.8</div><div>RB 2009 r2.1 Pro</div><div>Valentina Studio Pro 4.2 trial</div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></span></div></span></div></div></body></html>