Attach Files to DB from Powerbuilder

[Sanjeet]

Hi Team,

I want to attached file(Word/PDF, etc) to database from Powerbuilder application. has anyone done this sort of work. Any help would be appreciated.

Sanjeet

[Dan Cooperstock]

First of all, what do you mean by "attach to DB"? Do you mean to save it in a blob field in a row of a database table? You can do that with the Blob functions in PB, though I don't think I've done it personally so I can't tell you the details. But the docs should cover it.

[Sanjeet]

Hi Dan,

Yes, I meant save to database table. I have not not been able to find any docs ins relation to this.

Thanks

[Dan Cooperstock]

There's a topic "Using OLE Columns in a DataWindow Object" in the HTML Books. I found it in the Index, under "blob data, creating columns for". I'm not sure that's exactly what you want, but it might work for you.

Another topic that might be helpful from the HTML Books is "About using OLE in DataWindow Objects".

[Alexander Peters]

I think you should use UPDATEBLOB for this. Dont use OLE functions that saves the file as ole-container.

[Jeff Wayt]

Of the developers who could have put BLOBs in their database, they decided NOT to do it for the following reasons:
1) this bloats the database, making transport, backup and retrieval lengthy or impractical.
2) to create the BLOB you must save it to disk to read it into the BLOB, so it is already stored, and can already be used by other software, too.

[Sanjeet]

Hi Team,

Got this going, using UPDATEBLOB, however, have noticed rapid a growth in DB size.