Transactions, Commits and Rollbacks

[Joseph Morgan]

Hi Johnny,

Can you provide an example of what functionality you are looking to achieve? (As far as dealing with records in different table)

Joseph 

> On Oct 11, 2013, at 5:42 PM, "Johnny Harris" <johnny at southshore.com> wrote:
> 
> Thanks for the Info François. My main concern is how to deal with records in multiple tables.
> 
> Maybe Ruslan will get time to suggest the best method available with Valentina in the
> absence of transactions.
> 
> Best Regards,
> Johnny Harris
> 
> -----Original Message----- From: François Van Lerberghe
> Sent: Friday, October 11, 2013 10:37 AM
> To: Valentina List
> Subject: Re: Transactions, Commits and Rollbacks
> 
> 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 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina