[Lazarus] TSQLTransaction.Action property not implemented

Chris Crori crori49 at yahoo.com
Wed Aug 7 11:43:04 CEST 2013


Good point, any of my validation checks may be outdated in an update...
stupid of me not to think about that, thanks!

-----Αρχικό μήνυμα----- 
From: Michael Van Canneyt
Sent: Wednesday, August 07, 2013 12:19 PM
To: Lazarus mailing list
Subject: Re: [Lazarus] TSQLTransaction.Action property not implemented



On Wed, 7 Aug 2013, Chris Crori wrote:

> Thanks! :)
> I just reinstalled my Operating systems so i haven't looked up the trunk 
> for
> a while, i guess i have to!!! :P
> The main idea is to build a form that "autosaves" any changes, so i have 
> to
> explicitly call just rollback uppon cancelation. Is there another reason 
> to
> prefer to call Commit myself?

Yes.
The data in the form may be invalid, in which case the 
insert/update/whatever may fail.

Michael.
>
> -----Αρχικό μήνυμα----- 
> From: Michael Van Canneyt
> Sent: Wednesday, August 07, 2013 11:49 AM
> To: Lazarus mailing list
> Subject: Re: [Lazarus] TSQLTransaction.Action property not implemented
>
>
>
> On Wed, 7 Aug 2013, Chris Crori wrote:
>
>> Hi guys,
>>     i was under the impression that the “Action” property had a value in
>> TSQLTransaction component...
>> correct me if i am wrong but in testing i did and in code (sqldb.pp) i 
>> saw
>> that it doesn’t matter the value i put in the property, the default 
>> action
>> when a transaction closes is rollback.
>>
>> And now the question part
>>     a) am i right?
>
> Yes.
>
>>     b) is this a todo?
>
> No, it is already done in trunk.
>
>>     c) is there a timeline?
>
> It is done.
>
> In SQLDB, it is better to call explicitly Commit, Rollback or
> RollBackRetaining.
> It may require a typecast:
>
> (Q.Transaction as TSQLTransaction).Commit;
>
> Unless you have the transaction object declared somewhere, in which case 
> you
> don't need the typecast.
>
> Michael.
>
>
>
>
>
> --
> _______________________________________________
> Lazarus mailing list
> Lazarus at lists.lazarus.freepascal.org
> http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
>
>
> --
> _______________________________________________
> Lazarus mailing list
> Lazarus at lists.lazarus.freepascal.org
> http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
>





--
_______________________________________________
Lazarus mailing list
Lazarus at lists.lazarus.freepascal.org
http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus 





More information about the Lazarus mailing list