FiveTech Support Forums

FiveWin / Harbour / xBase community
Board index FiveWin for Harbour/xHarbour MySql Transaction and oRs:Save()
Posts: 1067
Joined: Wed Nov 09, 2005 02:17 AM
MySql Transaction and oRs:Save()
Posted: Tue Jul 09, 2024 01:17 PM

Do you know if there is a transaction control inside oRs:Save()?

If there is, is possible disable it ?

Sds,
Vilian F. Arraes
vilian@vfatec.com.br
Belém-Pa-Brazil
Posts: 474
Joined: Sun Oct 30, 2005 06:37 AM
Re: MySql Transaction and oRs:Save()
Posted: Wed Jul 10, 2024 02:10 AM

if set autocommit=0;

//oserver:query("set autocommit=0")

oserver:query(" start transaction")

... update/sve/insert/delete sql

if ... error

 oserver:query("rollback")

else

 oserver:query("commit")

end

//

if set autocommit=1;

... single sql  include commit /rollback
http://www.xtech2.top
Mobile:(86)13802729058
Email:100200651@qq.com
QQ:100200651
Weixin: qq100200651
Posts: 1067
Joined: Wed Nov 09, 2005 02:17 AM
Re: MySql Transaction and oRs:Save()
Posted: Wed Jul 10, 2024 11:02 AM
Sds,
Vilian F. Arraes
vilian@vfatec.com.br
Belém-Pa-Brazil

Continue the discussion