1. 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 

Accepted Answer
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
  1. Yasir Masood
  2. Friday, 28 April 2017 02:07 AM UTC
Can you please provide some example code?

  1. Helpful
  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.


There are replies in this question but you are not allowed to view the replies from 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.