Discussions tagged BLOB
Mobile app issue displaying images with a tableblob object in a datawindow
- Issue
- Last updated 6 months ago
- Armeen Mazda @Appeon replied 5 months 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 6 months ago
- Arturo Quiroga replied 6 months 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 6 months ago
- Chris Pollach @Appeon replied 6 months 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 11 months ago
- Michael Kramer replied 11 months 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 1 year ago
- Ricardo Jasso replied 1 year 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 ...
How do I update a blob in an Oracle table column dynamically?
I know about UPDATEBLOB in PowerBuilder imbedded statements, like
UPDATEBLOB “tablename” set “blob_column_name” = :lblob;
This script uses SQLSA because the column name is known only...
Uploading Blob to MS SQL Server
- Resolved
- How-to
- Last updated 2 years ago
- Marco Meoni replied 2 years ago
Hi,
I'm having an issue uploading a image Blobs to a MS SQL Server and can't figure out where I'm going wrong (Using Powerbuilder 2017 R3, both in Desktop App and Appeon Mobile).
The Upload Blob is working and creating the database records but it l...
Inserting Blob into MS SQL database from Appeon Mobile?
- Resolved
- How-to
- Last updated 2 years ago
- Zhao Kai @Appeon replied 2 years ago
Hi,
How are people copying files (images or other files) from Appeon Mobile apps to their server?
I am trying trying to use UPDATEBLOB to store the image in the database but the below code is throwing the following error: "Error Code: 10999. Object...
Writing BLOB from PB2017R2 DataWindow
- Advice
- Last updated 2 years ago
- David Lacey replied 2 years ago
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...
hi all
how do i save a blob to a pic file ?
thanks
...
Updateblob on MS SQL Server
- Issue
- Last updated 2 years ago
- Chris Pollach @Appeon replied 2 years ago
In an app I am working on I need to update a column in a Microsoft SQL Server database table with a PDF file.
I am using the Microsoft SQL Server ODBC connection.
The table (ISPDF02) has a column called ISPDF which is of data type IMAGE and a C...
I have a bunch of PDFs that are saved in our database using the OLE Database Blob control in a DataWindow. Is there a way to save these PDFs as a standalone PDF file using code? Right now, if I use the code below, I am unable to open the "Test.pdf"...
Size limit when combining to blobs
- Issue
- Last updated 3 years ago
- Chris Pollach @Appeon replied 3 years ago
When I try to combine two blobs with a size of 100 mb each, PowerBuilder throws an error message.
When I try to combine two blobs with a size of 50 mb each, everything works without problems.
Is there a size limit when I join blobs together?
...
Dynamically retrieve data from Blob column
- Issue
- Last updated 3 years ago
- Luiz Ribeiro replied 3 years ago
Is there a solution to retrieve blob dynamically. The table and column name is known only at runtime.
It appears that datawindow has blobtable column that actually retrieves blob data, but there is no method to assign it to Blob variable.
The ...
Saving a BLOB from Oracle DB to a file when 300Meg or larger using PowerServer Web
- Resolved
- Issue
- Last updated 3 years ago
- Appeon Support Team replied 3 years ago
Looking for a way to save an Oracle BLOB out to a file on a client through PowerServer Web?
Average Blob size is 350 Meg. I have tried using SelectBlob but is not working... Out of memory.
Help?
...
- Page :
- 1