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
==^================================================================