Re: FoxFix 5.2 detecting memo corruption after COPY TO?

From: William Fields (Bill_Fields_at_azb.uscourts.gov)
Date: 05/18/04

  • Next message: William Fields: "Re: FoxFix 5.2 detecting memo corruption after COPY TO?" 
    Date: Tue, 18 May 2004 13:08:58 -0700

    Oh yeah, and FoxFix does not detect memo file corruption when scanning
    tables created through the VFP IDE or the CREATE TABLE syntax, only on
    tables created via COPY TO.... 

    -- 
William Fields
MCSD - Microsoft Visual FoxPro
MCP - Win2k Pro
US Bankruptcy Court
Phoenix, AZ
"I love deadlines. I love the whooshing sound they make as they fly by."
    - Douglas Adams (R.I.P.)
"Lew" <lew@clsystems.com> wrote in message
news:OZqOPyPPEHA.3264@tk2msftngp13.phx.gbl...
> What about copy to .... type .... ? FoxFix may be out of sync with the VFP
> table version that's being created.
> -Lew
> "William Fields" <Bill_Fields@azb.uscourts.gov> wrote in message
> news:%23pn9SAPPEHA.3016@tk2msftngp13.phx.gbl...
> > Hello,
> >
> > We create a .DBC and export preformatted data files to disk just before
> > running reports against them. I just scanned the resulting tables (that
> were
> > created with the "COPY TO FileName DATABASE DatabaseName"  command) and
> both
> > FoxFix 5 and FoxFix v5.2 detect memo file corruption. Here are some of
the
> > results from the error logs:
> >
> > 311 (0x00000137)
> > Memo Next Available Block (NAB) invalid
> >
> > 312 (0x00000138)
> > Memo block size invalid
> >
> > 304 (0x00000130)
> > Memo file truncated by 43 bytes. Probably benign and due to
restructuring
> > within FoxPro.
> >
> > Can anyone else confirm this behavior? We're having some weird Crystal
> > Reports issues and were wondering if this could be an issue.
> >
> > FYI - Xitech tech support is difficult to deal with....
> >
> > Thanks.
> >
> > -- 
> > William Fields
> > MCSD - Microsoft Visual FoxPro
> > MCP - Win2k Pro
> > US Bankruptcy Court
> > Phoenix, AZ
> >
> > "I love deadlines. I love the whooshing sound they make as they fly by."
> >
> >     - Douglas Adams (R.I.P.)
> >
> >
> >
>
>
  • Next message: William Fields: "Re: FoxFix 5.2 detecting memo corruption after COPY TO?"

    Relevant Pages