Elements of Computation for IES -Dbase-III
DBASEIII COMMANDS -Notes Database Organization: SORT, INDEX SORT Command · The SORT command gives us the ability to copy the record and structure of a database to another database. · Files can be arranged in either ascending order or descending order by using SORT command. · Sort command can be used in multiple fields for data arrangement. · SORT command creates a new database file. But the new file contains records of the original database file only the order is different. INDEX command · Index command can also be used to organize a data file. When you index a database, you ask dBASE to create a separate and smaller file based upon designated fields in the database. · The index command does not create a new database file. It creates an index file for the database with a default extension ( . NDX). · Unlike SORT command however INDEX does not permit the user to arrange the data in descending order DIFFERENCE BETWEEN SORT AND INDEX COMM