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

 

 

 

 

 

 

Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Friday, 20 July 2018 13:25 PM UTC
  2. PowerBuilder
  3. # 1

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.
David Lacey Accepted Answer Pending Moderation
  1. Friday, 20 July 2018 13:29 PM UTC
  2. PowerBuilder
  3. # 2

Thank you, Chris. Much appreciated.

 

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.