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.