At 04:11 PM 5/17/2011, Luc Delcoigne wrote:
I have a report that I print to .rtf file.
Then I have to load the contents of that rtf file into a BLOB field.
What's the best way to do this?
Luc,
This is as simple as 1-2-3.
Here's how:
01. Start R:BASE eXtreme 9.1 (32/64), Build:9.1.4.10602 or higher,
and CONNect the database.
02. Now design a new form and associate the table with BLOB field.
(preferably VARCHAR data type to store and manage .rtf data)
03. Place the "Advanced DB Rich Edit" control on the form and
associate this control with appropriate BLOB (VARCHAR) column.
04. Now place a "Speed Button" or "Enhanced Speed Button" control
and use the following code as "Custom EEP":
-- Load and manage external .rtf data into a BLOB field
PROPERTY TABLE <tablename> 'EDIT'
PROPERTY <AdvDBRichEditCID> LOAD_FROM_FILE 'YourFileName.rtf'
PROPERTY <AdvDBRichEditCID> SHOW_EDITOR 'TRUE'
RETURN
-- First property command will make the current record editable
-- Second property command will load the external .rtf file
-- Third property command will let you review the uploaded .rtf
data using the Enhanced Rich Text Editor of R:BASE BLOB Editor.
05. Save the form and close form designer.
That's all there is to it!
Very Best R:egards,
Razzak.
