go to post Martin Nielsen · Sep 17, 2025 Here's an update, I went back to what I used initially %Stream.FileBinary, and setting RemoveOnClose to true fixed my issue with the file being saved in the stream folder where the database files are with a randomly generated name https://docs.intersystems.com/irisforhealth20251/csp/documatic/%25CSP.Do...
go to post Martin Nielsen · May 20, 2025 I figured it out, however I am not sure why this is the case: Firstly the permissions were in order, and I did not change anything since the full permission to the entire table was granted. When I added a WHERE clause with tbl.SomeBoolean = ?, it would prompt the -99 SQLCODE error, I then attempted to use tbl.SomeBoolean LIKE (?) which worked, I then tried tbl.SomeBoolean = (?) which ALSO worked. My conclusion: when filtering by boolean (bit) columns using dynamic queries (%SQL.Statement) parentesis must be surrounded by the value, I don't know why this is and it seems strange to only be needed when dealing with bit columns.
go to post Martin Nielsen · Aug 28, 2024 The issue was that a secure flag must be set in the parameters of SetCookie method. I couldn't find any documentation on this when upgrading from Caché 2017 to Ensemble 2018.
