pcsoft.us.windevCopyright 2026, PC SOFT20 Jun 2025 07:51:24 Z6 Dec 2010 23:17:06 ZGreetings All, Can someone tell me if it IS or IS NOT possible to use a query via HExecuteQuery if the query was built using hand-written sql with parameters hitting SQL Server with Native Access? I created the query, pressed F2 to view the sql, pasted in the sql with the parameters, checked the box to 'Run with HQueryWithoutCorrection in test mode', I run the test, type in the values for the parameter it works perfectly!! I think I should be able to associate that query with a table and load it using the code below. YES? NO? It does not work for me as I get a runtime error stating 'The use of parameters is not allowed with HExecuteSQLQuery.' This is odd because I am doing HExecuteQuery, not HExecuteSQLQuery. I know I will have to hand code the updates as it is a complex query, but I really don't want to have to code for the loading of the table. Here is my code: [code] QRY_Rates_Staged_By_SubRegion_AffiliateID2.Param_Airport = sAirport QRY_Rates_Staged_By_SubRegion_AffiliateID2.Param_Country = gsCountry QRY_Rates_Staged_By_SubRegion_AffiliateID2.Param_Region = gsRegion QRY_Rates_Staged_By_SubRegion_AffiliateID2.Param_SubRegion = gsSubRegion QRY_Rates_Staged_By_SubRegion_AffiliateID2.Param_Affiliate = AffiliateID HExecuteQuery(QRY_Rates_Staged_By_SubRegion_AffiliateID2,MyConnectionNativeSQL,hQueryWithoutCorrection) TableDisplay(TABLE_QRY_Rates_Staged_By_SubRegion_AffiliateID) TableSelectMinus(TABLE_QRY_Rates_Staged_By_SubRegion_AffiliateID) [/code] Thanks all!! Paul30WEBDEVen_UShttps://forum.pcsoft.fr/en-US/pcsoft.us.windev/29327-hexecutequery-parameters-not-allowed-that-true/read.awpmoderateur@pcsoft.fr (The moderator)webmaster@pcsoft.fr (The webmaster)Alexpcsoft.us.windevhttps://forum.pcsoft.fr/en-US/pcsoft.us.windev/29327-hexecutequery-parameters-not-allowed-that-true-70950/read.awp20 Jun 2025 07:51:24 Zwrote: > Greetings All, > Can someone tell me if it IS or IS NOT possible to use a query via HExecuteQuery if the query was b…https://forum.pcsoft.fr/en-US/pcsoft.us.windev/29327-hexecutequery-parameters-not-allowed-that-true-70950/read.awphttps://forum.pcsoft.fr/en-US/pcsoft.us.windev/29327-hexecutequery-parameters-not-allowed-that-true-70950/read.awpHExecuteQuery - Parameters Not Allowed - Is That True?Alexpcsoft.us.windevhttps://forum.pcsoft.fr/en-US/pcsoft.us.windev/29327-hexecutequery-parameters-not-allowed-that-true-70949/read.awp20 Jun 2025 07:46:47 Zwrote: > Greetings All, > Can someone tell me if it IS or IS NOT possible to use a query via HExecuteQuery if the query was b…https://forum.pcsoft.fr/en-US/pcsoft.us.windev/29327-hexecutequery-parameters-not-allowed-that-true-70949/read.awphttps://forum.pcsoft.fr/en-US/pcsoft.us.windev/29327-hexecutequery-parameters-not-allowed-that-true-70949/read.awpHExecuteQuery - Parameters Not Allowed - Is That True?Wouter Pleijsierpcsoft.us.windevhttps://forum.pcsoft.fr/en-US/pcsoft.us.windev/29327-hexecutequery-parameters-not-allowed-that-true-70908/read.awp30 Apr 2025 08:52:57 ZHello, For people stumbling unto this topic, I got the same error, but had a different cause: I had added an Inner Join to m…https://forum.pcsoft.fr/en-US/pcsoft.us.windev/29327-hexecutequery-parameters-not-allowed-that-true-70908/read.awphttps://forum.pcsoft.fr/en-US/pcsoft.us.windev/29327-hexecutequery-parameters-not-allowed-that-true-70908/read.awpHExecuteQuery - Parameters Not Allowed - Is That True?guestpcsoft.us.windevhttps://forum.pcsoft.fr/en-US/pcsoft.us.windev/29327-hexecutequery-parameters-not-allowed-that-true-29353/read.awp7 Dec 2010 22:26:45 ZI FINALLY FIGURED IT OUT - UGH!! - SEVERAL DAYS LOST I am not really sure what is going on, but it turns out that when I creat…https://forum.pcsoft.fr/en-US/pcsoft.us.windev/29327-hexecutequery-parameters-not-allowed-that-true-29353/read.awphttps://forum.pcsoft.fr/en-US/pcsoft.us.windev/29327-hexecutequery-parameters-not-allowed-that-true-29353/read.awpHExecuteQuery - Parameters Not Allowed - Is That True?guestpcsoft.us.windevhttps://forum.pcsoft.fr/en-US/pcsoft.us.windev/29327-hexecutequery-parameters-not-allowed-that-true-29336/read.awp7 Dec 2010 06:57:34 ZThanks, Issah. I have come to the conclusion that installing the Native SQL Access has goofed something up in my development en…https://forum.pcsoft.fr/en-US/pcsoft.us.windev/29327-hexecutequery-parameters-not-allowed-that-true-29336/read.awphttps://forum.pcsoft.fr/en-US/pcsoft.us.windev/29327-hexecutequery-parameters-not-allowed-that-true-29336/read.awpHExecuteQuery - Parameters Not Allowed - Is That True?guestpcsoft.us.windevhttps://forum.pcsoft.fr/en-US/pcsoft.us.windev/29327-hexecutequery-parameters-not-allowed-that-true-29335/read.awp7 Dec 2010 06:57:15 Zaka pros and cons. Thats why I also suggested creating a view and querying from there. Windev will treat it like a table. Tha…https://forum.pcsoft.fr/en-US/pcsoft.us.windev/29327-hexecutequery-parameters-not-allowed-that-true-29335/read.awphttps://forum.pcsoft.fr/en-US/pcsoft.us.windev/29327-hexecutequery-parameters-not-allowed-that-true-29335/read.awpHExecuteQuery - Parameters Not Allowed - Is That True?guestpcsoft.us.windevhttps://forum.pcsoft.fr/en-US/pcsoft.us.windev/29327-hexecutequery-parameters-not-allowed-that-true-29334/read.awp7 Dec 2010 06:57:01 ZHi Issah, If you use your 'best approach' as... myselect is sting="select * from stafflist where lastname='%1' and salary > %2…https://forum.pcsoft.fr/en-US/pcsoft.us.windev/29327-hexecutequery-parameters-not-allowed-that-true-29334/read.awphttps://forum.pcsoft.fr/en-US/pcsoft.us.windev/29327-hexecutequery-parameters-not-allowed-that-true-29334/read.awpHExecuteQuery - Parameters Not Allowed - Is That True?guestpcsoft.us.windevhttps://forum.pcsoft.fr/en-US/pcsoft.us.windev/29327-hexecutequery-parameters-not-allowed-that-true-29332/read.awp7 Dec 2010 06:56:27 ZThanks Issah, I just finished my note to Arie after doing a lot of testing. I am currently thinking that Native SQL Driver is …https://forum.pcsoft.fr/en-US/pcsoft.us.windev/29327-hexecutequery-parameters-not-allowed-that-true-29332/read.awphttps://forum.pcsoft.fr/en-US/pcsoft.us.windev/29327-hexecutequery-parameters-not-allowed-that-true-29332/read.awpHExecuteQuery - Parameters Not Allowed - Is That True?guestpcsoft.us.windevhttps://forum.pcsoft.fr/en-US/pcsoft.us.windev/29327-hexecutequery-parameters-not-allowed-that-true-29331/read.awp7 Dec 2010 06:56:03 ZThanks, Arie. There is no semi-colon in the project I am currently trying to run. I went back to another project in which I re…https://forum.pcsoft.fr/en-US/pcsoft.us.windev/29327-hexecutequery-parameters-not-allowed-that-true-29331/read.awphttps://forum.pcsoft.fr/en-US/pcsoft.us.windev/29327-hexecutequery-parameters-not-allowed-that-true-29331/read.awpHExecuteQuery - Parameters Not Allowed - Is That True?guestpcsoft.us.windevhttps://forum.pcsoft.fr/en-US/pcsoft.us.windev/29327-hexecutequery-parameters-not-allowed-that-true-29330/read.awp7 Dec 2010 06:55:25 ZSorry Paul, was away and couldn't help earlier. Whenever you try to edit the generated sql code, WD will warn you that it will …https://forum.pcsoft.fr/en-US/pcsoft.us.windev/29327-hexecutequery-parameters-not-allowed-that-true-29330/read.awphttps://forum.pcsoft.fr/en-US/pcsoft.us.windev/29327-hexecutequery-parameters-not-allowed-that-true-29330/read.awpHExecuteQuery - Parameters Not Allowed - Is That True?guestpcsoft.us.windevhttps://forum.pcsoft.fr/en-US/pcsoft.us.windev/29327-hexecutequery-parameters-not-allowed-that-true-29329/read.awp7 Dec 2010 06:54:50 ZPaul, it IS possible for sure,because i'm doing this as well! Maybe the final semi-colon is the bad guy? Do you fill ALL para…https://forum.pcsoft.fr/en-US/pcsoft.us.windev/29327-hexecutequery-parameters-not-allowed-that-true-29329/read.awphttps://forum.pcsoft.fr/en-US/pcsoft.us.windev/29327-hexecutequery-parameters-not-allowed-that-true-29329/read.awpHExecuteQuery - Parameters Not Allowed - Is That True?