Browse image from a blob field

[jking]

Thanks Jane!

[jking]

Hi Bruce,

     I have the download from BLOB issue "mostly" solved, using the following code in the _SendFile procedure embed:

Access:Documents.Open()
Access:Documents.UseFile()
Doc:Document_Name = p_web.GSV('myDOCFileName')

If Access:Documents.Fetch(Doc:DocName_key) = 0
    sendString.FromBlob(Doc:Document_Data)
    p_web.ForceNoCache = true
    !p_web.SendString(sendString,1,0,true)
    p_web.SendString(sendString,1,len(sendString),true)
    loc:done = true   
END

Access:Documents.Close()
If loc:done then return.


The key was setting the third line properly.  I created a session variable called myDOCFileName and set this as each row of the browse is selected.  It is set to Doc:Document_Name, which is the field containing the file name stored in the BLOB.  I can view/download all BLOB entries now.

The problem with the form Save and Cancel button still remains.  If I open the Documents Browse, then edit a record, the Save and Cancel buttons do not respond.  I see the busy indicator in the lower right of my browser screen.  If I comment out the _SendFile embed code (p_web.SendString(sendString,1,len(sendString),true)), then the Save and Cancel buttons do respond again.  Any thoughts on how to deal with this? 

By the way, Jane helped me get registered for the weekly NetTalk User Group webinar.  If I don't find a solution here I'll join the webinar on Thursday.

Thanks,

Jeff

[jking]

Hi Bruce,

     I have some more info on this issue. 

     First, the form in question, in my NT 12.41 app, where the Save and Cancel buttons do not respond when doing an update, is a pop-up form.  If I call the form normally, the Save and Cancel do respond as expected.  I have been able to duplicate this in a modified version of the web40 example app (Web40_JK.zip attached).

     Second, the DevTools console shows a JS error when the form is open and the Save/Cancel button is pressed.  Please see attached image (error.png).  Hopefully these can help you solve this issue for me.

Thanks,

Jeff

[Bruce]

Hi Jeff,
yes the example is working correctly, but you are mixing two completely different parts of the example together to get yourself all confused
Let's chat in the webinar.

Bruce

[jking]

Thanks Bruce.  I have registered for the Thursday webinar.  In the meantime I attached a zip file of the modified version of the web40 example app I have been experimenting with.  It might be a good idea for you to download it so we can go over it and see where I have gone wrong.

Thanks,

Jeff

[Bruce]

updated app from the webinar Jeff.