Sort Paradox 5.0 Tables 
Author Message
 Sort Paradox 5.0 Tables

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.



Sat, 02 Jan 1999 03:00:00 GMT
 Sort Paradox 5.0 Tables

Quote:

> 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.

Hi!

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



Sat, 02 Jan 1999 03:00:00 GMT
 Sort Paradox 5.0 Tables


:
: 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



Sun, 03 Jan 1999 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Sorting in a form (Paradox 5.0)

2. Converting Paradox 4.5 tables to Paradox 5.0

3. PARADOX TABLE SORTING vs TABLE EDIT CONFLICT

4. Lost Record in Answer Table with running a query including two tables in Paradox 5.0

5. Paradox 3.5 Table sorting problem

6. Sorting a paradox table unusually....?

7. Sorting tables that contain MEMO fields (PARADOX 4.00)

8. Sorting a Paradox Table

9. Importing Paradox 3.5 tables into Access: error 3220 (sort order)

10. Sorting Paradox Tables Without Indices and Storing the Results

11. Sorting tables in Paradox 7

12. Sorting Paradox Tables With Indexed Primary Key Fields


 
Powered by phpBB® Forum Software