delphi

    Sponsored Links

    Next

  • 1. filtering advice
    Hi, I am attempting to use BDE's TQuery to filter a few tables (Foxpro tables, connected via BDE<->ODBC). (Using D7, btw). The tables have about 40k rows and doing the following produces a long wait time. query1.databasename := 'testdata'; query1.sql.clear; query1.sql.text := 'select * from stocktab where lotno=:plot'; query1.parambyname('plot').asstring := '032223'; query1.active := true; query2.databasename := 'testdata'; query2.sql.clear; query2.sql.text := 'select * from addrtab where nfo=:pfo'; query2.parambyname('pfo').asstring := query1.fieldbyname('ano').asstring; query2.active := true; The above took about 1/2 minute to accomplish. Does anyone have a better idea in filtering Foxpro data? Thanks Edmund
  • 2. accessing serial port
    Hello, I'm trying to write a test program to retrieve data from a weigh indicator attached to my serial port. I'm using Asynch Pro component and was wondering if someone have some sample code for me to review. I'm trying to read weight and store into a SQL database. I'm using D7 and ADO with Asynch Pro. If you have a better approach or compoenent, please let me know. Thanks in Advance
  • 3. smart refresh?
    I am using a ttable with lots of records in a grid. About one record is being added per minute, by another application. It's a local file only accessed by two programs... one that adds records, and one that displays them in a grid. This architecture is dictacted by the legacy software environment. I want to keep the data aware grid updated, but without re-reading the whole table each time. Is there some intelligent refresh function I can use with TDataSet, TTable, TDBGrid? Or if I have to code it, where would I start? Thanks, leshalles
  • 4. Limit TMenu lines
    Hi i would like to limit the TMenu to 5 lines only as the TTable fields, how can i do that 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?



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