Thursday, May 1, 2025
Tip of the Day: Using SQL to Launch the BLOB Editor
Product: R:BASE 11
Build: 11.0.2.20415 or higher
Section: Commands
Keywords: RBBEDIT, BLOB Editor, SELECT, SQL
Did you know that you can use a SELECT statement with the RBBEDIT command to
edit BLOB data?
The RBBEDIT command has been enhanced to launch the BLOB Editor, allowing you
to edit BLOB data directly from SQL.
The syntax uses the SQL keyword before the query syntax.
The below opens the BLOB Editor and displays the Contact Photo for ID number
1001:
RBBEDIT '<SQL SELECT ContPhoto FROM Contact WHERE ContID = 1001>'
The feature mimics the behavior of double-clicking a BLOB field in the Data
Browser.
The "Managing BLOBs" From The Edge technical document has been updated to
include the enhanced RBBEDIT command.
>From The Edge:
https://www.razzak.com/fte/
"Managing BLOBs" Table of Contents
Part I Introduction
Part II The Data Types
Part III R:BASE BLOB Editor
Part IV Displaying BLOBs in Forms
Part V Displaying BLOBs in Reports/Labels
Part VI Using Commands with BLOBs
Part VII Managing Database Stored Files
Part VIII BLOB Editor Settings
Part IX Sample Use of BLOBs
Very Best R:egards,
Razzak.
R:BASE Technologies, Inc.
https://www.rbase.com
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion visit
https://groups.google.com/d/msgid/rbase-l/1103941292.208373.1746091685934%40email.ionos.com.
