Programming with dBASE

Author

Memo Fields

Rick

2006-11-02, 7:12 pm

I have a client that is storing more and more into the 2 memo fields in a table. I have seen posts here where, very infrequently, these fields can get corrupted.

I thought I would set up an unattended operation at night to write out the memo field data to text files that could help them reconstruct their notes.

I also remember seeing something posted here about a system of storing memofield data to standard fields. Anyone know who did that system and where I could take a look?

Thanks,
Rick

Todd Kreuter

2006-11-03, 7:13 pm

Rick wrote:
>
> I have a client that is storing more and more into the 2 memo fields in a table. I have seen posts here where, very infrequently, these fields can get corrupted.
>
> I thought I would set up an unattended operation at night to write out the memo field data to text files that could help them reconstruct their notes.

Well, I believe that corruption is not so frequent now days. It may be a
good idea to split the table up, where the memo fields and a key field
is in a separate table.

> I also remember seeing something posted here about a system of storing memofield data to standard fields. Anyone know who did that system and where I could take a look?

Maybe from Ronnie MacGregor? Check his site: www.dBASEdeveloper.co.uk

--
Todd Kreuter [dBVIPS]

Rick

2006-11-03, 7:13 pm

Todd,

Thanks. That was it.

I never have been able to figure what the maximum limit is on a memofield. That is, if a client asks me what the limit is on the notes they can add into a memo filed for a single record, do you know how I would determine that?

Thanks again,
Rick

Todd Kreuter Wrote:

> Rick wrote:
>
> Well, I believe that corruption is not so frequent now days. It may be a
> good idea to split the table up, where the memo fields and a key field
> is in a separate table.
>
>
> Maybe from Ronnie MacGregor? Check his site: www.dBASEdeveloper.co.uk
>
>
>
> --
> Todd Kreuter [dBVIPS]

Todd Kreuter [dBVIPS]

2006-11-04, 12:12 am

"Rick" <Sportman7@netzero.net> wrote in message
news:ymP36x1$GHA.2044@news-server...
>
> I never have been able to figure what the maximum limit is on a memofield.
That is, if a client asks me what the limit is on the notes they can add
into a memo filed for a single record, do you know how I would determine
that?

Rick,

I'm not sure I've heard of any limit. Perhaps you should ask that as a
separate question.

Todd Kreuter [dBVIPS]

Sponsored Links