[Gambas-user] Sample using .begin, commit and roolback in mysql

[Ignatius Syofian]

On Friday 11 November 2005 16:49, Jose Daniel Santos Delgado wrote:

thanks Jose, it  so clear...

thank you again



> It's quite simple. The only thing you must bear in mind is that when
> you creates the database tables you must use a Datatype that admits
> transactions. For instantce: InnoDB.
>
> Once you to that, the process is straightforward:
>
> private m_db as Connection
>
> private sub whichEver(...)
>    m_db.Begin ()
>    m_db.Exec("INSERT INTO jander VALUES (1, 'hola', 'bye')
>    m_db.Exec("INSERT INTO peich VALUES (31, 'a gromenaüer')
>    ' (...)
>    if ''''' WhatEver must rollback
>       m_db.RollBack()
>    endif
>
>    m_db.Commit()
>
>
> end sub
>
>
>
> Sorry if it's not a very elaborated answer: ;)
>
> 2005/11/11, Ignatius Syofian <isy21 at ...1082...>:
> > Hi, all
> >
> > can i have some example using db.begin, db.commit and db.rollback in
> > mysql ?
> >
> > present i use direct update without using db.commit or  db.roolback
> >
> > thanks before
> >
> >
> > --
> > Regards,
> >
> > Ignatius Syofian
> >
> >
> >
> > -------------------------------------------------------
> > SF.Net email is sponsored by:
> > Tame your development challenges with Apache's Geronimo App Server.
> > Download it for free - -and be entered to win a 42" plasma tv or your
> > very own Sony(tm)PSP.  Click here to play:
> > http://sourceforge.net/geronimo.php
> > _______________________________________________
> > Gambas-user mailing list
> > Gambas-user at lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/gambas-user
>
> -------------------------------------------------------
> SF.Net email is sponsored by:
> Tame your development challenges with Apache's Geronimo App Server.
> Download it for free - -and be entered to win a 42" plasma tv or your very
> own Sony(tm)PSP.  Click here to play: http://sourceforge.net/geronimo.php
> _______________________________________________
> Gambas-user mailing list
> Gambas-user at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user

-- 
Regards,

Ignatius Syofian