Search found 130 matches: transactions

Return to advanced search

mariadb and transaction

Hello, I currently use a customized version of tmysql which I modify to be able to use transactions in an easy way, currently after using calls to the query and execute methods, it is necessary to validate if there is an error to display a message, I have added a data ...
by carlos vargas
Fri Jan 24, 2020 10:03 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: mariadb and transaction
Replies: 0
Views: 376

Re: FWH 18.11: MARIAROWSET Table Replication Features

... table. 4. Now have a windows service running on the server that takes care of connecting to all subscriptions to post all pending transactions on the queue. In this manner it doesn't matter if the replication server is up or down or connection has been lost. If a target database ...
by reinaldocrespo
Wed Oct 02, 2019 4:59 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: FWH 18.11: MARIAROWSET Table Replication Features
Replies: 11
Views: 2675

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>  ...
by nageswaragunupudi
Thu Jul 11, 2019 1:06 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Editar RowSet con dos tablas - At. Mr. Rao
Replies: 15
Views: 3021

Re: TPrinter: Recommended way to print zebra line effect

Thanks Rao.

However I need it to encompass multi line because I want transactions belonging to the same document are grouped with the same colour

Image
by hua
Tue Apr 30, 2019 9:07 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: TPrinter: Recommended way to print zebra line effect
Replies: 3
Views: 530

accounting system

... accounting (also known as "double entry accounting". "Double entry accounting" is an accounting system that records business transactions twice: Business transactions are posted to two accounts, the account and the contra account. Compared to simple bookkeeping, double-entry ...
by Otto
Fri Mar 15, 2019 3:14 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: accounting system
Replies: 6
Views: 1330

Re: FWH 18.11: MARIAROWSET Table Replication Features

... or none at all. Any Function that does truncate all the tables of replication server and copy all table's data from Main to Replication ? Then the transactions are written to the main server only. Subsequent resumption of replication results in totally unreliable results. Only way is to copy the ...
by shri_fwh
Thu Nov 29, 2018 9:05 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: FWH 18.11: MARIAROWSET Table Replication Features
Replies: 11
Views: 2675

Re: FWH 18.11: MARIAROWSET Table Replication Features

... if both the servers are not working, i.e., if one of the servers is off. Replication can be turned off by setting oRs:oCn2 to nil. Then the transactions are written to the main server only. Subsequent resumption of replication results in totally unreliable results. Only way is to copy the ...
by nageswaragunupudi
Wed Nov 28, 2018 4:18 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: FWH 18.11: MARIAROWSET Table Replication Features
Replies: 11
Views: 2675

FWH 18.11: DBF to MySql Replication with TDataBase

... all changes (append,edit,delete) made to the DBF to a remote MariaDB server. While we may take backups daily, we are always at the risk of losing transactions between successive backups. This feature helps backing up each transaction as and when it occurs. Requisites: 1) The DBF should contain ...
by nageswaragunupudi
Tue Nov 27, 2018 11:26 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: FWH 18.11: DBF to MySql Replication with TDataBase
Replies: 2
Views: 881

FWH 18.11: DBF to MySql Replication with TDataBase

... all changes (append,edit,delete) made to the DBF to a remote MariaDB server. While we may take backups daily, we are always at the risk of losing transactions between successive backups. This feature helps backing up each transaction as and when it occurs. Requisites: 1) The DBF should contain ...
by nageswaragunupudi
Tue Nov 27, 2018 11:22 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: FWH 18.11: DBF to MySql Replication with TDataBase
Replies: 5
Views: 1653

Re: Apollo

... managger) I'm tesing right now. It's easy to make it wotk. In my test I did not use data objects till now, I'll will test. I,m not use transactions now, because I'm just testing. Transactions are supported, look into FAQ. 2.17 b3 version is the last (2016). I believe that this project ...
by D.Fernandez
Mon Dec 04, 2017 7:34 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Apollo
Replies: 13
Views: 3387

Re: Apollo

Ruben,

It looks like the site has not been updated in over a year. Is that still an active product ? Have you used it with FWH ? How about data objects ? Are transactions separate or do all database calls need to be revised to the transaction model shown in the FAQ ?

Thanks

Tim
by TimStone
Mon Dec 04, 2017 6:08 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Apollo
Replies: 13
Views: 3387

Re: xBrowse as record adding tool for data tables

... probably works the same for most SQL engines. I've always gathered new data to be inserted using a dialog. I was hoping for this particular small transactions tables where I store changes on section 8 portions assigned to the tenant, to use the very same xbrowse row edit capabilities. But that ...
by reinaldocrespo
Tue Oct 24, 2017 9:35 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: xBrowse as record adding tool for data tables
Replies: 16
Views: 3050

Request for feedback for SQL

... utilize? I have seen a lot about MarioDB and wanted feedback on best SQL. There is an expectation that system may be processing more than 1000 transactions per week. Thank you in advance for your help!
by cdmmaui
Thu Oct 12, 2017 3:22 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Request for feedback for SQL
Replies: 7
Views: 1346

Re: Error from ADO

... 3        // lockoportunistic  Questions .. 1) I presume this is a network mulit-user application ? 2) If Yes, does this application have a lot of transactions that may change quickly and make a buffered up oRs on a client machine stale ? Generally speaking .. I like the Local Cache parameter because ...
by Rick Lipkin
Sat Jul 22, 2017 1:34 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Error from ADO
Replies: 14
Views: 3503

Re: MySql, MariaDB and PostgeSQL are FWMARIADB's compatible?

... depend on many factors including our database design. Even then it is considered a serious issue by organizations who have a hit rate of several transactions per second. Even there, there are several ways of fine tuning server and database performance. When we are using extremely primitive libraries ...
by nageswaragunupudi
Wed May 31, 2017 2:58 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: MySql, MariaDB and PostgeSQL are FWMARIADB's compatible?
Replies: 9
Views: 1908
PreviousNext

Return to advanced search