delphi

    Sponsored Links

    Next

  • 1. SQL date range question
    I'm using Local SQL/Paradox with Delphi 7. I have a pretty simple query where i'm filtering the records by date and account #. Sql.Add('and gla_date >= '+QuotedStr(GetSQLDate(DateToStr(dtpFromDate.Date)))); Sql.Add('and gla_date <= '+QuotedStr(GetSQLDate(DateToStr(dtpToDate.Date)))); Sql.Add('and gla_accnt >= '+From_account.Text); Sql.Add('and gla_accnt <= '+To_account.Text); This returns everyhting within the date and account ranges. The problem is that I do not want records where gla_period=0 to be filtered by date, I want those results returned even if the date of those records is outside of the the date range. Is there any way this can be accomplished?
  • 2. Vista BDE/Paradox Problem solved
    The problem I was having opening Paradox files in Access 2007 were due to the fact that the (default) BDE NetDir (for PdoxUsers.Net) is C:\, which is a restricted location in Vista. And, BdeAdmin.exe was locking up when closing. (It may still be for all I know... I'm not using it!) Use RegEdit to change the key below to a folder to which you have full rights: HKEY_LOCAL_MACHINE\Software\Borland\Database Engine\Settings\Drivers\Paradox\Init\NetDir
  • 3. BDE/Paradox with Access 2007 Init problem
    Further details on our problem: We seem to be always able to *open* a table that was previously linked, but actually linking table for the first time usually generates the 11265 error.
  • 4.
    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?
  • 5. non visual database component
    Hi, I would like to create a command-line-based utility that accesses a table and displays it on the screen(command prompt screen); but as far as I can see, all of these DBTables components require a 'form'. Are there a set of non-visual components (probably library would be more appropriate) that I can use to make a command line utility. For this particular application, I don't need a UI. Thanks. Any information 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 30 guest