Re: Primary keys don't work?

If you are only selecting the column which is the PK, then the result could be fetched purely by doing an index read, hence it will be sorted. However, as the other reader said, the records in the table will not be sorted in the order of the PK. Try using an order by or ensure that you use the PK whilst doing your select. Received on Thu Sep 20 2001 - 02:16:04 CDT