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

Resolved Import an image from Filestream Table

  1. Issue
0
Votes
Undo
  1. Yasir Masood
    Yasir Masood
  2. PowerBuilder
  3. Thursday, 27 April 2017 20:35 PM UTC

Hi, 

I need your help. How can I import a file from a Filestream table and display it in Powerbulider. 

I am using PB 12.5 and SQL Server 2016. 

Thanks 

  1. File
  2. PowerBuilder
  3. SQL Server
PFC Calendar Extension?
SmartBear Testing
Accepted Answer
Mike S
Mike S Accepted Answer Pending Moderation
  1. Thursday, 27 April 2017 21:59 PM UTC
  2. PowerBuilder
  3. # Permalink

access it just like any other blob column 

 

Comment
Yasir Masood
  1. Yasir Masood
  2. Friday, 28 April 2017 02:07 AM UTC
Can you please provide some example code?

  1. Helpful
Mike S
  1. Mike S
  2. Friday, 28 April 2017 17:41 PM UTC
The sql may depend on the database - different dbms systems may have different sql statements.



blob lb_data



SELECTBLOB blob_column

             INTO :lb_data

            FROM

            WHERE  = :yourvalue;



 



UPDATEBLOB  SET =:lb_data WHERE =:yourvalue

  1. Helpful
There are no comments made yet.
Responses (1)


There are replies in this question but you are not allowed to view the replies from this question.