Transactions, Commits and Rollbacks

[Johnny Harris]

Thanks for the info Bart.

I'm going to miss transactions and hope I it gets implemented soon.

Regards,
Johnny Harris

-----Original Message----- 
From: Bart Pietercil
Sent: Friday, October 11, 2013 10:40 AM
To: Valentina Developers
Subject: Re: Transactions, Commits and Rollbacks

As I said earlier, there are for the moment no transactions and hence no 
commits or rollbacks in the valentina products.
Journaling has been added to the 5 series as a first step towards 
transactions.

There is now no way to do rollbacks (except for non production environments, 
taking a backup)

Transactions are on the planning for Valentina.
Ruslan can  you tell more ?

regards

b.


On 11 Oct 2013, at 17:27, Joseph Morgan <joseph at checkos.com> wrote:

> I also typically use SQL. But I'm switching over to more class based 
> approach for easier to read/write code. Also I believe I can "centralize" 
> all the SQL queries and executes in one place for a more simple way to 
> update code. I will guess that there is a slight performance trade off but 
> for me it would be negligible. Also the SQL is still there if needed.
>
>
>> On Oct 11, 2013, at 10:18 AM, "Johnny & Karen Harris" 
>> <johnny at southshore.com> wrote:
>>
>> Thanks Joseph,
>>
>> That's reassuring to know. I've not looked at the vtable class yet.
>> I plan to check it out soon. Habit for me is to write SQL queries but
>> I wonder if there are any speed advantages to using the VTable class?
>> I think from a coding point of view it would be faster but I wonder
>> about any gains in query performance.
>>
>> Regards,
>> Johnny Harris
>>
>>> I think you're correct about the commits as I haven't needed to use them
>>> at all thus far. I have been using vtable class to add/update records.
>>>
>>> On Oct 11, 2013, at 8:54 AM, "Johnny & Karen Harris"
>>> <johnny at southshore.com> wrote:
>>>
>>>>> Hi Everyone,
>>>>>
>>>>> 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?
>>>>>
>>>>> If they do, could someone point me in the direction of the
>>>>> documentation?
>>>>>
>>>>> Best Regards To Everyone,
>>>>>
>>>>> Johnny Harris_______________________________________________
>>>>> Valentina mailing list
>>>>> Valentina at lists.macserve.net
>>>>> http://lists.macserve.net/mailman/listinfo/valentina
>>>>
>>>> I found in the documentation that those are reserved words, so I'll
>>>> assume
>>>> that transactions do exist. I'll try it out in some code.
>>>>
>>>> I guess Valentina will commit all changes automatically unless "BEGIN"
>>>> is
>>>> used?
>>>>
>>>> Regards,
>>>>
>>>> Johnny Harris
>>>>
>>>>
>>>> _______________________________________________
>>>> 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
>>>
>>
>>
>>
>> _______________________________________________
>> 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

_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina