Delete records with %Stream.FileBinary Field
I'm new in this forum and also new working with a Caché-Database.
I have to delete records from a table (by SQL) which contains a field declared as:
When I try to delete a record with an image I get an error
[%msg: <FEHLER #5019: Kann Datei 'H:\BK Solution\DSTBern\eXpert\Data\Expert\stream\YJC7o7ngR9WUeA.stream' nicht löschen>]
[SQLCODE: <-412>:<Allgemeiner Stream-Fehler >]
because the physical file doesn't exist (for any reason) but the database want's to delete this file.
Even when I try to update the image by executing 'Update <Table xy> SET Image = NULL', I get the same errormessage.
Is there any way to avoid this problem? Is it an issue of Caché 2012. Caché 2016 seems to be ok, but for any reason we have to use Caché 2012.