|
| Stored Procedure / Automatic Task |
| Iniciado por guest, 19,jun. 2015 11:18 - 4 respuestas |
| |
| | | |
|
| |
| Publicado el 19,junio 2015 - 11:18 |
HI,
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? |
| |
| |
| | | |
|
| | |
| |
| Publicado el 19,junio 2015 - 11:31 |
| Hi, why not use a Windows service on the server, which is a normal program and can deal with timers and HFSQL transactions? |
| |
| |
| | | |
|
| | |
| |
| Publicado el 19,junio 2015 - 11:37 |
Hi Guenter,
Funnily enough that was my first thought, but I read the PCSOFT help and it recommended the use of Stored Procedures rather than a service.
Thanks, I'll give that a go.
Do you happen to know if Stored Procedures honour Transactions when they are executed from a normal WINDEV / WEBDEV program? |
| |
| |
| | | |
|
| | |
| |
| Publicado el 19,junio 2015 - 11:57 |
| Hi, I never tried, but according to the Help there are no transactions allowed in stored procedures. And no, afaik, stored procedures will not be able to detect transactions. Maybe there's a way by using SQL? |
| |
| |
| | | |
|
| | |
| |
| Publicado el 19,junio 2015 - 11:59 |
| I'll take a look. Thanks for the help Guenter. |
| |
| |
| | | |
|
| | | | |
| | |
|