Dismiss Notice

REGISTRATION IS AFTER ADMIN ACTIVATION

DONATIONS WITH PAYPAL CLICK TO BUTTON

3 MONTHS VIP - 10$; 6 MONTHS VIP - 20$; 1 YEAR VIP - 30$; 2 YEARS VIP - 50$; GOLD USER FOR LIFE VIP - 150$

DONATIONS WITH Bitcoin Address:3NRs3CK3fhXifrNYxHEZKpETDd9vNLMsMD

Dismiss Notice
The registration is approved by the Administrator. It takes about 1 day to approve your registration
Dismiss Notice
For open hidden message no need write thanks, thank etc. Enough is click to like button on right side of thread.

One Commit on Two ADO Connection

Discussion in 'Delphi Help&Requests' started by astmzh, Jan 15, 2015.

  1. astmzh
    Offline

    astmzh DF Member

    I have a POS application connected to local SQLDB, i want to mke a service or a small program to move data from Local DB to online Server.

    Two ado connection
    one connect to local DB and read the new records, second connection to the Remote DB and inserts the records.

    Steps
       1- Connection1 Reads from Local DB into a DataSet1
       2- Connection2 Insert into Remote DB, (From DatasSet1)
       3- Update local DB records as "Moved"

    My problem is
       I want to have one commit for both connection, because connection to the Remote DB might be lost.
     

Share This Page

Laws
Our website, law, laws, copyright and aims to be respectful of individual rights. Our site, as defined in the law of 5651 serves as a provider of space. According to the law, contrary to the law of site management has no obligation to monitor content. Therefore, our site has adopted the principle of fit and remove. Works are subject to copyright laws and is shared in a manner that violated their legal rights, or professional associations, rights holders who, adsdelphi@gmail.com I can reach us at e-mail address. Complaints considered to be infringing on the examination of the content will be removed from our site.
Donate Help To Us and Be VIP
DONATIONS WITH PAYPAL CLICK TO BUTTON
6 MONTHS VIP - 20$; 1 YEAR VIP - 30$; 2 YEARS VIP - 50$; GOLD USER FOR LIFE VIP - 150$
Social Block