Re: TZF - Incorrect Index Length

Philip,
        Thanks for the response. I intend to keep checking till I find it.  One
error in my last message.  I am using Topaz 7.51, not 7.1.
Bill

Philip Kidder wrote:

> Bill,
>
> I reread your email and noticed that you did delete the index file. You need
> to make sure that the size in the field definitions of the database is
> correct and shows 40 not 25.
>
> Phil
>
> ----- Original Message -----
> From: "William T. Marchant" <[email protected]>
> To: <[email protected]>
> Sent: Friday, February 21, 2003 8:49 PM
> Subject: Re: TZF - Incorrect Index Length
>
> > Hi,
> >         Thanks for the suggestion Marie.  I tried it again, and it still
> > doesn't work.  Further data might be helpful.  Using Topaz 7.1 and
> > Delphi 5
> > 1.  Deleted the .mdx file
> > 2.  In the object inspector selected the IndexList edito.
> > 3.  Deleted all five of the index definitions.
> > 4.  Redefined them all
> > 5.  Deactivated then reactivated the file in the object inspector.
> > 6.  F9 to run the program
> > 7.  Error Message "Error 266 (invalid size)  Incorrect length: NMust be
> > 1 to
> > 100. .\memberlist.mdx (Open Index/Set_Index_To)"
> >
> > I then repeated 1, 2, 3, Redefined only the first four indexes, (Omiting
> > the
> > e-mail-address index). Repeated 5, 6.
> > Program ran just fine without the fifth (e-mail address) index.
> >
> > Inspection of both .dbf files structure using EGBrowse, shows them to be
> > identical.
> >
> > I have run all five indexes with both original data and repopulated
> > data.  The
> > .mdx files produced can be seen in a binary inspection.  The Original
> > Data
> > file has 40 byte entries in the e-mail index.  The indexes all work.
> > The
> > Repopulated Data file shows 25 byte spaces for the e-mail index, but
> > there is
> > no data in the spaces.  The program refuses to run without proper
> > indexes, and
> > I get the error quoted above.
> > Bill.
> >
> > Marie Vihonsky wrote:
> >
> > > Hi Bill,
> > >
> > > Try 'inactivating' and 'activating' the database in the Object Inspector
> > > so that the field sizes get updated in the program.
> > >
> > > Marie
> > >
> > > William T. Marchant wrote:
> > > > Hi all,
> > > >         I have a Tzdbf file using five indexes.  It has been running
> > > > sucessfully for over two years.  Recently I repopulated an empty copy
> of
> > > > the .dbf file with new data.
> > > >         Using Eitan's EGBrowse (a terrific program by the way!) I
> > > > appended records from a .dbf file made using Quattro Pro, and saving
> the
> > > > data as a .dbf.
> > > >         Four of the indexes work.  The fifth, using a field of e-mail
> > > > addresses reports that the index length is incorrect.  The field is 40
> > > > characters wide.  One of my searches revealed that the width expected
> is
> > > > 25 characters.  Yet the field in the file made with Quattro is 40
> chars
> > > > wide, and the field in the resulting .dbf made with EGBrowse is also
> 40
> > > > chars wide.
> > > >         I am at a loss to discover my error (I presume it is mine),
> but
> > > > I cannot find it.  Does anyone have suggestions about where to look?
> > > > Bill Marchant
> > > >
> > > >
> > > >
> > >
> >
> >
>

==^================================================================
This email was sent to: [email protected]

EASY UNSUBSCRIBE click here: http://topica.com/u/?clvXPN.a5kvff.Z2NsZHQt
Or send an email to: [email protected]

TOPICA - Start your own email discussion group. FREE!
http://www.topica.com/partner/tag02/create/index2.html
==^================================================================