Re: Query fails to retrieve data

Tony, thanks for the reply. I am not sure if it is Paradox application or
table format only. I got it with Borland Delphi and has Database Desktop
****pped along with it. I am connecting to the tables through the BDE
engine.

I know Pack Table does not do anything significant. The point is that
doing
anything to restructure the table in any way solves the problem
tem****arily.
I had been using a block size of 2K. Maybe I can try 16K. But its result
may
not be known immediately because the issue is s****adic in nature. It is
only
some transactions that seem to be showing this kind of behaviour. So once
I
do this change, I shall have to wait a few days to see if any users are
still
posting this issue. 

In the meanwhile, can you please tell me what block size really does and
how
it would help increasing it? All that I know is that it is the amount of
disk
space reserved for a record of a table. Also I can tell you that we had
made
a recent release that added a few columns to this table and its only after
this release we started facing this problem.