Search found 130 matches: transactions

Return to advanced search

Re: Transaction security with DBF

... is completed. This ensures that no one else can make any changes until the transaction is committed or abandoned. For more information on transactions, see BEGINTRANS( ). OODML Call the rollback( ) method of the Database object.
by Otto
Fri Sep 09, 2022 6:30 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: Transaction security with DBF
Replies: 9
Views: 722

Re: Transaction security with DBF

Dear Otto
Perhaps the integrity of transactions made using the harbor RDDLOG is easier. It should be implemented conveniently, obviously, checking if the RDDLOG is executed in the event that there has been an error in the transaction.
by cnavarro
Wed Aug 31, 2022 9:50 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Transaction security with DBF
Replies: 9
Views: 722

Re: Very strange problem - ideas needed

... appears to be good, it is the one variable I haven't yet isolated. She tried it herself, but it was after the process had been run, so all the transactions had been marked as completed, and thus nothing was picked up by the process. So I want to hit it fresh from a different machine. If it ...
by TimStone
Thu Aug 25, 2022 2:23 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: Very strange problem - ideas needed
Replies: 17
Views: 1593

Re: Clase Nativa MySql

... Insert(...), Upsert(...) and Update(...) This us provided to faclititate grouping of several DML statements/ methods inside TRY/CATCH block for Transactions. Example Usage: // -------- local lError := .f. oCn:BeginTransaction() oCn:lThrowError := .t. TRY oCn:Insert(....) oCn:Update(...) oCn:Execute( ...
by carlos vargas
Fri Jul 15, 2022 12:43 am
 
Forum: FiveWin para Harbour/xHarbour
Topic: Clase Nativa MySql
Replies: 18
Views: 1727

Re: Clase Nativa MySql

... .F.) is set to .T., method Execute() raises Run-time error, in case of any server error. We request to use this flag only locally when using transactions. oCn:lShowErrors := .t. // global settingoCn:lThrowError := .t. // local settingTRY   oCn:BeginTransaction()   for each cSql in ...
by nageswaragunupudi
Thu Mar 17, 2022 4:56 am
 
Forum: FiveWin para Harbour/xHarbour
Topic: Clase Nativa MySql
Replies: 18
Views: 1727

Re: Clase Nativa MySql

... and the execution goes to the next line, i.e., commit transaction and oCn:RollBack() is never executed. Also for saving to single table, transactions are not necessary. Recommended: if oRs:Save()   // Success   // appropriate codeelse   // failure  ...
by nageswaragunupudi
Wed Mar 16, 2022 3:37 am
 
Forum: FiveWin para Harbour/xHarbour
Topic: Clase Nativa MySql
Replies: 18
Views: 1727

Re: Clase Nativa MySql

... BB   BBBB  ID is the auto-increment primary field. User-A and User-B (and may be more users) are running our application inserting new transactions. Both users A and B (and also other users) will assume the next autoinc id will be 3, using the above function. Mr. A is about to commit ...
by nageswaragunupudi
Fri Mar 11, 2022 3:45 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Clase Nativa MySql
Replies: 18
Views: 1727

Re: SBUTTON vs BTNBMP

... tested the same code with BTNBMP buttons and SBUTTON button. Watching the Task Manager my program starts out at 15.2MB for both. After only 20 transactions the BTNBMP version is at 15.6MB while the SBUTTON version is at 19.6MB. I have tried putting a Memory(0) call at the end of each transaction, ...
by dutch
Fri Dec 24, 2021 2:47 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: SBUTTON vs BTNBMP
Replies: 18
Views: 1536

New FTDN November/Noviembre (FWH 21.11)

... Insert(...), Upsert(...) and Update(...) This us provided to faclititate grouping of several DML statements/ methods inside TRY/CATCH block for Transactions. Example Usage: // -------- local lError := .f. oCn:BeginTransaction() oCn:lThrowError := .t. TRY oCn:Insert(....) oCn:Update(...) oCn:Execute( ...
by Antonio Linares
Tue Nov 30, 2021 7:19 am
 
Forum: WhatsNew / Novedades
Topic: New FTDN November/Noviembre (FWH 21.11)
Replies: 2
Views: 938

SBUTTON vs BTNBMP

... tested the same code with BTNBMP buttons and SBUTTON button. Watching the Task Manager my program starts out at 15.2MB for both. After only 20 transactions the BTNBMP version is at 15.6MB while the SBUTTON version is at 19.6MB. I have tried putting a Memory(0) call at the end of each transaction, ...
by bradmaudlin
Mon Oct 25, 2021 9:18 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: SBUTTON vs BTNBMP
Replies: 18
Views: 1536

Re: MySql Nativa Transacciones. At. Mr. Rao

The only thing about transactions, the other thing is easy, someone else?
by carlos vargas
Sat Sep 18, 2021 5:10 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: MySql Nativa Transacciones. At. Mr. Rao
Replies: 26
Views: 2383

Documentation for variables - what form should it be?

Hi, This is more of a brainstorming question, rather than anything technical. I'd like to stop using my variant of hungarian notation, because it doesn't really look presentable, and it doesn't fit in with standard modern practice. The way I write variables is like Account_Number_n Customer_Name_edt...
by FWExplorer
Sun Feb 28, 2021 6:29 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Documentation for variables - what form should it be?
Replies: 9
Views: 917

Data management system

... ?) This helps while programming because I ofthen need to know hox the fieldname is... so all dbf's from a project are insite Database project 1 Transactions could be "FWSamples" Xbrwowse Settings for Xbrowse here a memo field where the sample code would be copied to from the forum ...
by Marc Venken
Fri Feb 26, 2021 3:39 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Data management system
Replies: 18
Views: 2101

Re: Editar RowSet con dos tablas - At. Mr. Rao

... oCn:Insert( table, fieldlist, aValues ) c) oCn:Upsert( table, fieldlist, aValues ) Whatever way you write data, you can enclose in Beging/Commit Transactions; Make a separate function to Write. Example: function WriteAll()  oCn:BeginTransaction()  <write to table1>  if oCn:nError ...
by Horizon
Wed May 27, 2020 12:00 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Editar RowSet con dos tablas - At. Mr. Rao
Replies: 15
Views: 2857

Re: Editar RowSet con dos tablas - At. Mr. Rao

... oCn:Insert( table, fieldlist, aValues ) c) oCn:Upsert( table, fieldlist, aValues ) Whatever way you write data, you can enclose in Beging/Commit Transactions; Make a separate function to Write. Example: function WriteAll()  oCn:BeginTransaction()  <write to table1>  if oCn:nError ...
by Horizon
Wed May 27, 2020 11:59 am
 
Forum: FiveWin para Harbour/xHarbour
Topic: Editar RowSet con dos tablas - At. Mr. Rao
Replies: 15
Views: 2857
Next

Return to advanced search