rebuliding Indexes

[STEPHEN COZENS]

Please could someone explain to me how to rebuild indexes, in Alpha 5.Have
tried using the rebuild feature,but the end result is the same.

[Stan Mathews]

Re: rebuliding Indexes

but the end result is the same

Same as what? Rebuild won't recreate indexes that have been corrupted and dropped.

[STEPHEN COZENS]

Re: rebuliding Indexes

Thanks for your reply Stan,to clarify have tried to restructure my index,to no avail,how do I Know if is corrupted.Easy to do with other Database software,
IE Paradox/Access/Approach

[Stan Mathews]

Re: rebuliding Indexes

Not familiar with restructure indexes. Alpha offers define and rebuild. Couldn't be easier to build indexes.

[DickJames]

Re: rebuliding Indexes

Stephen --

An approach we have used to rebuild indexes of tables when they have become corrupted is to use Windows Explorer to delete (or rename) the .cdx file associated with the table having the problem. Then start Alpha Five and re-index the table or the whole data base if you wish.

-- Dick James

[Tom Cone Jr]

Re: rebuliding Indexes

Stephen, twice now you've said you're having a problem with rebuilding an index. But you still haven't furnished any details describing the result you're getting, the expression you are using, or the specific behavior that's "to no avail". If you're still having a problem try describing the sequence you're following as though we weren't there looking over your shoulder, without assuming we know what you are actually doing at each step along the way.

[STEPHEN COZENS]

Re: rebuliding Indexes

Tom, thanks for your response.I have a trading database defined with 4 key fields assigned to an index Purchase, Commodity, Tonnes, Price.when I first created this,the browse performed perfectly.listing records as per the index,
my problems really started.when I created a look up field Name from my contacts database,Name linked to purchase. I have been trying to rebuild the index,but to no avail, as explained under Access/Paradox/Approach very easy to
restructure the database, am I missing something under Alpha ?.

[Al Buchholz]

Re: rebuliding Indexes

I have been trying to rebuild the index,but to no avail,

Please post an image of what you are seeing when you are unsuccesfully trying to rebuild an index. Something is getting lost in the translation...

Are you going to the control panel, tables/sets tab, right click on the table, and selecting define indexes?

[Stan Mathews]

Re: rebuliding Indexes

I agree with Al. We're going to have to have more information.

as explained under Access/Paradox/Approach very easy to
restructure the database,

Previously you said it was easy ... to restructure an index.

[STEPHEN COZENS]

Re: rebuliding Indexes

Yes went into the index builder, index completely different to what I had,
originally planned, tried to change it Alpha would not let me restructure it,
saying table was not filled.

[Tom Cone Jr]

Re: rebuliding Indexes

Stephen, details are important. What is the exact error message? What are you doing when it occurs? Are you "restructuring" a table? Are you "defining" an index?

Also, tell us the field names and data types you want to use in your index expression. The names suggest a variety of data types. If this guess is correct your expression defining the index must convert everything to character type most likely.

[STEPHEN COZENS]

Re: rebuliding Indexes

Tom,trying to rebuild index.not restructuring database,have just tried to rebuild index,no error messages this time,but new index did not work,have same browse
with records out of order, is the database corrupted.

[Stan Mathews]

Re: rebuliding Indexes

See if my first screenshot displays the issue you are experiencing.

If so, hilight all rows below the actual field names you want to keep (second screenshot). Hit the delete key, up arrow into the last Name cell, use the toolbar Save button.

For some reason Alpha thinks you are starting another Name-Type-Width_Decimal line and wants you to finish it.

[STEPHEN COZENS]

Re: rebuliding Indexes

Stan was trying to rename index, changing field order to get my browse list to work,the suggestion on this board to remove the index in windows explorer, and the start again.seems to be easy option,cant understand why you cannot do it simply in Alpha, perhaps I am thick,but I find Alpha superb on features,
but on long and hard learning curve

[Al Buchholz]

Re: rebuliding Indexes

Stan was trying to rename index, changing field order to get my browse list to work,the suggestion on this board to remove the index in windows explorer, and the start again.seems to be easy option,cant understand why you cannot do it simply in Alpha, perhaps I am thick,but I find Alpha superb on features,
but on long and hard learning curve

Stephen

Alpha builds some indexes for it's own purposes to support field rules choices that you have made.

When that occurs, you should make a new index and name it something other than a field name.

Deleting the .cdx field from windows explorer won't change the behavior from Alpha.....

Images of what you are doing will fill in the gaps of what is happening and will help us to help you learn.

It is always tough to unlearn one system to re-learn another. Either systems are equally good, but the one that you start with is more familiar and easy to fall back on...