Discussions tagged BLOB
How to print pdf files from powerbuilder without an external pdf tool
- How-to
- Last updated 1 month ago
- Chris Pollach @Appeon replied 1 month ago
We have pdf files getting created from the blob data that we receive from a API call, we want to print these PDFs without any user interface immediately after receiving data from API.
These can be. Achieved using shell execute/ batch file using exte...
SELECTBLOB and UPDATEBLOB not working
- Issue
- Last updated 4 months ago
- Chris Pollach @Appeon replied 4 months ago
I am trying to save a datawindow definition to SQL Server Varchar(Max) column, using UPDATEBLOB and the command runs without error, but the data saved is severely truncated. Using ODBC, SQL Server 2022, and PB 2022 R3 Build 3356.
lblb_DWSyntax = Blo...
Hi,
We have stored icon.bmp stored as a blob in MSS DB, and we are trying to fetch that file in code but blob is able to fetch only 32767 bytes data.
We tried adding PBMaxBlobSize in dbparams through ODBC connections, but it doesnt helped. Is their...
Issue with PowerBuilder 2022 R2 'Extract' functionality
- Resolved
- Issue
- Last updated 10 months ago
- Sajith Prasannan replied 10 months ago
Dear Developers,
Please provide guidance on the issue I'm encountering in my project.
I have a .pdf file that has been compressed with zip.exe and stored in a table as a blob. I need to extract this file in PowerBuilder 2022 R2 using the 'Extract' ...
Looking for Examples of Storing and Retrieving Documents in a SQL Anywhere database
- How-to
- Last updated 1 year ago
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...
Sending large files with PostData and SnapDevelop
- Resolved
- How-to
- Last updated 1 year ago
- Francisco Martinez @Appeon replied 1 year ago
I need to send very large documents (usually Word) to a SnapDevelop API so that I can upload them into a database table. The documents are often greater than 30MB. I initially tried using the SendRequest method. It worked great until the file size...
How to work with Azure Blob Storage
- Resolved
- How-to
- Last updated 1 year ago
- Zhang JX replied 1 year ago
Hi all,
We are facing issue with documents/files accessing via ftp after enabling Azure Fortigate Firewall.
The alternative solution is either to use SFTP or moving to Azure Blob Storage then dealling with those application with attachment document...
We have a functionality that consists of uploading attached files with a java servlet.The way we are doing it is as follows:
ole_object_upload.object.connecttonewobject("InternetExplorer.Application") ole_object_upload.object.Navigate(ls_...
Difference in size of the image when displayed in two different ways
- Issue
- Last updated 2 years ago
- Chris Pollach @Appeon replied 2 years ago
Hello,
PB 2019 R3, PostgreSQL 11
Got blob data in one of our tables where images are stored, which we are showing in two different ways. The output looks different in the display size. Why?
Left hand side: which is a picture column [ Inser...
Retrieve saved image from other application(s)
- Resolved
- How-to
- Last updated 2 years ago
- Sivaprakash BKR replied 2 years ago
Hello,
PB 2019 R3, Postgresql 11
I could store and retrieve image files that's stored from the Powerbuilder application. Now through a mobile application, they store images in the same database that PB applications need to retrieve and update. ...
Selectblob for RTF stored in a DB
- Issue
- Last updated 2 years ago
- Ken Guo @Appeon replied 2 years ago
Hello,
I am moving an old application from Powerbuilder 9.0.2 to Powerbuilder 2019 R3; part of the application collects pieces of RTF documents, and composes them together, into the Rich Text Editor.
In PB9 to achieve this we had queries using SELE...
Need: To implement a method in a Powerbuilder web service to save a file in a network directory receiving the file (blob) and the full path as parameters.
IssuesScenario 1: Method implemented with Powerbuilder file functions.Problem: It works when u...
Table blob cannot be found?
- Resolved
- Issue
- Last updated 3 years ago
- Mathias Jespers replied 3 years ago
Hello,
For our database driver we are switching to MS OLE DB.
During testing it came to my attention that datawindows containing table blobs are causing dwruntimeerrors.
I get the message "Select Error: Blob Column doesn't exist". Now I checked th...
Hello,
PB 2019 R3 2703
1. in any datawindow painter, Select Insert -> Control -> Table Blob
2. A response window opens, which we couldn't resize it.
It makes tough to select (long) table name ? Is there any way to resize it ?
The sam...
Tableblob not working when MultipleActiveResultSets=FALSE
- Resolved
- Issue
- Last updated 3 years ago
- Brad Howie replied 3 years ago
I support a mature application using PowerBuilder 2017 R3 and SQL Server via ADO.Net.
Our user community recently requested we add signatures onto some of our datawindow documents. The 'tableblob' datawindow object seems perfect for this, but unfor...
Mobile app issue displaying images with a tableblob object in a datawindow
- Issue
- Last updated 4 years ago
- Armeen Mazda @Appeon replied 4 years ago
Hello everybody, I have a mobile application for Android and I have a problem displaying images in a datawindow object with a tableblob object, when I'm designing the datawindow object in the preview, the images show fine, but when I deploy the app a...
Mobile app updateblob MySQL error code 10999
- Resolved
- Issue
- Last updated 4 years ago
- Arturo Quiroga replied 4 years ago
Hello, I have an issue with a mobile app, the database is MySQL 5.7, when I try to upload a photo from the smartphone doing an updateblob I got this error:
Error code: 10999 Object reference not set to an instance of an object.
The database f...
SELECTBLOB with ODBC SQL driver and application roles
- Issue
- Last updated 4 years ago
- Chris Pollach @Appeon replied 4 years ago
PB 2019 R2 Build 2279
We have a problem using application roles with ODBC driver for SQL Server and the SELECTBLOB function:
First we connect to the sql database using "ODBC Driver 17 for SQL Server" (or 13), then we activate application role by ex...
Information Required [ Appeon PowerBuilder 2019 Datatype Blob ]
- How-to
- Last updated 4 years ago
- Michael Kramer replied 4 years ago
I am working on some of features available in Appeon (PowerBuilder 2019) for upgrading from the old version. I need some information/help for the following topics
Converting Blob into string
I am encrypting the plain text using “SymmetricEncryp...
Convert .NET DataTable to DataWindow BLOB
- How-to
- Last updated 4 years ago
- Ricardo Jasso replied 4 years ago
I have a .NET assembly that I've generated from NVOs. One of the methods I need to call accepts a BLOB of a DataWindow state (calls datastore.setfullstate(BLOB), then performs validation on datastore).
How would one go about generating a byte array ...
- Page :
- 1