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

Resolved Writing BLOB from PB2017R2 DataWindow

  1. Advice
0
Votes
Undo
  1. David Lacey
    David Lacey
  2. PowerBuilder
  3. Friday, 20 July 2018 10:13 AM UTC

Hi,

Environment : Appeon PowerBuilder 2017 R2

Database : SQL Server 2012

Would I be right in assuming that even with an OLE Database blob column in a datawindow that the actual writing of the blob to a varbinar(Max) column still has to be achieved in Powerscript using UPDATEBLOB?

Essentially, I wish to have a PB File Open Dialogue control that allows a user to navigate to a file on the file system and then have that data written to the database. Is it possible to have PB call the .net framework to do such a thing?

 

Thank you

David

 

 

 

 

 

 

  1. .NET Core Framework
  2. BLOB
  3. PowerBuilder (Appeon)
Datawindow: Best way to add a new group level in t...
PowerBuilder and BOX API Integration
Responses (2)
David Lacey
David Lacey Accepted Answer Pending Moderation
  1. Friday, 20 July 2018 13:29 PM UTC
  2. PowerBuilder
  3. # 1

Thank you, Chris. Much appreciated.

 

Comment
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Friday, 20 July 2018 13:25 PM UTC
  2. PowerBuilder
  3. # 2

Hi David;

  1. Yes, you would still need to use the FileReadEx() and UpdateBlob commands in PB to copy the external file into a SS Blob column.
  2. FWIW: I have done this before as well by having the PB App call an ISQL script to import the files into a Blob.
  3. Same as #2, but calling an SSIS ETL package to do the work.

Food for thought.

HTH

Regards .. Chris

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