pcsoft.us.windevCopyright 2026, PC SOFT26 May 2016 04:12:00 Z26 May 2016 04:12:00 ZHi 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 David30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57831-hfcs-triggers-amp-stored-procedures/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)