Sponsored Links


  • 1. Slow start
    Using D7, Paradox, and LAN with WinXPP and Win2k While I used only ttable on my program it loaded quickly on each computer on the LAN. I rewrote much of the program using Query (SQL), and it takes several minutes to load. Could the presense of the SQL statements have anything to do with this? Thanks, David
  • 2. Slow SQL
    D7, winxpp and win2000 on a LAN. Several weeks ago I had questioned how slow my SQL statements were using Paradox. One of Team B recommended perhaps trying advantage database. I did using the local advantage database and nothing improved. Is it perhaps the nature of SQL to be this slow? Here is a sample of the slow code. I wrote a separate program just with this to see if other extraneous problems could be occuring in the full program, but it remained so slow. procedure TForm1.NameKeyUp(Sender: TObject; var Key: Word; Shift: TShiftState); Var Name1 : string; begin Name1:=uppercase(Name.Text); adsquery1.Params[0].AsString:=Name1+'%'; adsquery1.Open; end; It uses an edit control named Name. The SQL statement to execute is select * from pt where ptname like :1 order by ptname; Also, ever since I converted much of the code to SQL the programs take much longer to load. Thanks, David
  • 3. Cannot see the decimal value
    Hi, I am using DataBase DeskTop Version 7. I created a table using dBase IV. I have a few field that is suppose to store a decimal number but however I cannot see the actual value. Rather what I can see is only a round off integer value. I declare the field as Num(10,4). The value if extracted using a program is correct. If I open the dbf using another computer, there's no such problem too. How can I change the setting so that I can see the decimal value? Thanks. Alfred
  • 4. table is full error
    Pdox 7, delphi 5, When I try to append record of a table is gives "Table is Full" message. Any Idea Kadir
  • 5. HELP: TClientDataset and SaveToFile ...
    hi, I developed a simple client/server application using Delphi 7 professional and firebird. On the client side I used a Tclientdataset componet. - when there the connection to the central DB is avaiable, thought a provider, the client syncronizes itself with the central DB. Then it saves the needed informations into a file (i used savetofile method of Tclientdataset). - when there is no connection, the clientDataset is linked to the file avaiable locally. In a first moment I thought It worked fine but, afetr a few days, i got an intermittant problem. Sometimes the saveToFile method generates a file of 0 kb and when i try to perform a local connection, i obtain the following error: "missing data provider or data packet". So, i know the problem is linked to the savetofile method of Tclientdataset component, but i have no idea of what to do. Can anybody help me ? Thanks in advance for your interest.

Re: Re:

Postby Frank Marousek » Sat, 30 Dec 2006 01:04:33 GMT

I had no idea it was a common problem, but I'm certainly glad to hear that
it is.

May I bother you to instruct me as to how one goes about searching the
newsgroup archives?


Postby Bill Todd » Sat, 30 Dec 2006 01:24:52 GMT

Go to  http://www.**--****.com/ 

Bill Todd (TeamB)


Postby Rick Carter » Sat, 30 Dec 2006 01:48:07 GMT

This is a known problem, and has been discussed much in threads in this
forum, in borland.public.bde, and in other forums.  Search the newsgroup
archives for "insufficient disk space" or "4G limit" and you'll find
plenty.  There are also suggested work-arounds, and I think one is
a download available from Code Central.

Rick Carter
Chair, Delphi/Paradox SIG, Cincinnati PC Users Group

--- posted by geoForum on  http://www.**--****.com/ 

Re: Re:

Postby Frank Marousek » Sat, 30 Dec 2006 02:14:55 GMT

Thank you Bill and Rick.

I found this on "Rick's dBase page" (
has anyone used this fix and care to comment?

BDE "Insufficient disk space" Error Fix
The BDE in all releases earlier than (the version that ships with
dBASE Plus 2.5 and later) and later releases one assumes, has an error that
can occur if you or your users have free disk space on the hard drive that
is an exact increment of 4 gigabytes (i.e., 4, 8, 12, 16 ...). The file includes the .DLL file that solves this issue (it's a "patch"
for the BDE), and also a small program that will load it. Details are in the
file "BDEFix.prg" contained in the .zip file. Note that if you have dBASE
Plus 2.5 or later, this should not be an issue, and you do not need this

Re: Re:

Postby Rick Carter » Sat, 30 Dec 2006 02:17:38 GMT

>May I bother you to instruct me as to how one goes about searching the

Start with the links here:

Rick Carter
Chair, Delphi/Paradox SIG, Cincinnati PC Users Group

--- posted by geoForum on  http://www.**--****.com/ 

Re: Re:

Postby Roon » Mon, 01 Jan 2007 11:18:58 GMT

I ran into the problem on occasion and just copied some file to the drive to
change the size of the free disk space.  It happened so infrequently, that
the biggest issue I had was to remember what to do when it happened..


Return to delphi


Who is online

Users browsing this forum: No registered users and 12 guest