pcsoft.us.windevCopyright 2026, PC SOFT17 Nov 2020 15:42:53 Z24 Jan 2018 10:51:35 ZHi guys, I just wonder what is the proper way to do something like this: I've got a Windows CE barcode scanner that saves some data to a local HFSQL table (lets call it SERNUM). The user of this scanner should be able to transfer this data to a HFSQL client/server database. So, here is my idea: I open a connection to the CS database and open the table with the same name SERNUM. Then I loop through each record of my local SERNUM and transfer the data to the server SERNUM (if it doesn't already exist on the server). So far I couldn't even find out if I can have two connected connections at the same time. Also, I can't find if HCopyFile() is able to merge data into the target file or if it is going to replace the data. Well, I know there is replication build in but I don't want to go that far for just one table. Are there other ideas? Anybody have experiance with this? Thanks in advance Sebastian -- http://arnoldconsult.de WinDev 21 with Oracle, WinDevMobile Android Apps and Motorola Windows CE Mobile Barcode Scanners, Python 3 with Oracle and MySQL30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64155-wdm21-proper-way-synchronize-hfsql-data-between-local/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)markus_maderholzpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64155-wdm21-proper-way-synchronize-hfsql-data-between-local-68121/read.awp17 Nov 2020 15:42:53 ZIs there a proper solution for the management of disconnecting/reconnecting? Could somebody might share it with me? :) And y…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64155-wdm21-proper-way-synchronize-hfsql-data-between-local-68121/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64155-wdm21-proper-way-synchronize-hfsql-data-between-local-68121/read.awp[WDM21] Proper Way Synchronize HFSQL Data between Local and Client/Serverfromwebpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64155-wdm21-proper-way-synchronize-hfsql-data-between-local-64208/read.awp26 Jan 2018 14:01:27 ZHi Arnold, > > you are right. This is replication. To be honest, I'm a little afraid > (or lazy?) to install a replication …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64155-wdm21-proper-way-synchronize-hfsql-data-between-local-64208/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64155-wdm21-proper-way-synchronize-hfsql-data-between-local-64208/read.awp[WDM21] Proper Way Synchronize HFSQL Data between Local and Client/ServerSebastian Arnoldpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64155-wdm21-proper-way-synchronize-hfsql-data-between-local-64203/read.awp26 Jan 2018 11:10:27 ZMerci beaucoup Fabrice, you are right. This is replication. To be honest, I'm a little afraid (or lazy?) to install a replica…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64155-wdm21-proper-way-synchronize-hfsql-data-between-local-64203/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64155-wdm21-proper-way-synchronize-hfsql-data-between-local-64203/read.awp[WDM21] Proper Way Synchronize HFSQL Data between Local and Client/Serverfromwebpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64155-wdm21-proper-way-synchronize-hfsql-data-between-local-64158/read.awp24 Jan 2018 13:24:54 ZHi Sebastian, you can do it with a double connection, a flag in your file to know if synchronise or not, and record by reco…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64155-wdm21-proper-way-synchronize-hfsql-data-between-local-64158/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64155-wdm21-proper-way-synchronize-hfsql-data-between-local-64158/read.awp[WDM21] Proper Way Synchronize HFSQL Data between Local and Client/Server