1. David Lacey
  2. PowerBuilder
  3. Friday, 20 July 2018

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

 

 

 

 

 

 

David Lacey Accepted Answer Pending Moderation
0
Votes
Undo

Thank you, Chris. Much appreciated.

 

Comment
There are no comments made yet.
  1. Friday, 20 July 2018
  2. PowerBuilder
  3. # 1
Chris Pollach Accepted Answer Pending Moderation
0
Votes
Undo

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.
  1. Friday, 20 July 2018
  2. PowerBuilder
  3. # 2
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.