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: Linking Paradox X3 to MS Excel 2007
    ... my best guess is that your new Jet settings are different from the old ones, if the Paradox stuff didn't change.. ... Paradox Sales and Support ... Just recently, I had to upgrade my version of Office at work from 2003 to 2007, and since then I've had nothing but trouble with a few graphs I'd made in 2003. ... However, on a few of these now, I've been getting the error message "External table is not in the expected format." ...
    (comp.databases.paradox)
  • 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)