Note: if you are looking for technical support for dBASE, please visit:
Please do not email the owner of this or any other website requesting technical support, unless they have specifically given you permission to do so. (See also 'News' below ...)
The icons being used on this page refer to which version of dBASE:
July 19, 2016The dBASE Reports Book, 2nd Edition is now available for purchase. It should start to show up on all the Amazon channels soon (3-5 days), and other channels in a few weeks. If you don't want a printed copy, but are fine with a PDF version, you can purchase that as well. Please visit: The dBASE Reports Book, if interested in my other books, please visit:
April 6, 2016
The dUFLP has been updated to version '9C' ...
February 10, 2016
The folk at dBASE have released dBASE Plus 10.3 (and the runtime installer), you should upgrade if you have earlier versions of dBASE Plus 10. Details on bug fixes and any enhancements can be found here: Version Updates
In addition, yesterday they announced a new software package: MoveSQL™ -- which allows you to move your data from local tables to a SQL database. (I have not worked with this product and cannot speak to how well it works ...)
The site has taken on a new appearance -- a massive overhaul has occurred, as I have been learning to use new web tools. This site is now using Bootstrap (an open source web developer tool from Twitter), and frankly I rather like the way it looks ... A few things have been removed, or moved around. But I've been working hard to make sure the important parts are all still here.
August 31, 2015
Having received my proof copy of The dBASE Book Plus, and feeling like there's nothing I want to do to it to modify it at this point, I can now proudly announce it is available for order. It should start to show up on all the Amazon channels soon (3-5 days), and other channels in a few weeks. If you don't want a printed copy, but are fine with a PDF version, you can purchase that as well. Please visit: The dBASE Book Plus, if interested in my other books, please visit:
August 30, 2015
August 25, 2015
The dBASE Book Plus is nearly ready to go ... I am working with Amazon's CreateSpace folk, and hope to have more news soon.
July 21, 2015
So of course, the day after I post that a version of dBASE is in Beta testing phase, dBASE, LLC announces that dBASE Plus 10 is now available.
Unfortunately my book is not ready to go to press yet (there are several chapters not complete).
dBASE Plus 10.0 can be gotten here:
Of course, unless you are a tester you will need to pay for the upgrade. Many users will have received the email this morning describing some of the changes, many of which are quite exciting (some of which I've worked with for my book, a few of which I haven't gotten to yet).
July 20, 2015
Surprisingly, I'm back (sorta) ...
The good folk at dBASE, LLC have been quite busy, and dBASE Plus 9.51 is out (and has been for some time). It has some nifty new features, some new ActiveX controls (and the interface with ActiveX is better) and more. They are working (constantly) on new releases, there is a product in Beta that I can't say a lot about, but some cool things are happening there.
Hope to have an updated version of the dUFLP by the end of this week, and am slowly working on an update to The dBASE Book, tentatively titled The dBASE Book Plus -- it is not the full book, but an enhancement to the 3rd edition of The dBASE Book. It includes quite a bit on working with ADO (including three chapters dedicated to building an application with Firebird's SQL database engine), a lot of material on enhancements to dBASE Plus since the third edition came out, and so on. I will provide more details as we get closer to the release date.
April 16, 2013
The dBASE Book is now available for sale in its Third Edition. For details click the book cover image below:
The file is dUFLPPlus_9C.zip (dated April 6, 2016). This file is approximately 4.3MB in size. As always see the WHATS.NEW file for details on what has been changed, and use the form Library.wfm to find items you may be looking for.
Note: The previous version of the dUFLP for versions of dBASE prior to dBASE PLUS 8 is available here for a while, but it will eventually go away ... dUFLPPlus_AB.zip (dated June 20, 2014).
Important: If you are developing in dBASE Plus 2.8 and dBASE Plus 8, dBASE Plus 9, or dBASE Plus 10 (or any combination of these), you should have different folders for the dUFLP, one for dBASE Plus 2.8, one for dBASE Plus 9, etc. The reason is that once code is compiled in dBASE Plus 8, or dBASE Plus 9, the compiled version is not readable by dBASE Plus 2.8, and vice versa. It can be very irritating to run some code and suddenly find it isn't working because you had compiled something in the dUFLP under a different version of the software. Typical error is a warning about bytecode problems ...
Putting Your Code in the dUFLP Folder? I have seen a couple of developers post in the newsgroups that some code was available in the dUFLP when actually it wasn't. This is because they copied something from the newsgroups (or created something or ...) and placed it in the dUFLP folder. This is really a bad idea. With Source Code Aliases, you can just create your own custom library that gets used side-by-side with the dUFLP by putting that code in another folder, and setting up the Source Code Alias. Please do this to avoid confusion of what is in the library and what is not -- thanks!
New to the dUFLP? (This information is also in README.TXT in the library)
If you are new to the dUFLP, you need to know some basics, such as how to set things up, and get around in it. The following are the basics:
Create a folder on your hard drive, such as:
Run the file you downloaded (with a filename such as: dUFLPPLUS_U.zip), and extract the contents to the folder above.
Once you have done this, start dBASE and use the Navigator to point to that folder (use the "Look in:" combobox at the top of the Navigator).
NEW SETUP OPTION: Click on the "Programs" tab, and double-click on this file to create the Source Alias for the dUFLP:
(This program does the following:
OR, you can do this the hard way:
Once you have done that, after you start dBASE again, you may want to run the program (double-click on it):
so that when you decide to use some of the visual controls that are contained here, they will appear on the Component Palette of dBASE properly. (Note that this will not harm anything in your dBASE setup, it simply adds some information to a special table that is used by dBASE to know what icons to display for controls, and what tabs to place them on.)
Finally, to get a sense of what is contained in this library, you should change the tab in the Navigator to "Forms", and find the one called:
Double-click this file. This will run a form that shows you what is in the library, allows you to search the library, and even open the source code files in the Source Code Editor of dBASE.
dUFLP for Visual dBASE 5.5/5.6: LIW55B.ZIP (dated March 2, 1997). This is freeware code, with the only caveat being that the authors all request that you include the documentation that credits them. There will be no further updates to this version of the library. All focus as far as the dUFLP goes is on the 32-bit version (just like with the product itself ...).
SEQVALUE.CC: Romain sent me this at my request, as it is not in the dUFLP for 5.x. The file is SEQVALUE.CC used for handling autoincrementing fields in Visual dBASE 5.5 and later. This should work "as is", it's just the .CC itself. Download seqvalue.cc -- read the comments at the beginning of this custom class to understand how to use it.
NOTE: Some of this code is pretty old, and there are no guarantees that it will work properly in the current versions of dBASE Plus (8, 9, 10 ...). If you are interested, please feel free to download and examine, try it ... if it works, great. But consider this a disclaimer for all of it ...
Working with TeeChart and dBASE PLUS Updated Jan. 25, 2006
The file here: TeeChart_And_dBASE.zip is an HTML document with a bunch of screen shots and David Stone's article on working with TeeChart in dBASE PLUS. Hopefully there is enough information here to help you get started working with this flexible, powerful, and very confusing, ActiveX control.
Issues with Windows Vista™ and Windows 7™ are addressed here: dBase, LLC's Support Site
Data Execution Prevention (DEP) and dBASE PLUS
It seems that some newer machines and XP Professional have settings that affect this. The difficulty appears to be that if it is set to on in both the BIOS and the Operating System, dBASE PLUS no longer runs (however, it's not just dBASE -- apparently Microsoft Office 2003 also has the same problem ...).
Rich Muller posted on the dBASE newsgroups after testing: "You can add PLUS.exe and PLUSrun.exe as an exception in the configuration. You can also turn off DEP by setting a switch in the Boot.ini. Also application compatibility toolkit should help. http://support.microsoft.com/default.aspx?scid=kb;en-us;875352"
BDE "Insufficient disk space" Error Fix
The BDE in all releases earlier than 18.104.22.168 (the version that ships with dBASE PLUS 2x and later), 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.
Ken's Message Board 2.2
This is the second complete version of Ken's Message Board, nearly a year after the first (life's been crazy) -- with a few major changes in 2003. Updates include: encoding username when passing it by a link, which resolves issues with spaces in the username; dynamic external objects; ability to specify whether to allow profanity (and to specify what words are considered profane); ability to keep a user from posting destructive scripts as part of the text of a message; minor cleanup here and there. If you have an existing version, you will will want to run all three of the MAKE programs. After downloading it, unzipping to a folder, check out "readme.htm" for details on how to use it, set it up, etc. KenMessageBoard2_2.zip -- June 25, 2003.
A Wrapper for the MessageServer
Updates/wrapper for the MessageServer application provided as sample code in Visual dBASE 7.5 -- this gives a bit of functionality to the sample application, including allowing you to set your own table, and create fieldlists, or templates (mail-merge messages). MailServerWrapper.zip -- February 15, 2000. Check the README.TXT file contained in the .ZIP for details ... and the header code in the .CC for more details.
A Message Server using FUNCky 6.0 and Visual dBASE 7.5
This is similar to above, but it uses the FUNCky 6.0 (this is what is on your CD for dBASE -- versions 7.5 through dBASE PLUS) for Visual dBASE provided by Dirk Lesko -- note that you MUST have FUNCky 6.0 for this to work. FUNCkyMailServerWrapper.zip. February 16, 2000. Check the README.HTM file contained in the .ZIP for details ... and the header code in the kmFUNCkyMailServerWrapper.prg for more details. (This should work with later versions of dBASE ...)
PLEASE NOTE: The website for FUNCky has disappeared, I assume this means little or no support, and I cannot guarantee that this code will work in current versions of dBASE Plus (8, 9, 10 ...). There are other solutions available, and with dBASE Plus 9 and later, dBASE ships with some of the Catalyst Socket Tools activex controls, which will provide some of what FUNCky did.
This version of Vesper is even more of an overhaul than the previous versions. Vesper9_03.zip This one was modified based on needs of the current Vesper, some items were removed (subscription data, for example, as the heralds are putting the monthly minutes up on the web now), and others were added (heraldic certifications ...). This uses a few features of dBASE PLUS (mostly new form properties), and also does some limited web stuff (the website used by the heralds is run off a Linux server, and hence the software only generates a few static web pages, not a fully interactive web-based package). See the README.TXT file for, among other things, a description of the folder structure needed for the application. All source code is documented as usual. Some minor bug fixes from earlier versions have been added. Last updated: March 14, 2006
Project Explorer Updates, dBASE PLUS 2.8
The developers at dBASE were working on fixes for the Project Explorer when the decision to focus exclusively on dBASE PLUS 8 came down the pipeline.
I was given some of these changes and updates (included in dBASE PLUS 8, but not in dBASE PLUS 2.8) and have been granted permission by the CEO (Mike Rozlog) to make them available to the dBASE community. Note that these should only be applied in dBASE PLUS 2.8. This means that you should not make these changes for dBASE Plus 2.7 (or earlier), or for dBASE Plus 8.
To use these, download the .ZIP file, read the information in "Changes.rtf", and unzip the files to the appropriate locations.
Project Explorer for dBASE PLUS 2.8 Updates (April, 2013)
This is a list of websites you might find useful, they all deal with dBASE in some fashion or another. If you have a site that you feel belongs here, please click on the "Contact Ken" link at the top of the page, and let me know ...
dBASE Advisor Articles by Ken Mayer
A set of articles written by Ken Mayer during the time the magazine The dBASE Advisor existed. If nothing else it is sort of a blast from the past, showing where we've come from to the current versions of dBASE. The articles are just the ones I wrote, I don't have permission to publish the others (and frankly probably not enough space on my web server for everything). These are all PDF files:
Michael Nuwer's Tutorials:
These are the tutorials that I started, but Michael really polished and enhanced to make them more useful:
dBulletin -- dBASE Newsletter With Lots of Code Samples:
This is available from various websites around the World:http://www.jpmartel.com/bulletin.htm
It should be noted that the newsletter hit its final issue (#21) due to a lack of articles being written, and because the main editor (J.P. Martel) just doesn't really have the time to put into it anymore.
Ronnie MacGregor's dBASE Page
Ronnie has some utilities that are worth checking out: http://www.dbasedeveloper.co.uk/. If you've never worked with Ronnie, he's extremely helpful and giving, but he's also very busy ... so if he doesn't answer immediately, don't give up ...
Marc van den Berghen
Mark has some interesting code available, some for free, some not: VdB-Logic
dBASE Web Application Resources
David Ball has posted a website with resources to help you work with dBASE on the web at: http://www.chelseadata.ca/ChelseaData/resources.php.