Wrong FILE_GUID format in readed blob.

antose — Wed, 10 Feb 2010 16:34:43 GMT

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

topic Wrong FILE_GUID format in readed blob. in QlikView

Wrong FILE_GUID format in readed blob.