Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (2)

Resolved How to insert/retrieve image in datawindow stored in database

  1. How-to
0
Votes
Undo
  1. Winthor Caingles
    Winthor Caingles
  2. PowerBuilder
  3. Tuesday, 12 October 2021 03:08 AM UTC

Good day,

 

Need help... 

 

How can I store and retrieve pictures in database. I'm planning to display the e-signature in my datawindow based on the user account... Is there a script for this? 

 

Appreciate your help...

 

Thank you.

How can align the staticText on the bottom of my U...
PowerBuilder version 6.5 - Compile and Build query
Responses (2)
Sivaprakash BKR
Sivaprakash BKR Accepted Answer Pending Moderation
  1. Tuesday, 12 October 2021 07:05 AM UTC
  2. PowerBuilder
  3. # 1

Hello,

UpdateBlob and SelectBlob are the commands one need to use to update / select blob (or image) fields from database.   If you want to display blob column in a grid/tabular dw, then TableBlob is your friend.

TableBlob in Appeon

https://community.appeon.com/index.php/articles/tips-tricks-techniques-articles/17-powerbuilder/161-using-the-new-tableblob-column-type

From old Sybase forum

https://answers.sap.com/questions/10442404/using-tableblob.html

HTH

Happiness Always
BKR Sivaprakash

 

Comment
Load more comments
Winthor Caingles
  1. Winthor Caingles
  2. Wednesday, 13 October 2021 02:11 AM UTC
The table blob is working in a datawindow...however, when I created another datawindow with different table error is popoing "incorrect syntax near =".... I checked the key clause and it is the same.... for the colume saa and retrieval argument :saa..... saa = :saa
  1. Helpful
Sivaprakash BKR
  1. Sivaprakash BKR
  2. Wednesday, 13 October 2021 05:18 AM UTC
We have done here in a couple of dw (only) with no issues so far. My suggestion would be

Start from scratch, not saveas any old dw and no copy / paste, type everything

Check for any such errors.



  1. Helpful
Winthor Caingles
  1. Winthor Caingles
  2. Thursday, 14 October 2021 05:54 AM UTC
thanks...
  1. Helpful
There are no comments made yet.
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Tuesday, 12 October 2021 03:34 AM UTC
  2. PowerBuilder
  3. # 2

you can use a picture or an inkpicture.

If  you do a search on “inkpicture” you’ll find several useful posts. For example https://community.appeon.com/index.php/qna/q-a/display-blob-image-in-app

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.