|
| [HFSQL] Running a stored procedure |
| Iniciado por guest, 25,may. 2017 11:45 - 3 respuestas |
| |
| | | |
|
| |
| Publicado el 25,mayo 2017 - 11:45 |
Good 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' |
| |
| |
| | | |
|
| | |
| |
| Publicado el 25,mayo 2017 - 15:06 |
Why using one parameter if your query don't use it?
you are updating all your records with the same value. |
| |
| |
| | | |
|
| | |
| |
| Publicado el 25,mayo 2017 - 15:14 |
Try changing the hQueryDefault to hQuerymodify...
Dw |
| |
| |
| | | |
|
| | |
| |
| Publicado el 29,mayo 2017 - 12:28 |
Good morning,
Thanks for your answers.
I'm using a parameter to filter records to update (with the WHERE statement).
I've solved by executing a sql query directly instead of a stored query, with the hExecuteSQLQuery function. |
| |
| |
| | | |
|
| | | | |
| | |
|