Page 1 of 1

Memo Fields

Posted: Mon Aug 06, 2012 12:08 pm
by omni
Roger,

We have users that constantly get errors reading/opening memo fields on a database. Not all users, but the ones that get them, it happens constantly. The actual field itself for the record is blank, (len=0) but if I replace it with "", it then opens without error. Can open in foxpro, but opening in Xdot (or in our app) gives operating system error. (Until we replace it with ""). As a note, many of the fields are not blank, but the record that causes the problem is (usually)

Any thought are appreciated.

Fred
Omni

Re: Memo Fields

Posted: Mon Aug 06, 2012 12:21 pm
by rdonnay
How many users are there on the systems that have the problem?

It sounds like they have an unreliable network and that ADS may be the best solution for them.

Are you using the FOXCDX driver?

If so, are your memo fields a length of 10 or a length of 4?

Re: Memo Fields

Posted: Tue Aug 07, 2012 11:31 am
by Auge_Ohr
omni wrote:Can open in foxpro, but opening in Xdot (or in our app) gives operating system error. (Until we replace it with "").
hm ... did you use a own DBESYS.PRG ? what Extension DBT or FPT ? Network ( if yes what ) ?

Re: Memo Fields

Posted: Tue Aug 07, 2012 12:14 pm
by omni
The file are fpt files. 10 character field length.

Server is either win2003, 2008, or 2011. Does not appear to make a difference.

Fred..