pcsoft.us.windevCopyright 2026, PC SOFT26 Feb 2015 07:11:00 Z20 Feb 2015 14:27:00 ZHello All, I am trying to import data from a remote DB which is MySQL and I am using the web service Php2WM. I am able to get the data from remote MySQL server and insert the same in Android App's DB. But the problem is that when the data imported the Rec ID are not getting imported as per original data on remote MySQL DB. They are being assigned automatically as the Android Apps DB. How can I import the data as it is from remote MySQL as it is? TIA Yogi Yang30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50558-wm17-import-data-from-remote-android-app/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50558-wm17-import-data-from-remote-android-app-50687/read.awp26 Feb 2015 07:11:00 ZArie, Quote Arie try to wrap your loop in a transaction SQLTransaction(sqlStart,CONNECTION_NAME) WHILE END …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50558-wm17-import-data-from-remote-android-app-50687/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50558-wm17-import-data-from-remote-android-app-50687/read.awpWM17 - Import data from remote DB to Android App DBguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50558-wm17-import-data-from-remote-android-app-50570/read.awp20 Feb 2015 20:59:00 ZAnother thing I found out is refreshing the screen can cost time. I remember showing a progressbar and incremented is on every …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50558-wm17-import-data-from-remote-android-app-50570/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50558-wm17-import-data-from-remote-android-app-50570/read.awpWM17 - Import data from remote DB to Android App DBguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50558-wm17-import-data-from-remote-android-app-50569/read.awp20 Feb 2015 20:56:00 ZHi, try to wrap your loop in a transaction SQLTransaction(sqlStart,CONNECTION_NAME) WHILE END SQLTransaction(sqlCommit,CO…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50558-wm17-import-data-from-remote-android-app-50569/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50558-wm17-import-data-from-remote-android-app-50569/read.awpWM17 - Import data from remote DB to Android App DBguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50558-wm17-import-data-from-remote-android-app-50568/read.awp20 Feb 2015 19:10:00 ZHi again you can use hcreation to delete the whole file and recreating it empty in one line and very fast After that, you st…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50558-wm17-import-data-from-remote-android-app-50568/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50558-wm17-import-data-from-remote-android-app-50568/read.awpWM17 - Import data from remote DB to Android App DBguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50558-wm17-import-data-from-remote-android-app-50564/read.awp20 Feb 2015 16:22:00 ZNow I am facing speed problems while importing data. What I am doing it first deleting all the data in the file in question a…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50558-wm17-import-data-from-remote-android-app-50564/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50558-wm17-import-data-from-remote-android-app-50564/read.awpWM17 - Import data from remote DB to Android App DBguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50558-wm17-import-data-from-remote-android-app-50562/read.awp20 Feb 2015 15:36:00 ZFabrice, Thanks for the hint. Actually from the docs I understood that we have to use hSetIdAuto. And I was using that so I w…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50558-wm17-import-data-from-remote-android-app-50562/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50558-wm17-import-data-from-remote-android-app-50562/read.awpWM17 - Import data from remote DB to Android App DBguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50558-wm17-import-data-from-remote-android-app-50560/read.awp20 Feb 2015 14:40:00 ZHi if you are using a local HF DB if you are talking about automatic ID If you are adding your records using hAdd then you…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50558-wm17-import-data-from-remote-android-app-50560/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50558-wm17-import-data-from-remote-android-app-50560/read.awpWM17 - Import data from remote DB to Android App DB