Transactions, Commits and Rollbacks

[Joseph Morgan]

Wouldn't the following work to update multiple records?:

UpdateAllRecords( inSet as VSet = nil )



On Oct 11, 2013, at 10:37 AM, François Van Lerberghe 	<frvanlerberghe at gmail.com> wrote:

> Ruslan is certainly more competent than me to comment, but AFAIK, Valentina
> engine doesn't have this features. At least not completely.
> 
> Basically, when I want to update a record,
> 1) I make a cursor (using the class way) in write or nolock mode
>    myVCursor = Vdatabase.SqlSelect(mySqlClause...)
> 2) update the fields values needed
>    myVCursor.Field(1).value = "someValue"
> 3) and end issuing an update command
>    myVCursor.UpdateRecord
> This last command is similar to a "commit"
> 
> But when you want update multiple records/tables, this is a problem (I
> think).
> On the other hand, Valentina server as a journaling feature that protect you
> against a failure during a complex update.
> 
> I'm really waiting this feature (see one my previous post this week).
> 
> François Van Lerberghe
> Rue Thier Monty, 15 A
> 4570 Marchin
> +32 (0)85 25 08 25
> 
> 
> le 11/10/13 14:28, Johnny Harris <johnny at southshore.com> a écrit :
> 
>> I¹ve been reading the Valentina documentation and I¹ve not found any
>> information regarding transactions, commits or rollbacks.
>> 
>> if these don¹t exist in Valentina, what in the best practice for ensuring all
>> transactions finish successfully?
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20131011/6f145289/attachment.html>