I’ve successfully followed the examples on the forum to upload an image into an SQL database then I am trying to retrieve the saved image from database and show it in image component in perspective. I tried different ways but none of them seems working. In db dataType is varbinary(Max). I am tryin…

Please use the </> code formatting button when posting code. You can edit your post with the pencil icon button.

@pturmel made a module for fetching blobs from a database [image] Automation Professionals' Blob Server Module 3rd Party Modules Automation Professionals is pleased to announce an alpha release of its new Blob Server Module. Available only for Ignition v8.1, here. The Bl…

[image] deepti_k: v=system.db.runNamedQuery(path) return {‘contentType’:‘image/png’,‘bytes’:v} The above is wrong. v is not an array of bytes. It is a dataset. You need to access the row/column containing the blob. If the first row, as typical, your code should look like this: ds = syst…

Or switch your named query type to be a ‘scalar’ query.

Image upload component

Ignition

victordcq May 17, 2022, 8:14am 3

@pturmel made a module for fetching blobs from a database