Ken's dBASE Page
Updated: August 30, 2015
Note: dBASE Webring links at bottom of page ...
Number of unique hits:
Note: if you are looking for technical support for dBASE, please visit:
Visual dBASE 7.5 Tutorial? Please note that the tutorial in question was written many years ago, and while helpful, was not as good as it could have been. There is an updated tutorial available at the dataBI website (noted above), go to the "Knowledgebase" link. The associated source code for the original tutorial has long since been deleted from this website and is no longer available. This should also be available from the dataBI website. In addition, see the links noted below -- Michael Nuwer has many updates and additions to the tutorial that are not on the dataBI website.
Michael Nuwer's dBASE Tutorials.
As this page has been expanding ... I felt it useful to throw together a small menu (at the top of the page). Hope it helps.
The icons being used on this page refer to which version of dBASE:
for Visual dBASE 5.5, 5.6 and 5.7
for Visual dBASE 7.0, 7.01 and 7.5
for dB2K (image by Gary White, used with permission)
for dBASE PLUS
for dBASE PLUS 2.5, 2.6, 2.7
for dBASE PLUS 2.8
for dBASE PLUS 8
for dBASE PLUS 9
for dBASE PLUS 10
NEWSAugust 30, 2015
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:
dBASE Plus Updates Page
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).
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.
Back to the Menu
Sample Source Code (Visual dBASE 7.x, dB2K, dBASE PLUS)
Issues with Windows Vista™ and Windows 7™ are addressed in two places: dBase, LLC's Support Site and dBASE PLUS and Windows Vista™ (the information on the dBase, LLC site is more accurate and more up-to-date).
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"
dBL/dBASE Open Source Projects
These are at another site, and are really in their infancy. As of September, 2005, they have pretty much not been updated for a year. Hopefully some interest will come back and these will start being worked on again. This is not an easy task, as each of these needs to be flexible, and able to be incorporated into other projects. Anyway, for details on what's happening with these:
BDE "Insufficient disk space" Error Fix
The BDE in all releases earlier than 18.104.22.168 (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.
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 ...)
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)
Back to the Menu
The dBASE Users' Function Library Project (dUFLP)
dUFLP for dBASE PLUS, version 9B
The file is dUFLPPlus_9B.zip (dated August 30, 2015). This file is approximately 4.1MB 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 -- this was changed back to a .zip file due to concerns by people of virii and all that ...)
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.
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!
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 ...).
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.
Back to the Menu
dBASE Advisor Articles by Ken Mayer
dBASE Advisor Articles
Michael Nuwer's Tutorials:
dBASE Online Training (the main page)
A copy of Michael's tutorials can be found at:
dBASE Online Training
This was done because there have been some issues with the server that Michael's tutorial normally resides on.
dBulletin -- dBASE Newsletter With Lots of Code Samples:
This is available from various websites around the World:
It should be noted that the newsletter has 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.
Marc van den Berghen
Mark has some interesting code available, some for free, some not. The code includes a wheelmouse dll that allows your wheel mouse to work with some of the UI controls and more ...: 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.
Others -- see the WebRing link at the bottom of the page ...
Back to the Menu
Visual dBASE 5.x Resources
Migrating from dBASE IV to Visual dBASE 5.x
Ok, I took an older (1995) Borland Conference paper I wrote and converted it to HTML, and tinkered a VERY small amount. This paper, when unzipped, is an HTML document with a bunch of images ... If you want some help converting your dBASE IV applications over to Visual dBASE 5.x (note that this paper does not cover Visual dBASE 7 -- that's a whole 'nother thing completely). To download the paper, click on the link here: migrate2vdbase.zip.
The Knowledgebase at the dataBased Intelligence website no longer includes the 5.x How To documents. Luckily Bowen Moursund has them available on his website at: http://www.bmmnet.us/Downloads/how.zip.
Back to the Menu
The dBASE Webring
Back to the Menu
Golden Stag website (Ken's personal website)