Could someone tell me how to sort a Paradox 5.0 table with a Delphi
1.0 program?  I discovered one method while reading this newsgroup,
but I'm not sure that it does what I want --

        Use TQuery w/ the SELECT ... ORDER BY Sql statement
        Use TBatchMove to create a new Table
        Delete the "original.db" and rename "new.db" to "original.db"

Paradox has three files for one table (.db, .px, .val) -- I'm not really
sure what each is for (I looked them up, but I don't really know much
about databases....).  It seems that I am only updating the ".db" file
because when I try to open the table again, I get a message the ".val"
is out of date.

What is the best way to sort a table?  Is there an SQL statement
to do it??  Any help is appreciated .....

Ryan Williams
--
....................................................................

Philippians 2:11  ...and that every tongue should confess that Jesus
                    Christ is Lord, to the glory of God the Father.

The .VAL-File is file, in which the optical apperance (example in the
database desktop) are stored.

If you get an "Out of date"-Message simple delete the *.VAL files.

I haven't detect any problems, beside the lost of the optical apperance
in the database desktop.

Have fun!

Robert

:
: Could someone tell me how to sort a Paradox 5.0 table with a Delphi
: 1.0 program?  I discovered one method while reading this newsgroup,
: but I'm not sure that it does what I want --
:
:       Use TQuery w/ the SELECT ... ORDER BY Sql statement
:       Use TBatchMove to create a new Table
:       Delete the "original.db" and rename "new.db" to "original.db"
:
: Paradox has three files for one table (.db, .px, .val) -- I'm not really
: sure what each is for (I looked them up, but I don't really know much

Hello Ryan,

.db  is data file
.px  is primary index file
.val is validity checks file (default values, referencial integrity,.. )
.x* and .y* are for secondary indexes
.mb(or .dm or ?) is memo file
any more?

: about databases....).  It seems that I am only updating the ".db" file
: because when I try to open the table again, I get a message the ".val"
: is out of date.

you are right, only copying .db will cause .val and .db to be not
syncronized.

: What is the best way to sort a table?  Is there an SQL statement
: to do it??  Any help is appreciated .....

why you want to sort the table? better way is to create Maintained
secondary index on these fields to get ordered data. And then use TTable's
IndexName to switch to this index. Note, that for maintained secondary
index one needs also primary index (what you seem to have - .px file)

Tanel