Re: TZF - Incorrect Index Length

Marie,
        You may be right about having to put the keys in the code, although I have
never done it since DOS days.  Here is the present state of my investigation:
        I constructed a completely independent version of my data file.  Using
JTBrowse, I populated it from my .dbf file which I made earlier using Quattro Pro.
In my program the data file, and all five of its its indexes worked.  I added new
data and tested them all.  I then deleted the .mdx file to test the ability of the
program to generate a new index file.  It failed to do so, giving me the error box
which I have already quoted.  Very frustrating!!!
Bill

Marie Vihonsky wrote:

> Hi Bill,
>
> First, are you sure that the total length of the key is not greater than
> 100 characters using the 40 char field?
>
> You might try removing the tzdbf database from the form and then re-add
> it.  I still think that the field length is being retained somewhere.
>
> I have found that coding the index keys within the program - not the
> Object Inspector - allows for changing stuff better.  Why? I don't know,
> but it does.  Must have something to do with what Delphi does in the
> background for maintaining code.
>
> Marie
>
> William T. Marchant wrote:
> > 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
==^================================================================