CodeCharge Studio
search Register Login  

Visual PHP Web Development

Visually Create Internationalized Web Applications, Web Reports, Calendars, and more.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> Wishes

 Support for transaction control on master/detail pages

Print topic Send  topic

Author Message
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
View profile  Send private message
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
View profile  Send private message
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
View profile  Send private message
Oper


Posts: 1181
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
View profile  Send private message

Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

MS Access to Web

Convert MS Access to Web.
Join thousands of Web developers who build Web applications with minimal coding.

CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright 2003-2004 by UltraApps.com  and YesSoftware, Inc.