Paradox 4.5 Error Message Interpretation 1

[jayhawker5]

Using Pdox 4.5 for DOS. Have tables with up to 48,000 records. Getting the following error msg:

"Unexpected condition: Table buffer (L11) for (table name).DB--leaving Paradox."

This msg comes when attempting to sort and also search. Thought at first I was at table max size but it happens on tables with only 5,000 records as well as 48,000. Can find no explanation for this in the 4.5 User's Guide.

Appreciate any help.

 

[ros]

It's been a while since I used PDOXDOS but I think this is means you have a corrupt table. Try using tUtility to rebuild the table. Should be a separate executable in your paradox directory.

Richie

 

[PhilUK]

I have had this message in the past, but not for a long time now, so can't remember the solution, but can offer a few ideas. Paradox has a physical limit of 128Mb. The largest table we have is 150,000 records, 38Mb and is okay. There is another 35,000 record, 15Mb table that is updated/inserted/deleted/searched regularly without problem, so this is not a size thing.

I would guess it is something structural. Check the settings for FILES= and BUFFERS= in the config.sys. Files must be atleast 40. I currenly have buffers = 40.

This may not be the solution, but there is something simple, if only I can remember it. Give this a go and let us know of any developments.

PhilUK

 

[jayhawker5]

Richie - Phil: Thanks for the tips. The Tutility tip did the trick! Took abt 30 seconds to repair the 50,000 records and I'm back in business. Thanks again. don rupert, fl

 

[majet]

Yes, the table has become corrupt. Often if you select restructure and do_it!, that will fix the table. Otherwise, you'll have to use tutility.

 

[Guest_imported]

About three years ago I completed the development of a Paradox 4.5 for DOS application. It has several tables with more than 300,000 records and it is running in a network with many users doing data entry and coedits at the same time (multiuse).

The Tutility.exe can fix damaged tables, but if the tables have too many columns the fix could be temporary and the error could reoccur (the table becoming corrupt once in a while several times a month). I read before in another forum that the Tutility has a bug that could make the table even more corrupt if it has too many columns (I do not remember how many colums, it was something like over 20). I would suggest that if it continues to becoming corrupt to spread the contents of the table into tables with less columns so that the Tutility could fix them correctly and them combine them into a blank brand new replica of the original table (created from scratch with Create->Table) or modifying the application so that it uses the tables that have less columns.

Other tip:
In the shortcut for Paradox you could put in the Command line (right click on the shortcut and click on the Program tabe) the following:

C:\PDOX45\PARADOX.EXE -extk 3096

The number of Stacks can be set at this command line also. I have the books if you need a specific information.

For additional help you can find me at:

http://www.keen.com/cesarinternational

César