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?
