<html><head><meta http-equiv="Content-Type" content="text/html charset=iso-8859-1"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Wouldn't the following work to update multiple records?:<div><br></div><div><span style="background-color: rgb(247, 249, 250); color: rgb(51, 51, 51); font-size: 12px; line-height: 18px; text-align: justify; ">UpdateAllRecords</span><span class="br0" style="font-size: 12px; line-height: 18px; text-align: justify; padding: 0px; margin: 0px; color: rgb(102, 204, 102); ">(</span><span style="background-color: rgb(247, 249, 250); color: rgb(51, 51, 51); font-size: 12px; line-height: 18px; text-align: justify; "> inSet </span><span class="kw1" style="font-size: 12px; line-height: 18px; text-align: justify; padding: 0px; margin: 0px; color: rgb(177, 177, 0); ">as</span><span style="background-color: rgb(247, 249, 250); color: rgb(51, 51, 51); font-size: 12px; line-height: 18px; text-align: justify; "> VSet = nil </span><span class="br0" style="font-size: 12px; line-height: 18px; text-align: justify; padding: 0px; margin: 0px; color: rgb(102, 204, 102); ">)</span><div><br></div><div><br></div><div><br></div><div><div>On Oct 11, 2013, at 10:37 AM, François Van Lerberghe <span class="Apple-tab-span" style="white-space:pre"> </span><<a href="mailto:frvanlerberghe@gmail.com">frvanlerberghe@gmail.com</a>> wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite">Ruslan is certainly more competent than me to comment, but AFAIK, Valentina<br>engine doesn't have this features. At least not completely.<br><br>Basically, when I want to update a record,<br>1) I make a cursor (using the class way) in write or nolock mode<br> myVCursor = Vdatabase.SqlSelect(mySqlClause...)<br>2) update the fields values needed<br> myVCursor.Field(1).value = "someValue"<br>3) and end issuing an update command<br> myVCursor.UpdateRecord<br>This last command is similar to a "commit"<br><br>But when you want update multiple records/tables, this is a problem (I<br>think).<br>On the other hand, Valentina server as a journaling feature that protect you<br>against a failure during a complex update.<br><br>I'm really waiting this feature (see one my previous post this week).<br><br>François Van Lerberghe<br>Rue Thier Monty, 15 A<br>4570 Marchin<br>+32 (0)85 25 08 25<br><br><br>le 11/10/13 14:28, Johnny Harris <<a href="mailto:johnny@southshore.com">johnny@southshore.com</a>> a écrit :<br><br><blockquote type="cite">Iıve been reading the Valentina documentation and Iıve not found any<br>information regarding transactions, commits or rollbacks.<br><br>if these donıt exist in Valentina, what in the best practice for ensuring all<br>transactions finish successfully?<br></blockquote><br>_______________________________________________<br>Valentina mailing list<br><a href="mailto:Valentina@lists.macserve.net">Valentina@lists.macserve.net</a><br>http://lists.macserve.net/mailman/listinfo/valentina<br></blockquote></div><br></div></body></html>