pcsoft.us.windevCopyright 2026, PC SOFT29 May 2017 12:28:00 Z25 May 2017 11:45:00 ZGood morning, I'm having trouble executing a stored procedure and a stored query on HFSQL. I've created and deployed the stored procedure and the query, I've scheduled the procedure (that uses the query) and executed it but nothing changes on the database. Below the code I've used. Any suggesrtions? Procedure: PROCEDURE stored_procedure_update_ztl_scaduti() data is Date = DateSys() HExecuteQuery(stored_query_update_ztl_scaduti, hQueryDefault, data) Query: UPDATE ZTL SET STA_ID = 'X'30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60991-hfsql-running-stored-procedure/read.awp[HFSQL] Running a stored proceduremoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60991-hfsql-running-stored-procedure-61035/read.awp29 May 2017 12:28:00 ZGood morning, Thanks for your answers. I'm using a parameter to filter records to update (with the WHERE statement). I've…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60991-hfsql-running-stored-procedure-61035/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60991-hfsql-running-stored-procedure-61035/read.awp[HFSQL] Running a stored procedureRe: [HFSQL] Running a stored procedureguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60991-hfsql-running-stored-procedure-60998/read.awp25 May 2017 15:14:00 ZTry changing the hQueryDefault to hQuerymodify... Dwhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60991-hfsql-running-stored-procedure-60998/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60991-hfsql-running-stored-procedure-60998/read.awp[HFSQL] Running a stored procedureRe: [HFSQL] Running a stored procedureguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60991-hfsql-running-stored-procedure-60997/read.awp25 May 2017 15:06:00 ZWhy using one parameter if your query don't use it? you are updating all your records with the same value.https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60991-hfsql-running-stored-procedure-60997/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60991-hfsql-running-stored-procedure-60997/read.awp[HFSQL] Running a stored procedureRe: [HFSQL] Running a stored procedure