🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.lang.pascal.delphi.databases
Article #72

Re: D1: Table Is Full Error Question...

#72
From: Mike Bandor
Date: Sun, 17 Jan 1999 00:00
62 lines
2669 bytes
Richard,

	I tried increasing the block size to 4096 and creating a new
table.  I then copied the data to the new table and started using it,
but I still have the same problem.  Any other ideas?

D1.02, Win3.1, Paradox 5.0 table.

Original posting data:


DB Structure:

NAME		TYPE	SIZE
ENTRY_NBR	+	
TERM		A		75
MEANING		A		254
EXPANDED	L
E_MEANING	M		1
COUNTRY		A		50
BRANCH		A		25
NEW			L
ASOFDATE	D
VERSION		N
REMARKS		A		200

I have looked up TI2751 and I don't seem to be at the limits according
to the information it provides.  The total file sizes add up to
230,834,502 (much less than the 256Mb limit).  And I have
approximately 800Mb of free disk space available as well.  Is there
something I'm not looking at, or can I make a change somewhere to
increase the number of records in the table?


Mike


carterrk@news.ececs.uc.edu (Richard Carter) wrote:

>Sounds like what you need to do is change the block size
>of the table.  This has been discussed frequently in this
>group, so you could search for old postings on the subject
>at http://www.dejanews.com/
>--
>============================================================
>Rick Carter   carterrk@email.uc.edu   rcarter@tso.cin.ix.net
>============================================================

------------------------------------------------------
- Mike Bandor  (bandorm@vitrex.net)
- Software Engineer:    Delphi/Ada/C++/Java/Win3.1/
-                       Win95/Winhelp/JOVIAL/MASM/HTML 
-				
- "Trying to manage programmers	
-  is like trying to herd cats!"		
- 
- Speaking for myself!  Standard disclaimer applies.
------------------------------------------------------
- Author of MEGATERMS:  Military Terms and Acronyms
- http://www.vitrex.net/~bandorm/megaterm/megaterm.htm
- ftp://vitrex.net/usr/b/bandorm/m-term.zip
------------------------------------------------------
Technical Details
Message-ID: <36a27026.2798978@news.vitrex.net>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail
References: <3699147c.3703977@news.vitrex.net> <77btai$h4a$1@news.ececs.uc.edu>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ffff5,eb9b8f7e6eeaafab
X-Google-Attributes: gidffff5,public
X-Google-Thread: ff75c,2e7b01b76c3c38b1,start
X-Google-Attributes: gidff75c,public
From: bandorm@vitrex.net (Mike Bandor)
Subject: Re: D1: Table Is Full Error Question...
Date: 1999/01/17
Message-ID: <36a27026.2798978@news.vitrex.net>
X-Deja-AN: 433787444
References: <3699147c.3703977@news.vitrex.net> <77btai$h4a$1@news.ececs.uc.edu>
X-Complaints-To: abuse@xmission.com
X-Trace: news.xmission.com 916615254 14319 206.71.67.113 (17 Jan 1999 23:20:54 GMT)
Organization: Vitrex Networking (ISP)
NNTP-Posting-Date: 17 Jan 1999 23:20:54 GMT
Newsgroups: comp.lang.pascal.delphi.databases,borland.public.delphi.database.desktop