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
shipped 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 temporarily.
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 sporadic 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.

.

Relevant Pages

  • Re: Changing dates
    ... Malcolm wrote: ... >below but I have recently upgraded from Paradox 8 to Paradox 9 and from ... The date field in Excel is formatted as dd/mm/yyyy, ... >same as my preferred Paradox format. ...
    (comp.databases.paradox)
  • Re: when do you outgrow access?
    ... using an access based system to take online applications for students who ... > Access to do the date conversion, rather than asking Paradox ... > immediate speed up by querying using a native Paradox format ...
    (microsoft.public.access.gettingstarted)
  • Re: INSERT statement problem with Paradox table
    ... and I am having problem with Paradox INSERT statement. ... tables structure in my project (to avoid space in the tables name and ... I am running the IINERT statement in the Borland Database Desktop as a ... Database Desktop have some problem and I thing I have to look for some ...
    (comp.databases.paradox)
  • Re: Basic questions about upgrading Delphi
    ... We've been used to using Paradox tables in Database Desktop. ... it is still included in Delphi packages and you can write DB ... What, basically, is the current method for installing program with ...
    (borland.public.delphi.non-technical)
  • Re: when do you outgrow access?
    ... I'm GUESSING that the date format in Paradox is different ... Access to do the date conversion, rather than asking Paradox ... immediate speed up by querying using a native Paradox format ... >>> Just wondering....IT department bags on access and pushes to change. ...
    (microsoft.public.access.gettingstarted)