Hi!
I have a problem with the loaded blob format and hope someone can help me.
I load the blob from an ORACLE server as:
INFO SELECT "FILE_GUID", "BLOB_IMAGE" FROM DV."AGR_ADSFILEBLOB_VY";
In QlikView the FILE_GUID looks like this
//6v5MrDSQ+xU8i7qjeOLQ==
I can view the image by ='qmem://FILE_GUID/'&FILE_GUID in QlikView
I all the other tables where I have information about the blob or in the table where we have the invoices the FILE_GUID format looks like this in QlikView D472F47C66964B6B8C203009894387E6
The GUID (Globally Unique Identifier) should be a 32 hex identifier. I have not access to look in the ORACLE table directly but the database administrator tells me it has the correct (hex) value in the AGR_ADSFILEBLOB_VY. As it is now I can't create any key to other tables.
Does QlikView format the FILE_GUID when I read it in the query above? In that case, is it possible to change the value back to a hex format?
We use the latest QlikView 9 SR2 at the customer.
Best Regard Anders