Thank you, Mike.
Luc D.
--------------------------------------------------
From: "Mike Byerley" <[email protected]>
Sent: Wednesday, May 18, 2011 1:38 PM
To: "RBASE-L Mailing List" <[email protected]>
Subject: [RBASE-L] - re: write file to var
OK.. in the absence of an RBase control, use my method to INSERT the
variable value into a table with the appropriate datatype.
----- Original Message -----
From: "Luc Delcoigne" <[email protected]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Wednesday, May 18, 2011 2:26 AM
Subject: [RBASE-L] - re: write file to var
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.
