pcsoft.us.windevCopyright 2026, PC SOFT5 May 2020 05:34:22 Z24 May 2015 14:19:00 ZWD18 Hi, Is there a way of calling a global procedure from a Query in order to create a calculated item? Cheers Reg30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52261-calling-procedure-from-query/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)dariofmpeovichpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52261-calling-procedure-from-query-67811/read.awp5 May 2020 05:34:22 ZIt is possible to execute a procedure that performs a calculation, and the result integrates an Item of the query, but ... "the…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52261-calling-procedure-from-query-67811/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52261-calling-procedure-from-query-67811/read.awpCalling procedure from Queryguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52261-calling-procedure-from-query-52313/read.awp26 May 2015 17:26:00 ZThanks Mr Black...https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52261-calling-procedure-from-query-52313/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52261-calling-procedure-from-query-52313/read.awpCalling procedure from Queryguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52261-calling-procedure-from-query-52289/read.awp26 May 2015 04:22:00 ZI'm sure there are many ways to accomplish this. I use SPs from within queries using the query editor. This allows for complex c…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52261-calling-procedure-from-query-52289/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52261-calling-procedure-from-query-52289/read.awpCalling procedure from Queryguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52261-calling-procedure-from-query-52285/read.awp25 May 2015 20:32:00 ZI'm very much obliged guys, thanks for the help. Cheers Reg :rp:https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52261-calling-procedure-from-query-52285/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52261-calling-procedure-from-query-52285/read.awpCalling procedure from Queryguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52261-calling-procedure-from-query-52284/read.awp25 May 2015 19:25:00 ZYou can.... Once you have the query result you can treat it the same as file as far as WD is concerned. Personally I find it…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52261-calling-procedure-from-query-52284/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52261-calling-procedure-from-query-52284/read.awpCalling procedure from Queryguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52261-calling-procedure-from-query-52283/read.awp25 May 2015 19:17:00 ZSome good stuff here guys, thanks. I did not know it was possible to add records to a Qry Allard, very interesting. I'm guess…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52261-calling-procedure-from-query-52283/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52261-calling-procedure-from-query-52283/read.awpCalling procedure from Queryguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52261-calling-procedure-from-query-52282/read.awp25 May 2015 19:13:00 ZHi, I use the pivot table extensively and I do what you discribe all the time. You could add stuff to a querie using Hadd if …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52261-calling-procedure-from-query-52282/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52261-calling-procedure-from-query-52282/read.awpCalling procedure from Queryguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52261-calling-procedure-from-query-52281/read.awp25 May 2015 19:11:00 ZHi, Quote I my honest opnion you do calculations in sql. SQL is made for that ? So is WinDev, ;) - for me SQL is a la…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52261-calling-procedure-from-query-52281/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52261-calling-procedure-from-query-52281/read.awpCalling procedure from Queryguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52261-calling-procedure-from-query-52280/read.awp25 May 2015 18:52:00 ZThanks for the responses everyone. The query I'm trying to write would be an input to a Pivot Table (which means I cannot use…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52261-calling-procedure-from-query-52280/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52261-calling-procedure-from-query-52280/read.awpCalling procedure from Queryguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52261-calling-procedure-from-query-52279/read.awp25 May 2015 18:40:00 ZHmm Sorry . I donnot get why you want to do that. I my honest opnion you do calculations in sql. SQL is made for that ? Ok if…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52261-calling-procedure-from-query-52279/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52261-calling-procedure-from-query-52279/read.awpCalling procedure from Queryguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52261-calling-procedure-from-query-52276/read.awp25 May 2015 14:17:00 ZHi, Another way is perhaps to add you calculation in the "Displaying a row of table xxx" asTable_MyTable_Col_Calculated(table…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52261-calling-procedure-from-query-52276/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52261-calling-procedure-from-query-52276/read.awpCalling procedure from Queryguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52261-calling-procedure-from-query-52275/read.awp25 May 2015 14:05:00 ZSolutionJ-Reg You cannot do what you want directly however a query can contain another query - when run the 'included query' is…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52261-calling-procedure-from-query-52275/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52261-calling-procedure-from-query-52275/read.awpCalling procedure from Queryguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52261-calling-procedure-from-query-52273/read.awp25 May 2015 13:17:00 ZNo, that's not what I mean I'm afraid. I want to run a procedure from within the query such that the result of each execution of…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52261-calling-procedure-from-query-52273/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52261-calling-procedure-from-query-52273/read.awpCalling procedure from Queryguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52261-calling-procedure-from-query-52272/read.awp25 May 2015 13:11:00 ZAh I get it Hexecutequerie( myquery) //then to run a procedure for each row of the result For each myquery run procedure …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52261-calling-procedure-from-query-52272/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52261-calling-procedure-from-query-52272/read.awpCalling procedure from Queryguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52261-calling-procedure-from-query-52266/read.awp24 May 2015 15:29:00 ZHi, I think I see what you mean, but that wouldn't work in this case. My query would be returning many rows, and for each row…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52261-calling-procedure-from-query-52266/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52261-calling-procedure-from-query-52266/read.awpCalling procedure from Queryguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52261-calling-procedure-from-query-52265/read.awp24 May 2015 15:26:00 ZHi, You can sent a parameter to the querie. Run the procedure and the result can be passed as a parameter when you run the…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52261-calling-procedure-from-query-52265/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52261-calling-procedure-from-query-52265/read.awpCalling procedure from Query