|
| HFCS - Triggers & Stored Procedures |
| Iniciado por guest, 26,may. 2016 04:12 - No hay respuesta |
| |
| | | |
|
| |
| Publicado el 26,mayo 2016 - 04:12 |
Hi
I have been battling with stored procedures called by triggers. Initially I was using MyFile within the stored proc but this kept giving me an error that it was not available unless called by a trigger! I worked around that eventually by using HDeclareExternal & it all works nicely now from within the app. HDeclareExternal("SYSCONT.FIC","SYSCONT") HDeclareExternal("QUOTE.FIC","QUOTE") QDate is int = DateToInteger(Quote.QuoteDate) However, if I access the file via HFControlCentre the procedure crashes out at the first file access with "No analysis opened. The Quote file is not described". I would like the trigger to work correctly no matter how the file is accessed. Any ideas?
Thanks
David |
| |
| |
| | | |
|
| | | | |
| | |
|