Sponsored Links


  • 1. Concurrent access to dbase 7
    Writing a service in Delphi6 (using Indy 9.0.14) which checks for new email and sends pending email. Also connects to a bank server to get exchange rates. All of these write to the database which is dbase version 7 trough BDE (5.0.2). Sometimes I will get the error "format %p invalid or not comaptible with argument" when executing the first select in the threads. For example this: *** // get accounts information with DataMod.sqlAccount do begin if State <> dsInactive then Close; SQL.Clear; Unidirectional := true; SQL.Add('SELECT * FROM contas_ce'); Prepare; Open; if (State = dsInactive) OR (EOF) then Result := False else Result := True; end; { end with } *** I have a datamodule instance for each thread in a private variable. It contains a tdatabase and a tsession (and various tquery). Autosessionname is true. I have tried both handleshared true and false. when true error seems to be more frequent. Only stopping the service and starting can "solve" the error - it forces the recreation of threads and datamodules. Please give me some hints about this. The database is also accesses from the webserver (apache) for extranet and through an application internally.
  • 2. Data manipulation without BDE
    Howdy, I've got a wee app to write. Basically, I need to allow the user to pick a file (actually, a dbf table), and then run it through some filters until a text file is output with the distilled contents of the dbf. There's quite a lot of sql involved to remove duplicate records, sort the thing, adjust values etc. I would like to do this without distributing the bde. But, I need to create a lot of temp/intermediate tables in the meantime. An in-memory dataset would work if I could do sql on it... or temp tables created on the fly.. but I'm looking for a non-bde solution. Any thoughts? Regards, Laurie McIntosh
  • 3. TTabbedNotebook vs PageControl
    I want to have a DBGrid with which a user can choose to view different information based on clicking a tab from a notebook. One possibility is to use a pagecontrol and have a different grid on each page, along with its own TDatasource and TTable. Another idea I had was to use the same DBGrid component, and have it point to a different datasource depending upon the index value from a TTabbedNotebook. The idea is that with only one datasource component and one grid, it will be easier to keep track of the components being used and also it might take less memory since I would not have multiple grids in the application, it would just appear that way. Is that a good approach or are there problems with it? For example, if I point the datasource to a different table based on the index value of the notebook, does this increase the likelihood of the database crashing? Should connections, once made, not be broken in this manner? This might be a stupid set of questions, but after a 4-year layoff from Delphi, I'm a newbie again.
  • 4. Trouble Adding Columns to Paradox DB Table
    I need to add some columns to existing tables in Paradox databases running on remote sites. To accomplish this, I wrote a small Delphi application that logs into the database at each site and performs an "alter table " command to add the columns. In my testing, it appears to work just fine. From Database Explorer, I can see that the new columns exist in the tables. However, when I run a different Delphi application to try to populate the new columns with data using a TTable , I get an EDatabaseError with the message "Field Not Found". I'm stumped and would appreciate any suggestions. Thanks
  • 5. DBGrid number of rows
    Hello, I use DBGrid in Delphi 7 to display a mysql table. How can I get the number of rows in the grid? And how can I say I want a 3. filed in the 10. row? Thanks!

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 70 guest