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?
>
>
>
>
>
>
>
