Monday, December 1, 2008
From The Edge: Managing Binary Large Objects (BLOBs) in R:BASE
Supported Versions:
. R:BASE 7.6 for Windows (Build: 7.6.5.31125 or higher)
. R:BASE C/S:I 7.6 for Windows (Build: 7.6.5.31125 or higher)
. R:BASE Turbo V-8 for Windows (Build: 8.0.19.31125 or higher)
Section: Enhanced Tools and Commands
Have you seen the new "R:BASE BLOB Editor" in R:BASE 7.6, or
Turbo V-8 for Windows?
One of the more exciting features in R:BASE for Windows is the
ability to add, edit, delete, and display binary files-Binary
Large OBjects, or BLOBs. This term refers to binary data as
opposed to ASCII data. The data types VARBIT and BITNOTE were
added for storing binary files within an R:BASE database. In
addition, the VARCHAR data type lets you store large ASCII data
files (Large OBjects, or LOBs). The data for VARBIT and VARCHAR
data types is stored in the fourth R:BASE data file, DBName.RB4
(R:BASE 7.x) or DBName.RX4 (R:BASE Turbo V-8 and R:eXtreme 9.0).
Managing multi-page images is also among the new enhancements
of R:BASE BLOB Editor.
The RBBEDIT command is also enhanced to launch the R:BASE
BLOB Editor, with which you can create or edit binary files.
You can also use the RBBEDIT (or RBBE) command to launch the
R:BASE BLOB Editor for managing external files at the R>
Prompt, in a command file, or in an EEP. Depending on the file
format and the extension, the R:BASE BLOB Editor will display
the available options accordingly.
Options: filename.ext
Specifies an external ASCII text, RTF, or image file. The R:BASE
BLOB Editor recognizes the following image formats:
AFI, BMP, DCX, EMF, GIF, ICO, JPEG, JPG, PCC, PCX, PNG, TGA, TIF,
TIFF, VST, WMF
Examples:
01. The following will display the "Images" and "Multipage Images"
tabs of the Note/BLOB Viewer/Editor for you to load an image.
RBBEDIT
or
RBBE
02. The following will display a bmp image in the "Images" tab of
R:BASE BLOB Editor.
RBBEDIT myphoto.bmp
03. The following will display the RTF file in the "RTF" tab of the
R:BASE BLOB Editor.
RBBEDIT myfile.rtf
This command will also create a new file if one is not already
defined.
04. The following will display the text file in the "Note/VarChar"
tab of the R:BASE BLOB Editor.
RBBEDIT mytext.txt
A technical document with complete details is also available at:
From The Edge: http://www.razzak.com/fte/
Topic:
Managing Binary Large Objects (BLOBs) in R:BASE 7.6 and Turbo V-8
Very Best R:egards,
Razzak.
