Re: Only one character showing on a memo by Rush
Rush
Mon Jun 30 13:38:07 CDT 2003
Yes, that is what I did. Or you can:
SELECT *, PADR(MyMemo, nMaxLength) as LastField ;
FROM MyTable ;
INTO CURSOR curTemp
SELECT curTemp
COPY TO NewFile.csv [...]
where nMaxLength is the longest string that you care to allow for MyMemo
(but is less than Fox's maximum string memvar length).
- Rush
"Altman" <BAltman@easy-automation.com> wrote in message
news:Op%23b5DzPDHA.2460@TK2MSFTNGP10.phx.gbl...
> Would I be able to use FPUTS() for a memo then.
>
> "Rush Strong" <rush.strong]@[verizon.net> wrote in message
> news:OFEmItyPDHA.1584@TK2MSFTNGP11.phx.gbl...
> > See the docs for COPY TO: under the FIELDS heading, it states that,
unless
> > the target file is an xBase table, memo fields are NOT copied. EXPORT
has
> > the same limitation. I recently ran into the same scenario; I ended up
> > using low level file functions to create the CSV file.
> >
> > - Rush
> >
> > "Altman" <BAltman@easy-automation.com> wrote in message
> > news:eVVvGfyPDHA.1720@TK2MSFTNGP11.phx.gbl...
> > > I am doing a comma delimited file and using the copy to . . . . . .
> > > delimited and everything works fine on my machine and a couple of
other
> > test
> > > machines. I am exporting 17 fields to the file with the last field
> being
> > a
> > > memo field. We have one customer out in the field that when the file
is
> > > created everything writes fine but the memo field only shows the first
> > > letter of the memo and nothing else. Any idea as to what can cause
> > this???
> > >
> > >
> >
> >
>
>