We currently have a PowerBuilder App which indexes documents (word docs, pdf's, Excel,.. text) in a file directory and allows them to be selected and opened via the Windows app associated with that file type.

We are considering storing the documents in a BLOB in the sqlanywhere database (likely in a Long Binary)

If possible we would like to pass the retrieved document directly to a viewer (OLE?) with first writing out as a file in a temporary directory.

Can anyone direct us to helpful examples of powerbuilder code to do this - also any recommendations about datatypes and data storage would be helpful.

Thanks