Filestream on PowerBuilder

Question

I am storing some (blob) images on a SQL 2012 express using filestream. I want to know how to show and retrieve those images on my client app from the database using PowerBuilder 12.5

Any idea?

Thanks in advance.

Answer 1

From the PB help file:

Blob Emp_id_pic

SELECTBLOB Emp_pic        
INTO :Emp_id_pic         
FROM Employee        
WHERE Employee.Emp_Num = 100        
USING Emp_tran ;

p_1.SetPicture(Emp_id_pic)