Access, Edit, Save BLOB at runtime - Auto export / import

serdarulutas

Hello,

My plan is to store a RTF or DOC file in a BLOB field, and when user requests it via AssistEdit, I want to export and open the file, maintain the connection between Navision and the file, and when user closes the file, I want to update the BLOB field. so in steps:

1-User opens the file
2-User Make changes
3-User closes file
4-Navision updates the blob field automatically

Is this possible? I remember seeing something like this maybe 6-7 years ago but I am not sure how to do this.

Thanks for all the help.

SiSt

There are several options in the classic client. You could use a text editor that can be called in blocking mode. Or a tool that waits for the process of the text editor and blocks the command line in combination with the SHELL command. I don't like this approach as the nav gui is blocked and the user has to know that an editor is still open.
Second approach is using an automation and events I've implemented this several times. It works but you have to develop the automation. I think you can also find one in the downloads here.
My favorite is just open the editor (using SHELL or HYPERLINK) and open a confirm dialog that informs the user that the editor is open and ask if he wants to import the changed file. This is similar to the way several ftp clients support the editing of remote files. Advanced version would be with a custom dialog and a check if the file was edited before asking the user.

Addition: If you want the editor to be opened without blocking the user you can also use a Form and it's timer instead of a automation to check whether the file has changed.