File to Database Binary Column

This forum allows users to post and respond to "How Do I Do ....." questions. The information contained in this forum has not been validated by K-Rise Systems and, as such, K-Rise Systems cannot guarantee the accuracy of the information.
JefferyD
Posts: 178
Joined: August 31st, 2021, 11:37 am
Contact:

File to Database Binary Column

Unread post by JefferyD »

When trying to work with binary data or when using the SaveBinaryToFile service, you can utilize the file type when inserting or updating database records. When using the Update or Insert database services and setting the value type to "File", the contents of the Val node of the value should be a file path that will then be used to determine what file to copy to the database as a binary object.

Note: The file must exist in the application. If it doesn't, then it will need to be created or copied to the correct location using the file and folder services.

In this example, the file path is retrieved directly from the GetFiles service which ended up as "C:\EASYProcess51\Platform\DV\Applications\21000496\DownloadBLOB\download_blob_buffer.bin". Any file type or file path can be used as long as a valid file is found and the file path is accessible.
FileTypeUpdate.PNG
FileTypeUpdate.PNG (74.8 KiB) Viewed 6170 times
FileTypeUpdate.PNG
FileTypeUpdate.PNG (74.8 KiB) Viewed 6170 times
word count: 170

Tags:
Post Reply