andy
Posts: 183
|
Posted: 03/03/2010, 5:42 AM |
|
It would be great to add support for transactions particularly on master/detail pages.
Purpose: To make changes to the detail table which are only committed when the related master record is successfully updated.
Whilst it is possible to add
"START TRANSACTION" AND "COMMIT" queries to the beforeshow and AfterUpdate events, respectively
as soon as you attempt to enforce transaction control to different objects on the same page, it remains isolated.
Implementations for Editable grids are particularly difficult!!
There are so many implementations for this, I think it would merit consideration for inclusion in a future release.
_________________
Andy
RAD tools for rich UI controls:
http://www.koolphptools.com |
|
|
datadoit
|
Posted: 03/03/2010, 11:48 AM |
|
That's deep stuff Andy. But I like the idea!
|
|
|
andy
Posts: 183
|
Posted: 03/03/2010, 11:53 AM |
|
The only way I can do it at the moment is by shuffling data into and out of temporary tables to mimic the principle of database transactions with commit / rollback.
It's a bit arduous!!! But it does work.
_________________
Andy
RAD tools for rich UI controls:
http://www.koolphptools.com |
|
|
walkermore
Posts: 1
|
Posted: 07/07/2010, 12:17 AM |
|
Quote andy:
It would be great to add support for transactions particularly on master/detail pages.
Purpose: To make changes to the detail table which are only committed when the related master record is successfully updated.
Whilst it is possible to add
"START TRANSACTION" AND "COMMIT" queries to the beforeshow and AfterUpdate events, respectively
as soon as you attempt to enforce transaction control to different objects on the same page, it remains isolated.
Implementations for Editable grids are particularly difficult!!
There are so many implementations for this, I think it would merit consideration for inclusion in a future release.
Sounds all good to me
_________________
justin pit |
|
|
Oper
Posts: 1195
|
Posted: 07/10/2010, 5:58 PM |
|
Add my Vote Here!
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|