pcsoft.us.windevCopyright 2026, PC SOFT28 Mar 2016 21:06:36 Z5 Dec 2010 23:19:31 ZGreetings All, Lately I have been using the Query modeler and things have been going smoothly. Today I had to create a query using straight SQL because there are multiple outer joins and the use of correlation table names (aliases). The SQL executes fine in the Query tool as long as I check Run hQueryWithoutCorrection in test mode. But when I run it in the window, I get an error telling me that parameters are not allowed. I have SQL Native Access installed. Thanks for any pointers!! Paul Here is the SQL [code] SELECT DISTINCT FTP.FP_CITY, FTP.FP_POSTAL_CODE, FAA.A_ID, FAA.AIRPORT_IDENTITY, FARS.a_identity, FARS.SP_ID AS SP_ID, FARS.AR_VEHICLE_TYPE AS AR_VEHICLE_TYPE, FARS.AR_BASE_RATE AS AR_BASE_RATE, FARS.AR_GRATUITY AS AR_GRATUITY, FARS.AR_PARKING AS AR_PARKING, FARS.AR_TOLLS AS AR_TOLLS, FARS.AR_FUEL AS AR_FUEL, FARS.AR_EMLN AS AR_EMLN, FARS.AR_MEET_GREET AS AR_MEET_GREET, FARS.AR_HOLIDAY AS AR_HOLIDAY, FARS.AR_DISCOUNT AS AR_DISCOUNT, FARS.RT_TOTAL AS RT_TOTAL, FARS.r_currency AS r_currency, FARS.r_drivetime AS r_drivetime, FARS.AR_MILEAGE AS AR_MILEAGE, FARS.AR_RATE_RANK AS AR_RATE_RANK FROM FT_PLACE FTP INNER JOIN FT_AIRPORT_ALL FAA ON FAA.A_ID = {Param_Affiliate_Supported_Airport} LEFT OUTER JOIN FT_AFFILIATE_RATE_STAGED FARS ON FTP.FP_IDENTITY = FARS.a_identity AND FAA.AIRPORT_IDENTITY = FARS.b_identity AND FARS.SP_ID = {Param_AffiliateID} WHERE FTP.FP_COUNTRY = {Param_Affiliate_Supported_Country} AND FTP.FP_STATE = {Param_Affiliate_Supported_Region} AND FTP.FP_COUNTY = {Param_Affiliate_Supported_SubRegion} ORDER BY FTP.FP_CITY, FTP.FP_POSTAL_CODE; [/code] ----------CODE ON THE BUTTON---------------------- [code] HExecuteQuery(QRY_Rates_Staged_By_SubRegion_AffiliateID,hQueryWithoutCorrection,AffiliateID,gsRegion,"EWR",gsSubRegion,gsCountry) TableDisplay(TABLE_QRY_Rates_Staged_By_SubRegion_AffiliateID) TableSelectMinus(TABLE_QRY_Rates_Staged_By_SubRegion_AffiliateID) [/code] ----------END OF CODE ON THE BUTTON---------------------- ----------ERROR MESSAGE---------------------- [code] The 'TABLE_QRY_Rates_Staged_By_SubRegion_AffiliateID' control was not be initialized, the following HyperFileSQL error occurred: ============================= Error in the SQL code of query. Unable to initialize the query. The use of parameters is not allowed with HExecuteSQLQuery. ============================= Error in the SQL code of query. Unable to initialize the query. The use of parameters is not allowed with HExecuteSQLQuery. [/code] ----------ERROR MESSAGE---------------------- I also tried this code but I get a similar error: [code] QRY_Rates_Staged_By_SubRegion_AffiliateID.Param_Affiliate_Supported_Airport = "EWR" QRY_Rates_Staged_By_SubRegion_AffiliateID.Param_Affiliate_Supported_Country = gsCountry QRY_Rates_Staged_By_SubRegion_AffiliateID.Param_Affiliate_Supported_Region = gsRegion QRY_Rates_Staged_By_SubRegion_AffiliateID.Param_Affiliate_Supported_SubRegion = gsSubRegion QRY_Rates_Staged_By_SubRegion_AffiliateID.Param_AffiliateID = AffiliateID //HExecuteSQLQuery(QRY_Rates_Staged_By_SubRegion_AffiliateID,hQueryWithoutCorrection,AffiliateID,gsRegion,"EWR",gsSubRegion,gsCountry) HExecuteSQLQuery(QRY_Rates_Staged_By_SubRegion_AffiliateID,hQueryWithoutCorrection,MyConnectionNativeSQL) TableDisplay(TABLE_QRY_Rates_Staged_By_SubRegion_AffiliateID) TableSelectMinus(TABLE_QRY_Rates_Staged_By_SubRegion_AffiliateID) [/code]30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/29292-hexecutesqlquery-parameters-not-allowed-webdev/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)rosa_negra776pcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/29292-hexecutesqlquery-parameters-not-allowed-webdev-57068/read.awp28 Mar 2016 21:06:36 ZHOLA TENGO UN PROBLEMA EN UNA TABLA SELECCIONE UNA QRY PERO QUIERO AÑADIR UNA COLUMNA CHECKS EN LA CUAL GUARDAR DATO POR DATOhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/29292-hexecutesqlquery-parameters-not-allowed-webdev-57068/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/29292-hexecutesqlquery-parameters-not-allowed-webdev-57068/read.awpHExecuteSQLQuery - Parameters Not Allowed - WebDev 15guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/29292-hexecutesqlquery-parameters-not-allowed-webdev-29352/read.awp7 Dec 2010 22:26:24 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/es-ES/pcsoft.us.windev/29292-hexecutesqlquery-parameters-not-allowed-webdev-29352/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/29292-hexecutesqlquery-parameters-not-allowed-webdev-29352/read.awpHExecuteSQLQuery - Parameters Not Allowed - WebDev 15guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/29292-hexecutesqlquery-parameters-not-allowed-webdev-29303/read.awp6 Dec 2010 10:30:52 ZHi Paul, Outside the query editor a query is just a string. For these queries it is probably the easiest way to use stringbuil…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/29292-hexecutesqlquery-parameters-not-allowed-webdev-29303/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/29292-hexecutesqlquery-parameters-not-allowed-webdev-29303/read.awpHExecuteSQLQuery - Parameters Not Allowed - WebDev 15guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/29292-hexecutesqlquery-parameters-not-allowed-webdev-29301/read.awp6 Dec 2010 07:38:03 ZI start to wonder if there is not something goofy with my setup. I changed the parameters in the SQL Query. I still get the er…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/29292-hexecutesqlquery-parameters-not-allowed-webdev-29301/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/29292-hexecutesqlquery-parameters-not-allowed-webdev-29301/read.awpHExecuteSQLQuery - Parameters Not Allowed - WebDev 15guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/29292-hexecutesqlquery-parameters-not-allowed-webdev-29300/read.awp6 Dec 2010 07:37:45 ZGreetings all, I seem to be stuck in SQL HELL. I have had great success with executing queries with parameters as long as I ca…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/29292-hexecutesqlquery-parameters-not-allowed-webdev-29300/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/29292-hexecutesqlquery-parameters-not-allowed-webdev-29300/read.awpHExecuteSQLQuery - Parameters Not Allowed - WebDev 15