dbase 3 plus

[Guest_imported]

hai,i am usning dbase 3 plus.in that i am modifying one payroll project.in that i am getting two problems.
1.i modified structure of master database.so many indexs are there based on that master table.i read that we have to reindex.but i don't know how to use reindex.
2.when i am running screens as chain it is stucking up.
please help me.
thanks in advance.

 

[MiggyD]

This will work in db3+ .

* --- Starts here ---
USE MyData.dbf INDEX indx1, indx2, indx3 (etc...)
* {your section of add/delete/edit code here}
PACK
* --- Ends here ---

In db3+ if you pack an opened file that is index it should automatically reindexs ALL index files...This may be the answer you're looking for.

Just remember that packing will erase all records marked for deletion. So, make sure this option is what you want to do before hand.

--MiggyD It's better to have two heads to solve a problem from different angles than to have tunnel vision to a dead end.

 

[hrnichols]

Rather than pack, just use the "REINDEX" command that is found in DB3+. This will avoid the potentially dangerous "PACK" command.
I always reserve the "PACK" command for a programmed response to ensure that the only records lost are records for which I have no further need.