Skip to Content
author's profile photo Former Member
Former Member

PowerBuilder, Appeon and SELECTBLOB

Looking for anyone who's utilized SELECTBLOB embedded SQL in an Appeon-deployed application.

Was it problematic or effortless?

Having brick wall experience here.

(PowerBuilder 12.6)

Thank you.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 13, 2016 at 05:45 PM

    Hi John;

    We use the SelectBob feature in all our Appeon based applications here are at Passport Canada! 😊

    Below is a screen capture of one of the Web applications that redacts credit card information. The images come from the ASE database via an Appeon based SelectBlob (in & out of the Image column type). We also use PB based Web Service NVUO's to help redact, rotate, flip, crop, OCR, compress/decompress, etc the images. All the WS interaction is between Appeon Web & the PB NVUO's. Everything you see here is written in PB 12.5.1 Classic & running in Appeon v2013R2 under a .NET (IIs) deployment model.

    FYI: Passport will be migrating to Appeon Web 2016R1 as soon as its available (within the next few months I understand).

    BTW: All the Appeon Web applications here at Passport use the STD Integrated Foundation Class framework for all client side development. As you can see from the above screen capture ... web applications look like real Web based applications. They behave that way because the Framework supports the Canadian Government's web design standard (CLF).

    All the PB based Web Service NVUO's are built from the STD Web Service Foundation Class framework.

    Q1: Was it problematic or effortless?

    A1: Pretty much effortless.

    - However, the Web Service "helper" converts the various image formats to a "neutral" format (JPG) that the DW uses to display the passport image (as you see above). If you have weird image types or compression schemes that the DW cannot render - then you would need to adopt this approach.

    - The current Appeon 2015R1 b359 BTW does not support the PB 12.5.x & higher "TableBlob" feature.

    Q2: Having brick wall experience here.

    A2: Exactly what difficulties are you encountering?

    Note: The Appeon Server connects to our ASE DBMS by using both native and ODBC drivers.

    Regards ... Chris

    PS: We can run the above application "as is" with no modifications as well on either an Android or Apple tablet using Appeon Mobile. 😊

    PPS: I have already tested this application using PB 12.6 Classic and it compiles, deploys & runs just great using the latest Appeon 2015R1 build 359 based server under IIs 7,5! 😉


    pastedImage_2.png (271.5 kB)
    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 13, 2016 at 06:32 PM

    John I use it as well with Web and Mobile clients. You don't specify what your actual "wall" is, but IIRC I ran into trouble with it not so much the code itself, but in grabbing files to upload, viewing in OLE etc......in my case it turned out I was compiling as "Universal" which I didn't realize was overriding certain Web features I wanted. Apparently Appeon defaults to lowest based features under Universal.

    I decided to split into two separate Web and Mobile application profiles/compiles and that was the trick. That may not address your "wall" but consider it moving forward

    Hope this helps you

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 13, 2016 at 07:35 PM

    John, good to hear from you.

    I've successfully implemented SELECTBLOB in an Appeon Mobile app (to select an image file, save it to the local device sandbox, and display the image in a DW). If I recall correctly, I did run into some problems when using Appeon "Queue Labels" (of_startqueue(), of_commitqueue()). If I avoided those, I had no issues. What sort of issues are you having?

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 13, 2016 at 07:46 PM

    Thank you all for the feedback.

    The "wall" is a non-zero value being returned for the sqlcode property of the transaction object after the SELECTBLOB is issued.

    It succeeds when run as win32.

    This same code line ran successfully under Appeon using MSSQL.

    It's now exhibiting this issue with SQLAny16.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.