Thanks Razzak.

That's what I need.

BEst regards, 

Luc D.


From: A. Razzak Memon 
Sent: Wednesday, May 18, 2011 8:02 AM
To: RBASE-L Mailing List 
Subject: [RBASE-L] - re: write file to var


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.


 

Reply via email to