• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • How to insert/retrieve image in datawindow stored in database

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)
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Tuesday, 12 October 2021 03:34 AM UTC
  2. PowerBuilder
  3. # 1

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.
Sivaprakash BKR
Sivaprakash BKR Accepted Answer Pending Moderation
  1. Tuesday, 12 October 2021 07:05 AM UTC
  2. PowerBuilder
  3. # 2

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.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.