delphi

    Sponsored Links

    Next

  • 1. catching Blob errors
    Hi, I have a foxpro table that contains memo fields, of which I use only one. I'm using BDS2006 and using an ODBC as the driver to access this foxpro table. having set the TDatabase and TQuery instances correctly, and while generating a report from the information given in the table, I always come across this error: "Project myproj.exe raised exception class EDBEngineError with message 'Invalid BLOB handle in record buffer.'. I added some debug statements and I believe I came across one particular entry that the program seems to be choking on. Going to another workstation that does have Foxpro, I look up that particular and check out that memo field. So far, I can't seem to find any fault in that memo field as the contents seems very 'well formed'. No gibberish. No Foxpro crashes. There is a string in that memo field. I'm completely flummoxed as to how to solve this issue because from the inspection at the time of the debugging process, I discovered that the query's field that represents that memo field is empty/null. Can anyone suggest a possible way of solving this issue? Thanks Ed
  • 2. How to dynamically create TDatabase to point to a directory?
    I'm trying to create a TDatabase at run time and point it to a subdirectory but every time I open it, it complains "Unknown database. Alias: db1". I'm not trying to use an alias, I just want to point it to an existing directory. What's wrong with this code? Database := TDatabase.Create(Self); with Database do begin Connected := false; DatabaseName := 'db1'; Name := 'Database1'; Params.Clear; Params.Values['PATH'] := ExtractFilePath (Application.ExeName)+'Data'; Open; end; TIA Sam
  • 3. DBF Open table under BDE - memory issue?
    Hi - I have an app written in Delphi 5 using Dbase tables via the BDE. The app has 18 tables opened with 22 indices. On my own machine which has only 256 MB Ram I can open at least 10 instances of the app at the same time. I have other users that I assume are also opening multiple instances up to 4 or 5. But I now have a user who in spite of having 1Gig Ram - when she opens the 4th instance gets an 'Index not found error' on the opening of the 16th or so table of the 18. If the same data is opened as the 3rd instance of the app there is no error. Likewise if a different data set is opened as the 4th instance the error is back. This error causes the app to think it needs to reindex which is does but after that it will generally get 'Insufficient memory for this operation..' errors. I have looked at the the BDE Init settings and thought of increasing eg MAXFILEHANDLES but it makes no sense that I can easily run 10 instances ie 40 file handles x 10 = 400 with this setting on 48. The machine is running WinXP pro. I am out of ideas - any insights will be gratefully received. Thankyou - Jenny
  • 4. ExecSQL and Select statements
    Hi, I'm using BDS2006. I am having trouble with the ExecSQL statement and looked it up in the help. I came across the 'solution' to my problem; however, I'm not entirely sure how to proceed. Basically, I have a query component which accesses a BDE table. Setting the query's sql text property to 'select * from mytable' and then running myquery.ExecSQL doesn't work. As stated in the help file, I should use the Open() method instead of the ExecSQL method for "Select" statements. The problem is the Open() method belongs to the TSession class. How exactly do I use the TSession class? I place that component on my form, and then I set the sessionname? This produces a 'duplicate session name' error. Not setting it gives me a 'no session name' error. However, the help file assumes that I use a TDatabase component, which I don't. My TQuery instance accesses the database table directly (by setting the databasename and using the sql.text property). Any pointers appreciated. Edmund

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?



Re:

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




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

-- 
Bill Todd (TeamB)

Re:

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
 XXXX@XXXXX.COM 
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" (www.goldenstag.net/dbase/#Source)...
has anyone used this fix and care to comment?

BDE "Insufficient disk space" Error Fix
The BDE in all releases earlier than 5.2.0.2 (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
BDE4GigFix.zip 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
file.



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:
 http://www.**--****.com/ 

Rick Carter
 XXXX@XXXXX.COM 
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..






that
"patch"
the




Return to delphi

 

Who is online

Users browsing this forum: No registered users and 81 guest