Mike, I was assuming you were using a variable rich edit, rather than a DB Rich edit.
But now that I'm looking at properties in R:Docs, I see that there's a property for a variable rich edit that says: PROPERTY <Component ID> LOAD_FROM_FILE 'FileName.RTF' If you really meant DB Rich Edit, to store the report in a DB Field that appears on the form, there might be an easier way, but I would: property table tablename CLOSE update table SET VarcharColName = .vfilecontents WHERE whatever property table tablename OPEN Bill On Sat, Feb 14, 2009 at 1:48 PM, mike epstein sony viao office < [email protected]> wrote: > Bill > > > > Your suggestion worked with regard to getting the contents of the file into > the variable. but a db rich edit field will not hold a default value? How > would I get the variable into the field? > > > > > > *From:* [email protected] [mailto:[email protected]] *On Behalf Of *Bill > Downall > *Sent:* Saturday, February 14, 2009 12:21 PM > *To:* RBASE-L Mailing List > *Subject:* [RBASE-L] - Re: INSERTING A REPORT INTO A FIELD OF A FORM > > > > Hi, Mike, > > > > Not a PROPERTY command, but a trick in the syntax of a SET VAR command to > load the contents of a file into a variable, rather than just the name of > the file. > > > > Here's the simple form: > > > > SET VARIABLE vFileContents VARCHAR = ['filename.ext'] > > > > or, if your filename is in a variable, build that syntax with the brakckets > and quotation marks, and then use macro execution of the command with the > ampersand-variable vCommand: > > > > SET VAR vFileName TEXT = 'filename.ext' > > SET VAR vCommand = ('SET VAR vFileContents VARCHAR = [''' + .vfilename + > ''']') > > &vCommand > > > > Depending on the type of contents in your file, VARBIT might work, too. > > > Bill > > > > On Sat, Feb 14, 2009 at 12:50 PM, mike epstein sony viao office < > [email protected]> wrote: > > Good Morning > > > > I have created a table which I hope will contain the correspondence > (custext varchar) with customers (custid) jobs(jidcode) . > > > > I am using a form to get the values of customer job and memo number. > > The form has a field for customer text. I can load a file printed from a > report as a text file. > > Is there a property command that would insert the text file into the > varchar field in the table or copy the text to the db rich edit varchar > field in the form? > > > > > > > > >
