Re: TZF - Incorrect Index Length

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