Present a Picture from SQL SERVER Image Field

[#1]

Hi Everybody ,

I am having a problem trying to present a picture that is stored in a SQL SERVER 2008 table as an Image Field

I have tried to use this statement in my Script

LOAD
ID AS ITEID
,CODE
,DESCRIPTION;
SQL
SELECT ID
,CODE
,DESCRIPTION
FROM MATERIAL WHERE ID='13546';

bundle INFO SELECT ITEID
,INFO as imageinfo
FROM MATERIALEXT;

An then in the Text Box Expression I use

=INFO(ITEID)

and I have selected the Image Representation Property.

Any Ideas???

Thanx

George

[amien]

Did you find a solution? or someone else? i have the same thing

content imageinfo looks like this:

93B20000A89D00000090000 .... and so on

[amien]

/UP

[ivan_will]

Ideas?

[ivan_will]

After info load   and info(ID) I have the result in a text object:

/9j/4RKPRXhpZgAATU0AKgAAAAgACwEPAAIAAAAESFRDAAEQAAIAAAAOAAAAkgESAAMAAAAB3RAAAAEaAAUAAAABAAAAoAEbAAUAAAABAAAAqAEoAAMAAAABAAIAAAExAAIAAAARAAAAsAEyAAIAAAAUAAAAwgITAAMAAAABAAEAAIdpAAQAAAABAAAA1oglAAQAAAABAAACNgAAAjxIVEMgSEQyIFQ4NTg1AAAAAEgAAAABAAAASAAAAAE2XzI2XzE5MjIzNDI4XzAxAAAyMDExOjEyOjA1IDE0OjM5OjQzAAAVgpoABQAAAAEAAAHYgp0ABQAAAAEAAAHgkAAABwAAAAQwMjIwkAMAAgAAABQAAAHokAQAAgAAABQAAAH8kQEABwAAAAQBAgMAkgUABQAAAAEAAAIQkggAAwAAAAEA/wAAkgkAAwAAAAEAGAAAoAAABwAAAAQwMTAwoAEAAwAAAAEAAQAAoAIABAAAAAEAAAHgoAMABAAAAAEAAAKAoAUABAAAAAEAAAIYpAIAAwAAAAEAAAAApAMAAwAAAAEAAAAApAYAAwAAAAEAAAAApAgAAwAAAAEAAAAApAkAAwAAAAEAAAAApAoAAwAAAAEAAAAApAwAAwAAAAEAAQAAAAAAAAAAAFEAAAQAAAAMzAAABAAyMDExOjEyOjA1IDE0OjM5OjQzADIwMTE6MTI6MDUgMTQ6Mzk6NDMAAAAMzAAABAAAAgABAAIAAAAEUjk4AAACAAcAAAAEMDEwMAAAAAAAAAAAAAAABgEDAAMAAAABAAYAAAEaAAUAAAABAAACigEbAAUAAAABAAACkgEoAAMAAAABAAIAAAIBAAQAAAABAAACmgICAAQAAAABAAAP7QAAAAAAAABIAAAAAQAAAEgAAAAB/9j/2wCEAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0aHBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDIBCQkJDAsMGA0NGDIhHCEyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMv/AABEIAUAA8AMBIgACEQEDEQH/xAGiAAABBQEBAQEBAQAAAAAAAAAAAQIDBAUGBwgJCgsQAAIBAwMCBAMFBQQEAAABfQECAwAEEQUSITFBBhNRYQcicRQygZGhCCNCscEVUtHwJDNicoIJChYXGBkaJSYnKCkqNDU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6g4SFhoeIiYqSk5SVlpeYmZqio6Slpqeoqaqys7S1tre4ubrCw8TFxsfIycrS09TV1tfY2drh4uPk5ebn6Onq8fLz9PX29/j5+gEAAwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoLEQACAQIEBAMEBwUEBAABAncAAQIDEQQFITEGEkFRB2FxEyIygQgUQpGhscEJIzNS8BVictEKFiQ04SXxFxgZGiYnKCkqNTY3ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqCg4SFhoeIiYqSk5SVlpeYmZqio6Slpqeoqaqys7S1tre4ubrCw8TFxsfIycrS09TV1tfY2dri4+Tl5ufo6ery8/T19vf4+fr/3QAEAAr/2gAMAwEAAhEDEQA/APMkZScdParUYzUQUZHFWYhXQchLGOCa1IU2xqPQVQiXO0eprUQcVnNmkEOUVKB0pqipcVmWKoqTbzSKOalC81QhEWnBBUiLTwtNCIHtopB8y1XbTFzmNsfWtNV4p4SrjJoTSe5gy2dzHztyPamxyTRnFdIYxgUxrSGT7yAmtY1O5m6a6GStz/eX8qsRyRP0IqaXS1JOw49jVZrG4jzlcj1FbJwZDU15jzCh6cU02xwcc1CDNH0J+hqdLlgPnX8q05H0FzrqQNEwpGQgdKurLC/GR9DTnjj2k9MDtSs1uPR7H//QyMU/e6mpvKR+VIP86a8JBr0ziEWUZ5FOyp6Go9jA9KaVp2ETgcGmMgPUUxWdQeacJfUUrDuNaLI4qFoT1Iq2GRgMGjFS0BTIdcYNSKQamdFPUVGYhnipaGcco5q1EPSq6ircI5rnGWoFy49hmtBRxVS2Xlm98VeUcVjI2iOUVMBTFFSgUhjkHNSgc01BUoHNMQ9BT1WhBUirTA//0ZFXinhaVV4p6rWhiLt4FOVeadt6U9V6VQhpTmlWMVIV5p6rTuIpyWsMn3kBqtJpSEEo2PY1q7acE4NXGTWwmk9zm5dPuI/4cj1FRASoQMkV0xSmS2sMq/OgNbKu7WZn7NbnNGVN3zjPPUVKrrkbZOCeQ1aM2jwv9wlaozaXcxE7RuHtVqUZbiakiQRRt0/SongHJyPxquv2iJsHIp5uD9yQAiq5dLoXN3AwkA1CUYdqsq6kfLIR7NU/lxsO34Uteo7pmcRxSBmHQ1fe2BHFVmgI7cUtAsMMp7ilDo3emuhHao9pzU2Gf//S89Uc1bgwMk+lVgCDyKtQjPHrWzOVGhbrhB781bUcVBGMAVZQcVizYeoqcDpUSipwOlAD0HIqUDmmoOalA5pgSRinqtJGKlUU0Ieo4p4FCjinqtUIdjpTlFLjgU5RzTEKRzT1HNBHNOQc1QhuKcBwaXFPA4NMCPbSleBTsU4jgUwP/9Pd2jv60jpzUd2sxC+Wu7n8qs7TgZ645rpOYqtbxSH5kBqjPpNu+dvymtgLzTClNSa2BpM5x9KuI8lfmX2qsUljOOVNdVs4NQyQRuMMoP1rWNZrch00znhcSqMMM0GZXAAO0j1rVm0yBhlMqaz5tMnT7uGHtWnPCW5HLJbETbiMlQf92mCNJM7fyNMkjmiPQg0i3UifeGaTh1TBS7o5VG5q3bgFx+dUk61ftBkk+1cUtDaJfSrC9KrrVhOlYmxKgqwB0qBKsAdKBEqDmpgKjjFTAc1QiSMVKopkYqVRTA//1NJR8tPAoUfLTwK0MR2OBTlHNLjgU5RyKoQpHNOQUEc05BzTEJinKODRinAcGmA3FKR8opcU4jgUAR4oYc07FKw5oAjA5ppHNSgc0wigBuODUZWph0NMIpARsvyioitWGHy1GRQBXmiR+GUH61Ql023foNp9q1XFR7eaFJrYVrn/1eBXrWnaDCZ9ay0PNa0AwoHtVz2MIFpKsJ0quhqdOlZmhOlWB2qulWV7UCJk7VOBUCdanHWqQE0YqVRUcdSLVIRMo+WngUi/dpwqiSTHAp6jmk7Cnr1FMBSOaeg5pD1pyCmITFOA+U0lPA+U0wG4pxHApKcegoA//9bqQKVutFK3Wug5xoHNMYdakA5ppHNIBoHBqMipQODTCKAGnpUZFSkcCmEUgGOP5VHipXFMpAeSRHLAe9asMgNYtu4Zsg8YrQidc7QeamSuNGohFWEPFZsbMMd/ercc4xg8fWosVcvIasr2qlG4NWlPSiwy1GeRU461WjNTg80wLMdSrUMZqVTVITP/19hfu08VGv3aeprUwJ+wpy9RTOwp69qoCQ9acnWmHrT060CCnj7pplSDoaYDacRwKSnHoKBDBSt1oApWHNADV60hHJpy9aaetIYgHBqMipR0NMNIBp+7UZqVvu1GaAGuKjPWpXqPvSA//9Dx2yuipCZ5PetmPUDbkeZyPWuSjlaNgw6irT3jTbc8Yq009zGUHfQ7W2voZgCDjPrWjGwZRnBrg7a9lA2ITnHFbZ1FrdYsEhmGSDV8iaumJ3TOpiKjIHrVtH6YNYFnqQkRWbGT6VqR3EbkYb8KizQ7o1I5DnmrKuCazUkAxzVlX5p2Hc0o2qVTVGKQjoanSX1p2Fcvqflp6mq6OCODUqsKYi1ngU5TUWeBT1PIpgTE809DzURPNPQ80CH09fumo6ep+U0xC049BTM08ngUAf/R62lbrSClbrXQcwi9aae9OXrTT1pAA6GozUg6GmGkMRvuiozUjfdqM0gGvUfepH61HSA+Zs0oNNorI6CxFM8RDKcEVZa9ll27z93pWfmnA07sVje06/2Py30rRm1XdKuxuQOcVyYcip452Uiqi/e5mZumr3PQ9Nu5JUG0klQNxNaK6gittk+U1xOla5HaIY2B5bJNWNQ1lZ2j8s/Kqkk+9a7y8ibWO7t7iJx8rhqtJLzivMrXU5ojlHIres/EUy4EmGFXy9hXtuf/0pEkGOamSUjvXPWus2c4AL7Tnoa1I50YZU5+ldVu5zGsJhgZqZHBxis1ZSQp9qlSQZHrRygaW7mpUbmqAlbPXNTxzLnnilyhcs5qRTwarB81KrfKaQEoNPJ4FQBqfngUAPBpzdaiB5pzHmgBy9aQ9aRTzSE9akBwPBqM04Hg0wmgAb7tRmnk/KKjNIYj9qj71I9R0gP/0/AaWkopALS02loAXNODUylzQBKHNOEhHeoM07NO4i2k7CrMN3jvWYDTg1aKo0JxTOhhvCB1rTtdXuIiNsh+lcikzL0NWI7sjrW8aie5k6fY9EtfEh4EoyPUVtWmqWcx+Vxk9jXl8d7nHNXIb5gRzirsmRaSPVVmBI2ng1Yjlrzi2126hIw+R6Gt6z8SRPxMMZHUUuViudasg7HFWEmIB71iW+o2s4GxwauxTEhvrxSsHoaSyqfapt3ArLEvrUwl4GDScQuf/9TpA1PZuapLMeM81L5qk9a6WjluWFPNITzUatzQWqRkoPBphNIG4NN3UgHk/KKjNKTxUZNSMVzTKVzUeeaQz5ozS0lFZG4tFJS0AFLSUtABS0lFMBc0uabS0wP/1fBgacGqKlzRcROJDUyXDr3qnmnBqtTaFY00vPWrsF7yOawQ9SJKR3rVVe5DgmdXb37KQQxBratNfuohy24e9cFHdOvfNXor8YIJxWqlFmbptbHpNr4htZSPM+U9K2EvYpUBjYE9q8ojvcdDWhBqUseCjkH2p8pGqPTo5SQCetS+aCcelcLaeJLhMCT5hW5ba5ZSnk7WPXNS0x3OjjlOeDThNzyKzI7lXKlCCDU3m+9S7DNFZFIPNG6qKzKRSiU+tQ0Fy6W+UUwtUPnccik8wHoahplE7tUeaaz0zdSGf//W+f6WkopALRSUtIApc0lFMBc0tNopAOopM0tMApaSigBaXNNozTAfmlBpmaUGgCQNTw5qHNGadxWLSzMOhqyl4wxms0NTw9XGo0S4pn//1/Ior0etXUvTnrXNhzUyzsO9dKq9zF0zsLPVZ4iNkhFbVt4jccSjI9a8+hvSp5q5Heg96u8WZuDR6da6xZzDCuAfSraz7jwRjFeZRXvvV+21i5hxtkOPQ0nHsF31PQzNheTxSeYDXLW/iJWUCZfxFasGpWs4+Vx9KhpjTRrmUjHNIJh3ql5ue/Hal83HWoZR4LS0lFYm4UUUUAFLRSUALRSUtIAooopgf//Q8BzRmkopAOopKM0ALRRRQAuaKSigBc0uabS5pgOzTt1R5pc0ASh8U4SGoAaXNO4rFxLl171Ol4R1rODUoaqU2iXFG7He8dasx3pBBBwa5wSEd6lW4cd6tVe5LpnYwa5dRYG/I9DWpb+IIHwJRg1wK3fSplu/eqvFkcrR/9H5/ooopAFLxSUUAFFFFAC0UUlABRRS0AFFJRQAtFFFABS0lFAC5pabRSAdRSZopgf/0vAqKSlpAFLmkooAXNLmm0UwH5o3UzNLmgCTdShzUWaXNFxEVFFFIYUUUUAFFFFABRRRQAUUUUAf/9P5/oopaQBRRSUAFLRRSAKKKKACiiimAUtJRQAtFJRSAWikpaYC0UlFAC0UlFAH/9T5/ooopAFFFFABRRRQAUUUUAFL0pKKACiiigAooxmigAooooAKWkooAWijNJSA/9X5/paSikAtFJRQAtFJRQAtFFFABRRRQAlFFFAAaKKKACiiigAooooAKKKKAP/W+f6KKKQBRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFAH/9f5/ooopAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAf/0Pn+iiikAUUUUAFFFFABRRRQAUUUUAFGaKKACiiigAooooAKKXFJQAUUUUAf/9H5/ooopAFFFFABRSmkoAKKKKACiiigAooooAKKKKACiiigAooooAKKKKAP/9L5/ooopAFFFFABRRRQAUUUUAFFFFABRS8UhoAKKKKACiiigAooooAKKKKAP//T+f6KKKQBRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFAH/9T5/ooopAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAf/1f/Z/9sAhAAIBgYHBgUIBwcHCQkICgwUDQwLCwwZEhMPFB0aHx4dGhwcICQuJyAiLCMcHCg3KSwwMTQ0NB8nOT04MjwuMzQyAQkJCQwLDBgNDRgyIRwhMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCAKAAeADASIAAhEBAxEB/8QBogAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoLEAACAQMDAgQDBQUEBAAAAX0BAgMABBEFEiExQQYTUWEHInEUMoGRoQgjQrHBFVLR8CQzYnKCCQoWFxgZGiUmJygpKjQ1Njc4OTpDREVGR0hJSlNUVVZXWFlaY2RlZmdoaWpzdHV2d3h5eoOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3uLm6wsPExcbHyMnK0tPU1dbX2Nna4eLj5OXm5+jp6vHy8/T19vf4+foBAAMBAQEBAQEBAQEAAAAAAAABAgMEBQYHCAkKCxEAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSExBhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/90ABAAK/9oADAMBAAIRAxEAPwDzPFKKhHmrjvUkb7u1dFzjJhUyjIqNRU68gUBa4AdqmAwKjUcge9SkcY/Ck2UWbNcLk96tYqOBcKKmxWTepqloKBTgBSCnipGOA4pQKUDigCncBcCnAUgFPAoACKXFKRSgU7iEAqQLxSAVIBTuBHt5pdgp+KUCncR//9CgYY24K1DJYRt0q6F5pxWt1JowaTMaSwkHTmovKZTyK3dtBhjbqoq1UfUh010MI54pMn9cVsNYRuDjiqkthIucDNaqaZm4NFdZWU9anjuT3FQNBIvUUirg46c1WjJu0aImjbvTwQaoFTSq8i9DVcnYaqdzQwKdsU9RmqaXLD7wqzHPG3fFLlaKUkxGgXPHFMMTDtmrGQaXFK4ymY1+lDRmrm0HqKRoVPTiqTBlDbSEVbMTj3qMp6jFFxEQWkIqYR0xlIpgf//Rx6B1p2KBXqHCO8xgKcJQeophHFNoY7lgFD0pwFVaejuO9ICYikxTfNHenBlPegAwKUjiinEcUhkRVT2phj9KmxSYpAQbD3GaYy46HH1q0BTWUHrQxFUr6j8qj2DIwfzq2Yx24pjRt9RSGR5lApomPccd6lK4HcUwqfTNKwEgIbntSgUwOAMEYpwINILn/9LzXHalVB1xS9acorc4x6ip16VCvFTJjHShjHxg7qlxkqvvTYx396lhXMn0qWUi7GMCpMU1BUmKyNQFOApAKeBQA4dKUUoHFGKAFAp6im1IvWmAEUoFOIoFMQoFPApAKkAFAhuKUClxTqYH/9ONRTitKop5FaGJHtpwWnAU4CmAiqMUhWplHFJincRAYUbqM1C2nxNyODV7bSqtWpNCaT3MmWxlXoM1VaFlPIIromWo2hRuqg1qqr6mbppnP7aULWw9hE3TioH0+VenIreNSLM3TZnhnU8NipVuXGARmleGRScjmoytXZMm7RaS4jbHOKn3Ais0LT8uvQ0vZjVTuX+tBUHtVNblx15qdLmNuvFS4tFqSY/yUPtUbRN25FTqwYcUkh2qcdcVLGf/1KDIBwRimeV6VMk3ZxzUgWF+Qea9O5xWKrIRTMVdaFgODmoSnqKdwsV8UoqUx+lIEINCEyIikxipGHNNxQABmHepRLxyKixQRxRYLkwdTxS9arYpQzDoamwyyAKQ1GspHUU/zEJosFwxSYFO4IpKQ7iFRiozGpqbHFNIpMRAYz9abtx2xVgikAFIZ//V844pwAptOFbnISJU6g1EtTKM4FAEqDAqe2AOW96h6A/SrVuvyD3rN7FrcsJT6atSVBoAp4FIBThQA8dKUCgDilFACgU9RTRUijmmIUilApSKUUAAFSqOKYKlHSmIbinAUAc04CmM/9ZVFPIpFFPIrQxEApwFAFOAoAcooxTlHFGKoQgApVWlApyimAMBTdtSkcUmKYhm2nBacBT1FNMGV3iVuCKrSWEL9Bg1fK80bapSa2E0nuYz6dIvK8iq8kDp1U10O2keNWHIFbRrNbmbpo5rb600rW7JYwv0GDVSTTpFyV5raNaLM3TZnruXkGnrPIDg81K1vIn3lNRLhW54xTm1y3CEW3Y//9ekZI3yGG00LApwVfNRSt5jZx0HaohIynI4r1Uk1c4HKzsy4VuFOeuKVZskKw5zUQuXGO9PWWItuYYak4MakmTtEh7c03yD2NSLIjdCKkXBpDKTxkdVphjHarzDJAqKTyhgN1NFwsUyhFBHFWvK/ummuhA5WncCpikxUxQdqaUNIQwCkPXpTwppGFADMsOhp4lbvTKSlYCx5ikelGQahPSm5PY0mh3LBpKhEjDrUiyqetIZ/9DzmnqKbjvTwK3OQkXGKnjBNQqKsRDik2PqObkAepq9Gu1QKqKu6RRV5RWcjSI9RUlNWn1BQAU8CkFOFADxSigdKUUwHAU9RSAU9RQIUilApSKUCmAAVKopgFSqOKYCYpwFGKcBQB//0ZVFSEU1RzUhqzEaBTgKAKeBTAVRRinqOKTHNMQYpyigCnDrTAVhxSYp5HFJigQgFPUUgFSKKYEZFJinkUYpgNApzLSgU8incRBtpNtS4pMU7gR+WrDBGaqzWEEmeMVoBaay01JrYLH/0kk0xgDs5qlJZSp1Wum2immNT1Fegqr6nG6a6HKtE69qaA3ftXTTWUDj7uKoS6WeSvNaRqRZDgzIVyDzxViO4kHfNOlsZE6qahWIqelaLUjVFkXS5+YYpWEUvOecVWcYBqJW/ClKKGpMt7JUPy9KUzSKRuHHeoUmkXGDmpvPRhiRajkZfOiUIjgHFNMH9009ZY2HBp+RU2GVvLbuOKiaME1fAFNdFPUU7gZ5jIphU1dMQJIBqNomHUZpXCxXI4qPHWrLIMelRGMihgRYpBTyuKQDGaSEf//T87py0n1p61uzkHrVuIfKKrJ2qypIHSpZSJYBl2PpVtRVe3Hyk+tWVrOW5oloSLUlMSpKkYopwFNFPFAEgFKBQBxSgUwHAU9aaBT1FMQ4ilFBFOoAUCpVHFMAqVelMBMUoFAFOApgf//UsqOaeRSKOaeRWiMRBTgKKcBQgHKOKMU5elGKYhBT1FIBTgKYCkcUmKeaTFMQYp6jikp69KAGY5oxTiOaMUwEA5FPI4pAOaeRxQIjxRinYoxQMFFNZeakUUhFMD//1dwijb0p+KbuUNtJ59K6TmBl4qPbU7DimYoAhaMHqKiaygfqvNWsUoXNUm0DVzHm0w5yhqhLYyL1SukZaYUB7Voqz6kOCZyrQMpyKVVkPXpXRPaQydVqtLpgx8h/OtY1YshwZj4INKJJV71Zks5o+q1AUIrW6kRZokjuuzCpvORu9UwtNYelS4IFN9S+MVWeR1Y+mahWSRehqQXAP31rNwaNFNMkM0LDkc00ohOAcH0pw+zsBjANMeNiSVIPOahpjGtGw7ZphQfQ08PMp+YZqwFDDkUJjsf/1vPRg05R60GMdu9KqkYrY5CVB0qdSCuQc9qgWrKDdtAGOallItxDCiphTFAqQVmaj0FSUxakpAKKeKYKkFAEi9KcKQYxSgUAOFSLTAKkWqAcRSijFOFACgVKo4qMCpl6UxCAU4CkFPFMD//XuqOaeRTV61IRWhiNApwFAFOAoAeo4pMU5elBApiEFOA5oxTlFMQ402nsKQCmAYp6jimgVIooAYRzRinHrRTAAKcaQU9ulAEeKKXFLigQqimkc09aQ9aBn//Q6E1nTyJneG+YNWkRmqEunhpAy9M8iuqNr6nMy4jCSNT6ilxTkjWNAo7CjFIYwinKKXihRQBGw5pu2pWHNNIoAj2igrxT8UpHFAiuUB7VBJawv1WrZFIRT5mtgaMt9MB+4fwqnNZTRk/Ln6VvgU11HpWirSW5Dgmcw0bDqOaYUNdHJbQydVqnLpyH7pxWsa0XuZuk+hkFTimiR4+9X5bGZAeM1SeJwelaNqS0JSaHrcn+Jc1Ok8bd8VnsrCkyRWbiilJn/9Hguc+tPUk9ah5qRWPetbHKTjae1TwDLD2qupGKt2w4JqXsUtyytPFMWpBWZoSLT6YtPoAcKkFMFPFAEqjilFA6UopgOFSLTBUi0AOxThRSimIcBUqjioxUqjimACngU2nCmB//0tBRzTyKaoqQitDEQYpwFIKcKBD1HFGM0qjijvTAMU5aTFOWmhDmpMU4ikxTABT1FNAqRRxQAwiilPWimADrTyOKaOtPYcUAMoxS0YoActNbrT15FNagD//T6TFAHNLigda6DnFI4pmKlPIpmKAG4py0lOUUAMYU3FPbrTcUAJilI4o7049KQEJpuKkxSEUwGqKaw5qRRTWpXAiIppWpCKTFAhhXiq0kET5yoq6RxURFO7AzJNOjPK8VTksJF/hz9K3CtN21aqtEuCP/1PPwSKevamU9RWzOUmWr8C4QVnqM4ArSjGFArORcdyQVIKYKeKgskWpKYtPFAxwp60wVItAiVacBSLTgKAHCpFFMFSKKYD8UooNKBTEOFSr0qMVMo4pgIOtPFIKcKYH/1dJRzUhpiDmpGrQxEFOApABThTEPUcUUq8ijFMAFOXrSU5RzQA802nNSUwCpF6UzFSKOKBDKKcetJimAopx6U0Cnt0oAYKKWjFADlpp609aQjmgD/9bpqUdaXFGK6DnFPSmVIelMoATFKooNKooAY3Wm09hTaAEpx6U2nEcUgIyKSnUhoABTHp60jDmkBHSYpx5pKAA9KiIqYjio8UARkUmKkIpMUAf/1/P+eKeuaZ3qRa2Zyk8IywFaK9Ko2wySavL0rKW5rEeKeKYKeKkolSn0xakoAcKetMFSLQIlUcU4U0U4UwHipVqMVItAD6cBSGnCmA4VMvSohUq9KYgApwFJThTA/9DUWpDTFHNPNaGACnUgp1MB60GlXpSYpgLinr1puKco5oAc1JTm6UmKYBipF6UwVIopiGHrS4pSOaTFACgU5hxSCnN0pAMopaKYDlpDTlFNYc0Af//R6ilxRSgV0HOKelMqRulMoASlWkpy0gGMKaaew5ppFADcU49KSnHpQBFRSkUlIBVprU4UjYzQBHikp2KQ0AKelR4qQjio6QDSKQCnUlAH/9Lz6pF4FRinrWrOUvW4wM+tXF6VWiGFAqyvSsnqzVDxTxUYqQUiiVKfUa1JQIeKetMFPWgZOvSnCmLThTESCpFqMVIlNASU5aaactMCQVKvSoRUy9KBAKcKSnCmhH//09VRUpqJetSGtDABThTacKYEq9KSlXpRTAUU5etNFPXrQA5ulJTm6U2mIWpFpgqRelADD1opTRTAB1p7dKaOtObpQAwUtAo5oAetNPWnLTTQB//U6qgUUuK6DnFPSm09ulMoASlWkpy0gGsOabTmpKAG049KSnEcUAREUlOPFJQALTW609aa1IBhpDTjTaQCnpUfSpT0qMigBpo4oNFAz//V89FSpyRUANTRctWrOY0U7VOvSqSMMkCrKOR1rKxomTipBUKuDUqmkMmSpKiQ1JQMeKkFRCpFNAE69KcMUxelOFMRKKkSohUiUwJTSikpRTAkFTL0qEVMvSmIKeKYKeMUCP/W1k61IajXFPNamAopRTRThQBMnSkpV6UneqEOpy9aaKco5oAeaSnNTaAFqRelMp60ANPWilPWimACnt0pgp56UANxRRRQIctIactIaAP/1+rpRScUoFdBzDj0qPFSHpTKBiU5RSUq0ANakpzdabSASlPSkp5HFAERpDTiKbikAq01utOApGoAZim040lIBT0qI1KelRmgBppKcaQUDP/Q84zU8JPJqgs6N0NXYGAUc1pI50tS4mOT3NTKWG49eOKqlyoyOamifeOmKmxRMkjHJYVOrgEAGoB709QN27NIC4j+tTBgaoBpgfUVMJhxkYpWHcuA1ItVVccYNTK/rRYZaU8U4VErDFPBoAmBqRaiU1ItMCalFNpwpgSLUy1AKmXpTExwpwpgNOFNCP/R1VqQ1EnWpDWpiKKcKYKeKYiZOlJ3oXpR3pgOFOXrTBTloAkbpSClPSkoEOp69KjFSL0oAQ9aSg0UwHDrT26UwdaeelAhlLRRigBy0hpy009aAP/S6ygdaKUV0HMObpUdSHpTKQCU5aSlWmMa1Np7dabSASnHpSYpx6UARUhpxpKQAtNfrTlpGFAEZpDTjSUgF7VEalPSozQwGmilNJQM/9PxeCQllyeBWpHOexrCV8VdtJcnmtVqYT0VzciuiOGq/DNGRxWOfLx+HWq/2poyQD0o5U0QpO9jqFcGpQ1c9a30rtt7AVqR3f8Ae6VLjYu5owvuGQMVKQp6iq0UyN0qwCDSGhyoNwIPFWVNVt4BAxUqmgZZXpT1ZhUKsaeDTAsq478VMhBqoDUq0WC5bzTgarhyOvNSK4osFywpqZTxVZTUynigB4NPBqIGpAaYj//U0161ITUSnmpCc1qYiinioxTxTETL0opF6UZ5oAcKeDUYp69aYEjGkobpSA0CHCpF6VEKkWmAHrRSGloAUdakbpUa9akPSgQ2iiigB60005aaetAH/9XraBRQK6DmHHpTKeelNoASlWkpVpAI1NpzUlACU49KbTj0oGR0lLSGkAq01qctNcc0gGUlKaSgBx6VGakPSojQAhpKU0gpAf/W8HDVYgm8s57VVzS5NNOxLV0bQu4yhA7/AKVTeUlzzVMORTw1XzdiFCzuaNvN5eT6mr3211UY9aww5q3CGmGBnI71rTav7xMonSW7SPGsi9xU63+w7W6is22M8MOSeAOlUDcsWJJ5Joko3ZKuddDexScZ5q6kinoa5WxnChiepNakVwDwvWs3ArmsbobiiNi3WqCXTLgNViO5jbvU2HdF0E1KjVWVwe9SBzximgLWRTwagyOPWnqSKYE6kjoasJIcc1UVqmVuKdhE6uDUoNVAakVmHQ0coXP/176mpCaqpJ61PuU9K2sYEgNPFRA08GgCdSMUU1TxRmmIkBp61EDT1PNAyVjSUhozQIcKlTpUIqRDxTAU9aKQnmigB69aeajHWnseKBCZpabRmgCVaaetC0hoA//Q6ylFJSiug5hx6UynnpTKQBTlptOWgBrdaSlbrSUAJinHpSUp6UhkdJS0lACrTX605aa/WkAykpaSgBx6VEe9SHpUdIBKSg0UAf/R8DozSUuaQC5p1MpaYEgJFWILpoTkd6qA0uaalYTVzZTU12ncMtjiqokySxqkDTw7dKrmJ5TSjuSuADW1ZXG1Vb1rl1krRtLxVG1zx2qajbWhlUi7aHUSXMbxH1xVFL1getZst+u3ahzmoYpjnNXRu9yIp7s6uyuZJFLFu/FaUdwR15rl7W5I2oK6OOLCj1xVzsi0mzQWdTUquDWRIJUOV5FMj1DacE0kr7Be25txsxJz0qyp4rGh1KF+N3NaEc6MODT2HoWgxqQOKqM5KnaealRuBmgD/9KRDzUhIqqp54qXee9dKOcnV2FSrIO9VQwqQNRZAXkcEcUuaqqeOKcJGHvRyiuWgacp5qusoPXipVYGpsMnJ4pAaaTRmmBIKlU1ADUinigB3ejNNzQDQIkBqQnioR1qQnigABpaZmloAlWkJ5pFNITzQI//0+rpabmlB5roOYeelMp56UzNAC0q02nLSARqbSt1ptIBacelMpx6UAMNIaU000DHLTHpwpr0gG0lBpKGA49KiqXtURpAIaQUppKBn//U8CooopAFLSUUALS5ptLQA4GnZqOlzQBIDTg5FRZpQaYrFlZfWp0mXoO9UQaepq1JkuJuafIvnxs5wAc11cV4rAYrz5JWXoauQ6lPGR8xq3aW5DT6HdPdIEZvQVzjXe53Oe5qo+rvJGUHcc1T83Cn1NVBKNyWm1qaK3LA8GtC21OaP+LIrnVlqwk3FaXTE4nX22sjgPWrBqEMmMMK4NJ/erUV0ynhqHBMV2j/1ascynvUuWLZzxXG2+qzRkZORWvBrMbY3cV1crRzcyN8MKkUn1rNhvYpAMEVaEgYfKaQF1X4pwYGq0JIXmn7hVBYsg09Tg8HFVg2O9SK/PNMRb81gOeacsimq+4UAilYLlwGpFPFUgxHQ1MkpHUUuUdyfPNKDUW9TTgRSsBKp5qQnioQaeTxSAXNLmmA0uaAJlNITSIaQ9aAP//W6jNKKbSg10HMSHpTaU9KbSAWnLTM05TQAjEZpKG60hpAHFOPSm5px6UAMJptKaSkA5aa3WlWmt1oGNpDQaSgBx6VGaeelRmkAhoFBxSUDP/X8BoooqQFopKKYC0UUUALRSUUALmlpKKAHg0oNMzS5pgSbqXdUWaUGncRLupwkb1qHNKDTTFYsCWpklqkDTw1aKYmi+ktWEmrKWQipkmrSMyHE//Q8rjm96srOfWsdJulWBLXcmcribMV5ImNrEVp2+ryrgMc1zCTVOk9OxNmjuLfV4mAycVfju436GuCjn96tRX80Z4apcB8z6ncE7yCGqwjdBXJW+tMuA9a1tqsMmPm5qbMd0zcJFAc1UW5RsYNPjbBJz1ouMuK4qZGqmGqVTx1piZPkZpQzDoagDmnK4oEWkl55qbepHBqmrc1ISMUrBcsbhS5qsHYe9PEo78UrDuWkNBPNRowNLnmkB//0elzSg1HmlB5roOYmJ4puaCeKZmkIfmnKaizT1NACsRmkzSE0maQx1KelMzTj0oAbSZoNJmkMcpzTW60q9aRutADKKDSEikA49KjNPzxUZoASiikoGf/0vAaKKKkAooooAKWkooAWiiimAUtJRQAtFJRQAtLmkopgOopM0UAOzTs1HS0xEmaUNUYNKDTuB//0/DVciplnIqoDTt1aqbRDRfScetTrNWWGp6yEd61VQlxNlJvepVmPrWQlx61Os4PetVJMzcTWSerEdyykYNY6y9OamSbpT3JcToYdSmjxhq07bW+geuSE/vUiT+9KxOqO/g1OGTGGq8kyuuAeteeRXTL91q0rbVZo8ZbIqeUfN3O2VgAADTw1c3b60jYDVqQ38UmMMKWpVzSDgEDPJqYvxzWerI7q+elWt/FAEwcU8NVYMDSh85welAi2p9KXzGHvUCP607dQ0B//9TcWVT7U8MKqBqcDg8V1uJyXLpbim5qHzWA55pRKpqGh3Js09DUO6nK1IY8nmkzTWNJmgB+acSAKjBpx6UgEzRmm5pM0mMkU01qQUjHmkAmaSgmkoAeTxUZNOJ4qOkMDQKQmkzQB//V8BopKKQC0UUUgCiiigApaSigApaSigBaKKKYBRRRQAtFJS0AFLSUUwFpc02loA//1vBs0uaZS0xD80oao80uadwJg1ODVCDS5qlIViysrCpkn9aohqeGrRVGS4mkJh61Isx9ay95qRZiK0UyHA11mqzFPisVJxVmOarvchxNhJ/ercV3InINYSTc1YSf3p2I5Tp7fV5Uxk5rXg1iNgAxxXEpP0qx9oOOtKwXZ3sV5E44IqeN1HQ5yc1wUV9LHjDGtO31qRcBuanlGpI7JXpGkVeSaxrbV4XHLYq558MwwTSGf//XurJnoc1Ir1TiKqMA1MGFddzkLW7ikyKrtKi4BOCacHNAE+SOhqVJSOtVQ4NSI1JoCx5ik0u4VWYgmgMw6GpcR3LQNOJ4qqJfUVLvUjrUtDuO3UZpmRRmkMkU0jHmkU01jzSAXNJTc0ZpAPPSmZpxPFR5oYxTTaTNGaAP/9DwCiiipAKKKKYBS0lFAC0UlLSAKKKM0AFLRRQAUUUUwCiiigApaSigBaKSimB//9HwOiiigBaXNNpaAHZozTaM0xD80oNMpQaLgSbqUNUeaXNVcViUNUiyEVXzTg1WpCaLizkVYS4HrWbupwatVUJcTYSerHncVhpKy45qwtzxzVqaZDgawmPrUy3FZCzjsalWaq0IcTbiuCO9W4tRnjxhqwY5qmE1KxLR/9Ln7fWyMb61bfU4ZMfNXBrOasR3LA8HFdzicV2j0AyRS4OanVxXEQ6pPGB82RWnb62p4bipaKTR024UqyruwDWZDqEMvRhVmJoyc5qRlwuaUOKg3ijcO9FwsWQ1OJGKqJKGztPSpd5xzSAlDsOhpwl9RVffS7qTQFtHB6GhjVVSKUuw75qWh3J80ZqASjuMU7cD0qbFXJs8Uwmk3cUzNIB5NJmmZozQM//T+f6WkopALRSUUALRSUtIAooooAKKKKYC0UlFADqKSikAtJS0UAFFFFMAooooA//U8CooopALRSUUwFopKWgBRS02loAWlzTaWgQuadmmUUwH5p26o80uadwJA1P3VBmnZqlIVicOakWZhVUGnBqpTYmi/HcDvUyzD1rNDUocitVUIcD/1fJxOamSbpWOs7d6mS4Bru5kzncTZWc461Is/vWUJunNSLN60yOU2ort1OQ1altq0yYyciuXSerUc/FJoWx2EGso2Axwa0I72KQdRXCCYjvVmK9kTo1S4hzHdRug+7U2/iuPt9YkXG45FasOrxOACcVHK0VdGwzqBk0qvkZFUluYpR1qaNgBjNK5RaV/WlLioVemSSqvJpXuFixuoz6VAHJ5FKHHekBZ8xgPWk81e9Rbhim7qTGWNwPejdVbPpSiRh15pWC5/9b5/opaMUgEooooAKKKKAFopKWkAUUUUAFFFFABRRRTAM0tJRSAWlptLQAtFJRQB//X8CooopAFFFFABRRRQAtFJRTAWlzTaWgBc0tNooAdRSZooAdRmmmloEOzS5pmaM07gSA07dUWaXNNMLH/0PDA1ODVDmlzV8xNiyJCO9SJOe9VN1KGrTnJcbmgs49atRT+9Y4epUmI71oqnclwNkTe9SLNWQtye9TJOD3quZMhxNZZulWFmIHWsdZvep1m4xmmTymvDfzRnhq0rfWnGN9cwJ6kWb3pNIWqO4t9Vhk/iq150UuOa4WKcg8GrkWozxnhqzcClLudmHHanbq5qDWegatKHUYZOjCpcWik0abOoA96Tcar+Yj4OelPD1Nxk28Uoaodwpu9QcZ60gP/0fn+lpKKQC0UlFABiiiloASiiigApaSigBaKSlpAFFFFABRRRQAUUUUwClpKKAP/0vAaKSikA6ikooAWijNFABRRRQAUUUUAFLSUUwFopKKQC0tNpaYC0UlFADs0ZpuaXNAj/9PwbNGabRTESZozTM0UXAkzTg1RZpc07hYm3Uoc1DmlzTUhWLKzMO9Trccc1QDU7dVqbJcTREw9alWassMaespFUpkuBsJPUvne9ZKTiphMD3q+ZMnlNQTdOamjuGXocVkrNUizUXJ5ToYdTmTjNX4NYVuG4rlRNTlnNJpMFdHcR30T9GqdZEY5Brh47t05DVeh1aVOpyKhw7D5j//U8ApKKKQBRRRQAUUUUAFLSUUALSUtFIBKKWigAopKKAFooooAKKSlpgFFFFID/9XwCiiikAUUUUALRRxSUgFpabS0wFopKKAFooooAKKKKACiiigApaSigBaKSimB/9bwOikpaAFopKKAFzS5ptLQA7NGabRQIfmlzTM0uadwH5pc1HmjNFwJg1ODkd6gzS5p3FYsrMRUqzCqW6lDVSmLlNITDFOE3vWcHIpwlq+cnlNITU8Te9ZwlFPEtNSJ5T//1/AKSiikAUUUUAFFFFAC4oxRmikAlLRSUwCiiigApaSloAKKKSgApaKSkAUtJRTA/9D5/paSlpAFFJS0AFFFFABRRRQAUZoooAWikooAWlpKKQC0UlFABS0lLTAKKKKAP//R8CopKWkAUUUUALRSUUwFopKKAFpaSigBaM0lFADs0ZpKM0CHZpc0zNFAEmaM0zNGaLgSZpQ5qPNGadwP/9L5/ooopAFFFFABRRSigAApKXNJQAUUUUAFLSUUALSUtJSAKKKKYBRmiigBaKKKQH//0/n+iilpAJS0lFAC0lLSUgFooopgFFFFABRRRQAUUUUAFLSUUALRSUUALmiiikB//9TwGiiikAtFFJQAtFJRQAtFFFABRRRQAUZoooAWikooAWikopgLRRRSAXNGaSimB//V+fzRRRSAKKKKACiiigAooooAWkoooAKKKKACiiigAooooAKWkpaAEpeKOKSgD//W+f6KKKQBRRS0AFFFJSAKWiimAlLSUUAHNLSUtABRRRSAKKKKACiiimAUUUUAf//X8Apc0lFIBaKSikAtFFFABRRRQAUUUUwClpKKAFopKKAFopKWgAooooAKKKKAP//Q+f6KKKQBRRRQAUUUUAFFKKSgAooooAKBRRQApNJRRQAUUUUAFFFFABRRRigD/9H5/ooopALSUtFIBKWikoAKKKKYC0UlLSAKSlooAKKKKACiiigAopKXimAUUUUAf//S8AoooqQCiiimAUUUUAGaM0UUALRSUUALRSUtIAooooAKKKKYBRRRSAKKKKAP/9P5/ooopAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUvSkooA/9T5/ooopAFFFFABRRRQAUUUUAFFFLQAlLSUtACUtJRQAtFJSigBKKWikAUlLSUAf//V+f6KKWkAUUlLSAKKSloAKKKKYBRRRQAUUUUgCiiimAUUUUALSUUUgFopKKYH/9b5/ooopAFFFFABRRRQAUUUUAFFFFABRRRQAUopKKAF4pKKKACiiigAooooA//X+f6KKKQBRRRQAUUUoFABSUppKACiiigBeKSiigAooooAKWkooAWikooAKKKKAP/Q+f6KKWkAlFFFABS0lFABRRRQAtFJRQAtFJRQAtFJS0AFFFJQAtFFJQAtFFFAH//R+f6KKKQBSikooAWkpc0lABRRRQAUUUUAFFFFABS0lFABRRRQAUUUUAFFFFAH/9L5/opaKQCUUUUAFGaKKACiiigAooooAKKKKACiig0AFLSUUAFFLSUAFFFFAH//0/n+lpKKQC0lFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFAC0lFFABRRRQB//9T5/ooopAFFFFABRRRQAUUUUAFFFFABRRSigBKKXFJQAUUUUAFFFFABRRRQB//V+f6KKXFIBKKKKACiiigAooooAKKKKACiiigBRQaSigAooooAKKKKACiiigD/1vn+iiikAUUUUAFFFFABS0lFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFAH//1/n+iiikAUUUUAFFFFABRRiigAooooAKKKKAFzSUUUAFFFFABRRRQAUUUUAf/9D5/ooopAFFFFABRRRQAUUUUAL2pKKKACiiigAooooAKKKKACiiigAoopRQB//R+f6KU0lIAooooAKKKKACiiigAooooAKKKKACiiigAoopaAEooooAKKKKAP/S+f6KKKQBRRS0AJS0GkoAWkoooAKKKKACiiigAooooAKKKKACiiigAooooA//0/n+ilpKQBRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRS9qAEope1JQAUUUUAf/U+f6KKKQBRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAtJRRQAUUUUAf//V+f6KKKQC0UlFAAaKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigD//W+f6KKKQBRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFAH/9f5/ooopAFFFGKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooA//9D5/ooopAFFFFABRRRQAUUUUAFFFFABRRRQAYopaDQAlFFFABRRRQAUUUUAf//R+f6KKKQBRRRQAUUUUAFAoooAdTaKKACiiigAooooAKKKKACiiigAooooA//S+f6KKKQBS0lFAAaKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigD//T+f6KKKQBRRRQAUUUUAFFFFABRRRQAUUUUAKDSUUUAFFFFABRRRQAUUUUAf/U+f6KKKQBRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUCigAooooA/9X5/ooopAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAf/1vn+iiikAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQB//X+f6XFJS5pAJiil7UlABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFACikoooAKKKKAP/0Pn+iiikAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQB//R+f6KKKQBRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFAH/9L5/ooopAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAf/0/n+iiikAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQB//U+f6KKKQBRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFAH/9X5/ooopAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAf/1vn+iiikAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQB//X/9k=

[ivan_will]

ideas?

[#7]

We have tried to present the image by establishing ODBC connection and sql select Pic ID and PicField (as advised in the QlikView 10 Reference Manual, p.246). In the BLOB tab when we select the PicField and click on each entry, image is displayed correctly on the left.

The script becomes like:

info select PicID, PicField from "database";

Then in the layout we set listbox with expression =info(PicID) and representation as image, but when we click on the i symbol the picture is shown with letter/digit code. Text object produces blank field.

Does anyone know what could be the problem? Thanks.

[#8]

I have the same problem however I am using MS Access

Still cannot display images (tried PNG and BMP) from a database field... they appear as text even when I select : Representation=Image instead of =Text