<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Hi Barry,<div><br></div><div>Sorry to be so thick, but I just don't understand your code.</div><div><br></div><div>Greg</div><div><br><div><div>On 12/09/2009, at 5:24 PM, Barry G. Sumpter wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><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-align: auto; 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; "> while vCurs.NextRecord_ODBC<br><br><br> 'intCntr = intCntr + 1<br> 'arrayList.AddRow cstr(intCntr) + ") " + mRS.StringField(1).GetString +<br>mRS.StringField(2).GetString<br><br> 'msgbox vCurs.StringField(2).Name<br> RecID = val(vCurs.StringField("RecID").getString)<br> TabName =(vCurs.VarCharField("TabName").getString)<br> Heading = (vCurs.VarCharField("Heading").getString)<br> Prompt = (vCurs.VarCharField("Prompt").getString)<br> Sequence = (vCurs.VarCharField("Sequence").getString)<br> maxLength = (vCurs.VarCharField("maxLength").getString)<br> Adjust = (vCurs.VarCharField("Adjust").getString)<br> Bold = (vCurs.VarCharField("Bold").getString)<br> MultiSelect = (vCurs.VarCharField("MultiSelect").getString)<br> multiSelectPrompt = (vCurs.VarCharField("multiSelectPrompt").getString)<br><br> .....<span class="Apple-converted-space"> </span><br><br><span class="Apple-tab-span" style="white-space: pre; "> </span>'Do something<br> .....<br>Wend<br><br><br><br>-----Original Message-----<br>From:<span class="Apple-converted-space"> </span><a href="mailto:valentina-bounces@lists.macserve.net">valentina-bounces@lists.macserve.net</a><br>[<a href="mailto:valentina-bounces@lists.macserve.net">mailto:valentina-bounces@lists.macserve.net</a>] On Behalf Of Greg Olson-Hyde<br>Sent: Saturday, 12 September 2009 4:37 PM<br>To: Valentina Developers<br>Subject: Progress being made - need more help.<br><br>Hi All,<br><br>First up, thanks to everyone who has helped me so far. When attempting <br>to compile my app using Valentina, I have managed to get the errors <br>down from 747, to 157 - a great sense of satisfaction - due to the <br>help offered by you all.<br><br>The next step for me is to understand how to deal with with the cursor <br>regarding records. The following are what I use in SQLite but don't <br>seem to have equivalents in Valentina:<br><br>RecordSet.Edit<br><br>RecordSet.InsertRecord<br><br>RecordSet.Commit - Is UpdateRecord the same as Commit?<br><br>From what I have read Valentina does not deal with VCursor in the <br>same way as SQLite deals with a RecordSet in RB - but I can't figure <br>out how!</span></blockquote></div><br></div></body></html>