pcsoft.us.windevCopyright 2026, PC SOFT19 Jun 2015 11:59:00 Z19 Jun 2015 11:18:00 ZHI, I want to run a stored procedure automatically once per week to create new records in some tables, but it seems that you cant use transactions in stored procedures? Really?30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52791-stored-procedure-automatic-task/read.awpStored Procedure / Automatic Taskmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52791-stored-procedure-automatic-task-52796/read.awp19 Jun 2015 11:59:00 ZI'll take a look. Thanks for the help Guenter.https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52791-stored-procedure-automatic-task-52796/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52791-stored-procedure-automatic-task-52796/read.awpStored Procedure / Automatic TaskRe: Stored Procedure / Automatic Taskguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52791-stored-procedure-automatic-task-52795/read.awp19 Jun 2015 11:57:00 ZHi, I never tried, but according to the Help there are no transactions allowed in stored procedures. And no, afaik, stored proce…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52791-stored-procedure-automatic-task-52795/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52791-stored-procedure-automatic-task-52795/read.awpStored Procedure / Automatic TaskRe: Stored Procedure / Automatic Taskguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52791-stored-procedure-automatic-task-52794/read.awp19 Jun 2015 11:37:00 ZHi Guenter, Funnily enough that was my first thought, but I read the PCSOFT help and it recommended the use of Stored Procedu…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52791-stored-procedure-automatic-task-52794/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52791-stored-procedure-automatic-task-52794/read.awpStored Procedure / Automatic TaskRe: Stored Procedure / Automatic Taskguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52791-stored-procedure-automatic-task-52793/read.awp19 Jun 2015 11:31:00 ZHi, why not use a Windows service on the server, which is a normal program and can deal with timers and HFSQL transactions?https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52791-stored-procedure-automatic-task-52793/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52791-stored-procedure-automatic-task-52793/read.awpStored Procedure / Automatic TaskRe: Stored Procedure / Automatic Task