Discussions tagged BLOB
I have an Infomaker 2019R3. And because bundled with another software exactly this version.
I tried to embed a picture into a report using OLEDatabaseBlob. The retrieved table contains a blob field and an id field.
The definition fields of blob con...
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
- Resolved
- Issue
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...
Blob not working
- How-to
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...
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' ...
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
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
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_...
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
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. ...
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
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 same issue ...
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...
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
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...
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...
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...
Find Questions by Tag
.EXE
.NET 6.0
.NET Assembly
.NET Core 3.1
.NET Core Framework
.NET DataStore
.NET Std Framework
32-bit
64-bit
ADO.NET
AEM
AI
Algorithm
Amazon AWS
Android
Apache
API
APK
App Store
App Store (Apple)
Appeon Workspace
Appeon Xcelerator Plug-in
Architecture
Array
ASE
Asynchronous Methods
Authentication
AutoBuild
AutoCompiler
Automated Testing
Automation
AutoScript
Azure
Barcode
Base64
Batch
BigData
BLOB
Branch & Merge
Browser
Bug
Build
Button
C#
C# Class Importer
C# Editor
C# Model generator
Calendar
Camera
Certificate
Chrome
Citrix
Class
Client
Client/Server
Cloud
Cluster
Collection
COM
Command Line
Compiler
Compression
Computed Field
Configuration
Controls
Cookies
Cordova
Crash
Cross-Platform
Crosstab
CSharpAssembly
CSharpObject
CSS
CSV
Cursor
Data
Database
Database Driver
Database Painter
Database Profile
Database Provider
DataObject
DataSource
DataStore
DataStore (C#)
DataStore (PS)
DataType
DataWindow
DATE
DATETIME
DB2
Debug
Debugger
Debugging
Deployment
Design
DLL
DO-WHILE
Dockable
Docker
Documentation
DOUBLE
Download
DragDrop
Edge
Edit Style
Editor
Elevate Conference
Email
Embedded SQL
Emulator
Encoding
Encryption
Enhancement Request
Entity
Entity Framework
ERP
Error
Event
Event Handler
Event Handling
Excel
Exception
Export
Expression
External Functions
F#
Field
File
File Access
Filter
Firefox
Firewall
Font
FOR-NEXT
Foreground
Format
Function
Garbage Collection
GeoLocation
Git
Graph
HANA
Hash
Header
HTML/5
HTTP/S
HTTPClient
Icon
IDE
Identity
IIS
IMAPI
Import
InfoMaker
Inheritance
Installation
Integer
IntelliSense
Interface
Internet
Internet Explorer
iOS
IPA
iPad
iPhone
IWA
J#
Java
JavaScript
JBoss
JDBC
JOIN
JSON
JSONGenerator
JSONParser
Kestrel
Label
Lambda
Large File
LDAP
Library
License
LINQ
Linux OS
Load Balancing
Localization
Localized PBVM
Log In
Log Out
Logging
LONG
LONGLONG
macOS
MAPI
Maps
MDI
Memory
Memory Leak
Menu
Merge
MessageBox
Messagging
Method
Migration
MIME TYPE
Mobile
Model
ModelStore
ModelStore (C#)
MSOLEDBSQL
Multi Threading
MVC
MySQL
n-Tier
Namespace
NativePDF
NVO
OAuth
ODATA
ODBC
Office
Offline
OLE
OLEDB
Online
Open Source
OpenAPI
OpenSSL
Oracle
OrcaScript
Other
Outlook
Output
Package
Parameter
Patch
PayPal
PB Classic
PB Native
PB.NET
PBC
PBD
PBDOM
PBG
PBJVM
PBL
PBNI
PBORCA
PBVM
PBX
PDF
Performance
Permission
PFC
Picture
Pipeline
Play Store (Google)
Plugin
Popup
Port
POST
PostgreSQL
PowerBuilder
PowerBuilder (Appeon)
PowerBuilder (SAP)
PowerBuilder Compiler
PowerBuilder Runtime
PowerClient
PowerScript (PS)
PowerScript IDE
PowerScript Migrator
PowerServer
PowerServer Mobile
PowerServer Toolkit
PowerServer Web
PowerServerLabel
Print
Properties
Proxy
Publish
PULL
PUSH
Query
Regression
Release
Renew
Resize
Response
REST
Retrieve
RibbonBar
RibbonBar Builder
Rich Text
Roadmap
RPC
Runtime Packager
SaaS
Scaffolding
Script
SDI
SDK
Security
Server
Service
Session
Single Sign-on
Size
SMTP
SMTPClient
SnapDevelop
SOAP
Sort
Source Code
Speech Recognition
SQL
SQL Anywhere
SQL Server
SqlBuilder
SqlExecutor
SQLite
SqlModelMapper
Storage
Stored Procedure
Subscription
SVN
Swagger
Syntax
TabbedBar
TabbedView
Tablet
TabPage
Target
TE Control
Testing
Text
TFS
Theme
TIME
Timer
TLS/SSL
Tomcat
TortoiseGit
TortoiseSVN
Transaction
Transparency
Trial
Trigger
TRY-CATCH
TX Control
Type
UI
ULONG
UltraLite
Uninstall
Unit Test
Unit Testing
UNIX OS
Update
Upgrade
Upload
URL
User Center
User Object
UWP
Validation
VARCHAR
Variable
Versioning
Visual Studio
Visual Studio Code
VM
Voice
Warning
WCF
Web API
Web Extensions
Web Service
WebBrowser
WebForms
WebLogic
WebSphere
WildFly
WinAPI
Window
Windows OS
WinForms
Wizard
Workgroup
Workspace
WPF
XCODE
XHTML
XML
Zoom