Transactions, Commits and Rollbacks

[Joseph Morgan]

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