pcsoft.us.windevCopyright 2026, PC SOFT13 Feb 2018 11:14:00 Z3 Feb 2018 13:53:00 ZHi All I think I may have found what may be an issue with data sources. The issue is most likely rather with me than with WX. I am needing to get my head into this black box. I have a data source [say test] declared. I then step through an array and for each element in the array I am calling say: HExecuteSQLQuery(test, "select * from customer where customer code = whatever") Whatever is a field in the array. I am getting intermittent results where the data source is not being cleared and filled with the new data. I did a bit of reading and came across: HCancelDeclaration(test) What does this actually do? Does it dispose of the data in test? Is it a good idea to invoke this after dealing with the data source and before getting ready to execute the next HExecuteSQLQuery? I hope that makes sense. Cheers André30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64380-data-source-best-practice/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64380-data-source-best-practice-64552/read.awp13 Feb 2018 11:14:00 Zccc2 - thanks for that. Well, this turned out to be a false alarm. But I have learnt a lot in the process. Hopefully others h…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64380-data-source-best-practice-64552/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64380-data-source-best-practice-64552/read.awpData Source Best PracticeVirtualSoftwarepcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64380-data-source-best-practice-64536/read.awp12 Feb 2018 10:07:53 ZHi Art Your still alive, you old fart My eMail is virtualsoft@outlook.com There are some issues I would rather talk to you ab…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64380-data-source-best-practice-64536/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64380-data-source-best-practice-64536/read.awpData Source Best Practiceguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64380-data-source-best-practice-64533/read.awp11 Feb 2018 18:16:00 ZHi, I always call hcanceldeclaration() before hexecutequery() . for HExecuteSQLQuery() no need. this is because early days…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64380-data-source-best-practice-64533/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64380-data-source-best-practice-64533/read.awpData Source Best Practiceguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64380-data-source-best-practice-64534/read.awp11 Feb 2018 14:44:00 ZHi Difference between data source and no data source: at the beginning, data sources did not exist in wlanguage... So w…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64380-data-source-best-practice-64534/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64380-data-source-best-practice-64534/read.awpData Source Best Practiceguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64380-data-source-best-practice-64532/read.awp10 Feb 2018 19:43:00 ZDerekT - "test" is the name Andre gave to his query. I would have called it QryPhones or some other such silly name. Andre - …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64380-data-source-best-practice-64532/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64380-data-source-best-practice-64532/read.awpData Source Best Practiceguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64380-data-source-best-practice-64535/read.awp10 Feb 2018 18:13:00 ZHi Art - I missed not declaring a DS - but I thought that was implicit if not declared. Fabrice - I did miss that but I do…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64380-data-source-best-practice-64535/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64380-data-source-best-practice-64535/read.awpData Source Best Practiceguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64380-data-source-best-practice-64531/read.awp10 Feb 2018 17:33:00 ZI understand what both you and Fabrice are saying but..... What is 'test' in your example? My take on this has always been t…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64380-data-source-best-practice-64531/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64380-data-source-best-practice-64531/read.awpData Source Best Practiceguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64380-data-source-best-practice-64527/read.awp10 Feb 2018 17:00:00 ZAlso I have an issue with your code, or maybe I just don't understand what you are trying to do. In this part of the code: IF…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64380-data-source-best-practice-64527/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64380-data-source-best-practice-64527/read.awpData Source Best Practiceguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64380-data-source-best-practice-64525/read.awp10 Feb 2018 16:50:00 ZAndre, let me take a stab at this. I am no expert, but I think I see where Fabrice is coming from. I think you are mixing con…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64380-data-source-best-practice-64525/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64380-data-source-best-practice-64525/read.awpData Source Best Practiceguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64380-data-source-best-practice-64526/read.awp10 Feb 2018 13:59:00 ZHi André, that is NOT what I was advising... Your do NOT need an array... just run the query WITHOUT declaring a data source.…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64380-data-source-best-practice-64526/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64380-data-source-best-practice-64526/read.awpData Source Best Practiceguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64380-data-source-best-practice-64509/read.awp9 Feb 2018 20:23:00 ZHi Fabrice I am 100% convinced now that the problem is with the data source. I have moved the query outside of the iteration …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64380-data-source-best-practice-64509/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64380-data-source-best-practice-64509/read.awpData Source Best Practiceguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64380-data-source-best-practice-64500/read.awp9 Feb 2018 12:30:00 ZHi André as you seem to think that your problem comes from the data source, did you try to run your code without using one? …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64380-data-source-best-practice-64500/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64380-data-source-best-practice-64500/read.awpData Source Best Practiceguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64380-data-source-best-practice-64482/read.awp8 Feb 2018 19:24:00 ZHi DerekT Specific in that the iteration calls this query for each record in this specific procedure. It does run consecut…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64380-data-source-best-practice-64482/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64380-data-source-best-practice-64482/read.awpData Source Best Practiceguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64380-data-source-best-practice-64468/read.awp8 Feb 2018 10:42:00 ZIs there a specific set of circumstances where your error occurs? Do you run this consecutively without closing the window in…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64380-data-source-best-practice-64468/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64380-data-source-best-practice-64468/read.awpData Source Best Practiceguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64380-data-source-best-practice-64465/read.awp8 Feb 2018 09:39:00 ZIt has not worked. Still get intermittent behaviour. Will have to take another route. :-(https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64380-data-source-best-practice-64465/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64380-data-source-best-practice-64465/read.awpData Source Best Practiceguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64380-data-source-best-practice-64404/read.awp5 Feb 2018 12:40:00 ZThanks to Fabrice and DerekT the problem appears to be sorted. It turns out that HFreeQuery uses HCancelDeclaration. Still te…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64380-data-source-best-practice-64404/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64380-data-source-best-practice-64404/read.awpData Source Best Practiceguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64380-data-source-best-practice-64393/read.awp3 Feb 2018 23:08:00 ZHi DerekT Cool. Never knew about HFreeQuery nor VariableReset. I am sure that this has been the issue all along. The 'P' i…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64380-data-source-best-practice-64393/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64380-data-source-best-practice-64393/read.awpData Source Best Practiceguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64380-data-source-best-practice-64392/read.awp3 Feb 2018 19:55:00 ZCancelling the query result is always important as is reseting any variables that have been used to insure that no 'historic' da…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64380-data-source-best-practice-64392/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64380-data-source-best-practice-64392/read.awpData Source Best Practiceguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64380-data-source-best-practice-64386/read.awp3 Feb 2018 15:44:00 ZHi Fabrice Thanks a ton for that. Then I think I may just have found my problem. Consider the code below: MyDataSource is …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64380-data-source-best-practice-64386/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64380-data-source-best-practice-64386/read.awpData Source Best Practiceguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64380-data-source-best-practice-64384/read.awp3 Feb 2018 15:26:00 ZHi André YES? you need to do a hcanceldeclaration after each query, or the result will stay in memory till the program ends, …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64380-data-source-best-practice-64384/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64380-data-source-best-practice-64384/read.awpData Source Best Practice