CANNOT FIND ITEMS AFTER ADDING TO DBASE3 2

[aa18ron]

I transferred my dbase files from a previous computer running Win98 to a new computer running WinXP.

But in moving the desktop icon for dbase to the task bar in WinXP, I did something that prevents me from retrieving newly added items.

I have 2 config.db files, the first in c:\files\db is:

default=c:
path=c:\files\db
color=gr/b,w/r,gr
command=clear



The second in c:\dbase is:

default=c:
path=c:\files\db
color=gr/b,w/r,gr
command=clear



I thought indexing might help but at the dot prompt if I type:

use telephon
set telephon to telephon.ndx

I get an error signal. As you can see from the above I am semi-computer-illiterate. Help would be much appreciated.

 

[tviman]

Try this:

use telephon index telephon

This assumes that telephon is the name of your DBF file and the index is also named telephon. If not, use this format:

use <database name> index <index name>

There's always a better way. The fun is trying to find it!

 

[aa18ron]

Thanks MUCH tviman.

I used your format:

.use telephon index telephon.ndx

And then added

.Reindex (Suggested the last time I had trouble by MiggyD)

and HAPPY DAY!

 

[tviman]

Outstanding!

There's always a better way. The fun is trying to find it!

 

[dbMark]

aa18ron,
From your original post I think what you meant to write was:

use telephon
set index to telephon.ndx

The suggestion by tviman opens the index at the same time the table is opened. But you don't have to reopen the table every time you change to another index - assuming you have more than one index. The SET INDEX TO command allows you to change indexes at anytime you have the table open. Just remember that if you change any fields with REPLACE or APPEND that are keys in an unopened index, then that index will not be synchronized with the table's data until you REINDEX.

dbMark

 

[tviman]

Mark makes an excellent point. It's always good practice, IMHO, to have any and all table indexes open whenever you're doing anything with the table - adding, deleting, editing. This way, the indexes will always be current.

There's always a better way. The fun is trying to find it!

 

[aa18ron]

Thanks dbMark. My mistake included:

set telephon to telephon.ndx instead of:

set index to telephon.ndx


and that would never have worked.

I appreciate your help.