Delphi For PHP Forums    


Go Back   Delphi-PHP Forums > Delphi4PHP NNTP Newsgroups > embarcadero.public.delphiphp.database
Forum Jump Register FAQ Members List Downloads Search Today's Posts Mark Forums Read

embarcadero.public.delphiphp.database This group is for all discussion about databases and using them with Delphi for PHP.

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 12th December 2007, 20:23
D4PHP Guru
 
Join Date: Nov 2007
Posts: 237
u.masotti is on a distinguished road
Default Firebird transactions

To make updates on firebird database is mandatory a transactional management.

I have Database opened, a datesat connected to that database, and now there are some standard solutions, AFAIK:
  1. startTransaction, Edit, change field value, post, committransaction.
  2. startTransaction, update query ("UPDATE ... SET ... WHERE ...), committransaction
  3. writing code from scratch using ibase* functions
In a JSButtonClick event code, solutions 1. and 2. don't give errors, but simply do nothing!
I searched where code do transaction management... and found in dbtables.inc.php
PHP Code:
class Database extends CustomConnection
{
/* ...some code here... */
        
function beginTrans()
        {
            
$this->_connection->StartTrans();
        }

        function 
completeTrans($autocomplete=true)
        {
            return(
$this->_connection->CompleteTrans($autocomplete));
        }
/* ... some other code here ... */

       
$this->_connection ADONewConnection($this->DriverName); 
So I must investigate what happens in ADOdb.
I've seen videos demonstrating development in mysql, but there's no transactional management.
Any hint?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Sponsored Links
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are Off
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


All times are GMT +1. The time now is 04:52.




Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.3.0 ©2009, Crawlability, Inc.
Copyright © 2004 - 2009, G&J Solutions Ltd. All Rights Reserved. terms of use