Transactions, Commits and Rollbacks

[Fran=?ISO-8859-1?B?5w==?=ois Van Lerberghe]

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?