A Global Network of Organisations working in Human Rights and Sustainable
Development.You know you have the necessary training, knowledge and experience to make it work. The only limitations are the financial restrictions and the available equipment .... we want to give you some resources to overcome them !
A Global Network of Organisations working in Human Rights and Sustainable
Development.
Welcome to our DATABASE related resources ...
... Based on the resources provided on this page (and there is much more to come) we are convinced that educational institutions with only limited hardware or older equipment at hand can design useful curricula to teach their students the basics in this field.
dBASE / XBase related resources ( DOS based )
More dBASE related resources...
Clipper - all versions (from Summer 87 on)
DBMS systems (MS-Windows based)
CLARION for Windows
- our choice !
SQL resources
On this page we are listing - esp. for our target group(s) - tools, tips and tricks to learn the basics as far as "database management" is concerned. The programs listed here often originate from the late eighties and early nineties and most of them run also on equipment with very limited capacities ( XTs, 286, 386 machines ).
Please keep in mind : these tools are mainly intended for educational purposes; we have NOT tested any compliance with Y2K related issues ! But we have some tools on this page to help you to check this out (see also the next pages:
dBASE
Resources
dBASE books, manuals, tutorials etc.
The purpose of this page is to provide everyone with the chance to learn about "data processing", "database management" and what really matters to get some foundations in this field. Even the most sophisticated packages nowadays are all build on basics which can be learned from the tools we provide here.
Esp. schools and their teachers will appreciate these tools because it allows them to build up some useful curricula even when only modest hardware is available.
We try to obtain legal copies of older commercial software packages like dBASE III +, dBASE IV, Clipper Summer 87 edition and many more. We will keep you posted in this matter (we might be able to help you already now - please e-mail us with your specifc wishes).
See also our page: Software offered what is available and/or the latest entries in our Guest Book !
dBASE III plus / dBASE IV related resources ( DOS based )
We already have an offer for a fully licensed package of both versions (see our Software offered page)
And: we are in contact with the manufacturers of the newer dBASE
versions at: http://www.dbase2000.com
We will keep you posted
!
GREAT NEWS ! We have been in contact with the Chief Operating Officer of dBASE Inc. - Mr Duke Merhavy, PhD - and they are willing to consider our request on a case-by-case basis. In other words, they will consider a particular request for a particular project/cause/organisation where we would provide assistance to.
If your school is interested to teach database basics etc. in their curricula and we know what you need - probably also depending on your available hardware - then we can make together a plan about the project, what you need etc. and approach dBASE Inc.
You will not only find little helpers to support the mainstream packages, but also ...
- specific applications (mostly freeware/shareware working with dBASE
(.dbf) files, i.e. statistics, querying data etc.
- instructions how to repair damaged .dbf files
- zipped files with many resources related to dBASE which we have found
on the Internet:
- HTML pages with links to practical applications
- manuals and tutorials
to name just a few ...
We have used most of the applications listed here ourselves (and/or are still using them for specific purposes).
CARTE BLANCHE - a good tool to learn the basics (click to download)
Carte Blanche - an overview
Carte Blanche the Data Handler is a utility program for use with dBase III compatible DBF files. Carte Blanche will recognize and allow access to any dBase III DBF file, and provide the ability to modify, manipulate and create output from the DBF. Some of the more interesting features include a Query Interface, Form Letters, Labels , List Printer, Data Entry, Modify Structure , Intelligent Import , Global Search and Replace, Duplicate Finder, Frequency and Time Period Analysis.
We have incl. a sample file (donation.dbf) with the package to get you started !
"Software / program documentation" is one of the important tasks in an IT environment.
SNAP is an excellent tool to document dBASE, FoxPro and Clipper systems - download the file snap.zip, unzip it with pkunzip.exe and read the file snap.doc first (printout recommended).
Download
SNAP from here ...
An excellent learning
tool to learn the foundations and to document your dBASE application in
a professional manner !
Intelli-Trieve is a weighted retrieval utility for users of dBASE III, dBASE III+ (trademarks of Ashton-Tate), and compatible database managers. The weighted retrieval capability provided by Intelli-Trieve is a powerful and versatile tool that performs a very complex task easily - without programming.
Weighted retrieval has been available for years to users of powerful mainframe systems like IBM's CICS. Intelli-Trieve now brings this powerful concept to microcomputer users. Intelli-Trieve performs weighted retrieval by comparing each record in a database to user-defined selection criteria, and producing a copy of the database with the records arranged in descending order of 'acceptability'.
The result is an entirely new 'view' of your data, one that cannot be attained through standard indexing, filtering or sorting operations. Intelli-Trieve allows you to extract new and valuable information from your data in ways that were not considered in the original database design - without altering the structure of your databases.
Contains 2 courses:
- Basic design of databases with dBASE IV
- Advanced database design with dBASE IV
[ If you are interested to learn (or to teach) dBASE IV - there are already offers of licensed owners to provide their packages to someone who needs them. ]
An extensive SQL course (working with dBASE - .dbf - files). 140 pages of documentation is provided in this package. Very recommend (I have learned the basics of SQL myself with this package). Runs on very modest machines !
SSQL SPECIFICATIONS
Requires only one floppy diskette
Program only takes up about 122K
Minimum Memory 256K
Maximum number of columns 128
Maximum length of a row 500 bytes (characters)
Maximum number of rows:
It is limited by memory. With a 640K PC, the OUTPUT size
of the table cannot exceed about 400K. The tables on the disk can
be larger, you just could not display all the rows and columns at once.
Also, you could join multiple large tables as long as the resultant table
was not over 400K. This means that a table with rows 100 characters wide
could contain about 4,000 rows.
Maximum levels of subqueries 14
Maximum number of tables you can join 14
If you compare this with the "monster" applications
nowadays .... !?
Statistical Data Analysis package designed by professional statisticians
and researchers. Windows type pull-down menu
interface. Includes tutorials and help on "How to select the proper
procedure to use." Reads and writes dBASE III and IV files, can import
ASCII, comma delimited and 1-2-3 data files. Contains data analysis procedures
including descriptive statistics, t-tests, chi-square, analysis of variance,
simple and multiple regression, graphs, crosstabulations, non-parametric
procedures, life tables, survival analysis and more. Dr. Filefinder calls
it "The Ultimate in Statistics, no program I've seen beats WIKSTAT." PC
Week calls it the "Numbers Game Winner." Author John Sweeny says, "KWIKSTAT
is God's answer to SPSS. It's simple to use, fast, cheap and powerful."
Distributed and used in over 35 countries worldwide.
dbproapp.zip dBASE
application environment tool
More dBASE related resources (tutorials, tips, tricks, links etc.)
(to be continued)
We have an original CLIPPER Summer 87 package (incl. manual). Please contact us.
There are also many supporting tools available which we will upload
over time:
At SIMTEL you will find a huge collection with CLIPPER tools - not
only for the Summer 87 version, but also
later releases.
http://www.simtel.net/pub/msdos/clipper
MS-DOS / Clipper programming language
acc86.zip (CD) Clipper 86 library written in
ASM for speed
ahelp5.zip (CD) Help sys/Clipper 5.0 &
Summer '87 compiler app
ahp144.zip (CD) Advanced Help and Index library
for Clipper
asmall10.zip (CD) The Asmall Library 1.0 for
CA-Clipper 5.2x
bsclf4.zip (CD) CLF: Clipper source code reformatter
bslge2.zip (CD) Generates source code from
text file
bstitae0.zip (CD) Titanic: Can repair corrupt
DBF files
cgwrka10.zip (CD) Clipper lib for fast &
prototyping development
clip0189.zip (CD) Q & A concerning Clipper/FUNCky,
from BOSS BBS
clip0289.zip (CD) Q&A, Clipper for the
month of Feb 89, Boss BBS
clip0389.zip (CD) Msgs & Q&A from Clipper
Forum on The BOSS BBS
clip0489.zip (CD) Msgs & Q&A from Clipper
Forum on The BOSS BBS
clip0588.zip (CD) Q&A, Clipper for the
month of May 88, Boss BBS
clipfpcx.zip (CD) Library to display .PCX files
within Clipper
clipmous.zip (CD) A library for mouse support
under CLIPPER
clipwind.zip (CD) Windows for Clipper, no source,
but LIB & docs
clipwndw.zip (CD) A small CLIPPER window library
with source
clip_ng.zip (CD) Norton Guides Database to
Clipper Summer '87
clmous10.zip (CD) Mouse function library for
Clipper
cltab100.zip (CD) Align your Clipper (Summer/5.0)
programs
clut-2_5.zip (CD) Powerful replacement for
CA-Clipper DBU.EXE.
cl_clk10.zip (CD) Clock for Clipper 5.0, with
Clipper source
code_1.zip (CD) Sample source (template-like)
for Clipper
comm_io.zip (CD) Interrupt-driven com port
routines for Clipper
crlib100.zip (CD) The card library for Clipper
5.3
datetime.zip (CD) Set system date/time from
within Clipper w/src
dbm113.zip (CD) DBM v1.13: General (Clipper)
database manager
dbutil10.zip (CD) DataBase converter; dBase,
Clipper, Fox, Pdx
dctutor.zip (CD) Comprehensive tutorial system
for Clipper 5.0
dot231.zip (CD) Dot Command for Clipper (STD
Version)
facc10.zip (CD) Facade-C 1.0: Clipper splashscreen
display
ffdbg122.zip (CD) Find debug info in CA-CLIPPER
5.x .OBJs
funcky.zip (CD) Demo program written using
FUNCky for Clipper
grump14.zip (CD) GrumpFish Lib for Clipper
Summer '87 v1.40
hlpsy204.zip (CD) Easy Help System for Clipper
5 w/help topics
inhlp11.zip (CD) InHelp v1.1 for Clipper Help
programming
lw120.zip (CD) Lazywriter v1.20: Document clipper
projects
mcb2intl.zip (CD) English docs for mcbar22.zip
nannws12.zip (CD) Nantucket News v1n2, dBASE/Clipper
source code
nannws13.zip (CD) Nantucket News v1n3, dBASE/Clipper
source code
nannws14.zip (CD) Nantucket News v1n4, dBASE/Clipper
source code
nannws22.zip (CD) Nantucket News v2n2, dBASE/Clipper
source code
nannws23.zip (CD) Nantucket News v2n2, dBASE/Clipper
source code
nannws24.zip (CD) Nantucket News v2n4. dBASE/Clipper
source code
nannws31.zip (CD) Nantucket News v3n1, dBASE/Clipper
source code
nannws33.zip (CD) Nantucket News v3n3, dBASE/Clipper
source code
nannws34.zip (CD) Nantucket News v3n4, dBASE/Clipper
source code
nannws35.zip (CD) Nantucket News v3n5, dBASE/Clipper
source code
nannws36.zip (CD) Nantucket News v3n6, dBASE/Clipper
source code
nflib21.zip (CD) Nanforum Toolkit v2.1, docs/library/NG,
1/2
nfpat1.zip (CD) Patch#1 to Nantucket Forum
Lib 2.1 for Clipper
nfpat2.zip (CD) Patch#2 to Nantucket Forum
Lib 2.1 for Clipper
nfpat3.zip (CD) Patch#3 to Nantucket Forum
Lib 2.1 for Clipper
nfpat4.zip (CD) Patch#4 to Nantucket Forum
Lib 2.1 for Clipper
nfpat5.zip (CD) Patch#5 to Nantucket Forum
Lib 2.1 for Clipper
nfpat6.zip (CD) Patch#6 to Nantucket Forum
Lib 2.1 for Clipper
nfpat7.zip (CD) Patch#7 to Nantucket Forum
Lib 2.1 for Clipper
nfsrc21.zip (CD) Nanforum Toolkit v2.1, src
code/Make file, 2/2
nftroff.zip (CD) Nanforum Toolkit v2.0 Norton
Guides TROFF src
noclip41.zip (CD) Protects against disassembly
and decompilation
obj2s220.zip (CD) Link any data file with Clipper
programs
oclip.zip (CD) Free object oriented extension
for Clipper 5
rbarlb12.zip (CD) Clipper Library with Progress
Bar functions
rbcklb1d.zip (CD) Clipper library w/ Compressed
Backup functions
rcmplb31.zip (CD) Clipper file & string
compression library
rdot231.zip (CD) Dot Command for Clipper (RDD
Version)
regxsrch.zip (CD) Interface Clipper to GNU
regular expr. library
rfntlb11.zip (CD) Clipper Lib w/screen font
functions and editor
rlib20.zip (CD) Clipper menus/dialog/record-select
lib w/src
rpcxlb11.zip (CD) CA-Clipper library with graphic
functions
rshpcx13.zip (CD) Clipper lib to show PCX-files
on EGA/VGA/SVGA
savers10.zip (CD) Screen savers v1.0 for CA-Clipper
5.2x
secrit11.zip (CD) Security & demo by generating
key, Clipper5.X
segu33sp.zip (CD) Safety in Clipper5.x (Spanish
Version)
seguro33.zip (CD) Safety in Clipper5x(Hacker,umcompiler,install)
slsw.zip (CD) SUPER.LIB Shareware for Clipper
S87/Clipper5
smaker1.zip (CD) Visual screen maker for Clipper
& Lib
subntx2.zip (CD) Fast index extract/create
Clipper filter rtn
udfs.zip (CD) Useful functions for Clipper
(dBASE compiler)
vgatext.zip (CD) VGATEXT: Adds Special effects
in Text mode
viewer10.zip (CD) The Viewer Library v1.0 for
CA-Clipper 5.2
vsix302.zip (CD) Vern Six's Clipper Summer
'87 tookbox v3.02
vs_905.zip (CD) Vern Six's Clipper ToolBox
v9.05
workbase.zip (CD) Clipper/dBASE development/file
access system
With these resources it is possible - even with very modest older equipment - to build curricula which allow the students to progress. When using a Windows environment at a later stage then excellent foundations have been laid.
Database Management Systems
running under MS-Windows
We have an original SUPERBASE Version 2.0
package (incl. manual). Runs under Win 3.1, 3.11 - Please contact us.
We are using Clarion for Windows for our own developments.
We have an excellent evaluation edition of CLARION for Windows Version 1.5 available on CD ROM (we have learned CLARION with this one). The evaluation edition is excellent for teaching purposes (no time limits, however a limit of 100 records per file is imposed).
Requires: Win 3.11 or higher
There are several ways to get this one.
We might burn a copy of the CD on request and
mail it to the recipient - or:
we send the single files as e-mail attachments
to the recipient.
Please inquire if you are interested !
To get an overview we have for you 5 Brochures in .PDF format to download:
Broschure.pdf - an Overview
Origins.pdf - how it all developed
Pressrls.pdf - Press Release
Manufact.pdf - about Software Manufacturing
Vision.pdf - what the future might hold
If you have equipment fulfilling the minimum requirements - see file: Broschure.pdf - then we strongly recommend to consider CLARION as a teaching subject in the field of DBMS (Database Management Systems).
You can run the Development Environment on any system meeting the minimum
system requirements for Microsoft Windows
3.x, Microsoft Windows 95, or Microsoft WindowsNT 3.51. For better
performance, we suggest your system have at least 8MB RAM, 12 MB RAM, or
16 MB RAM for these respective operating systems.
You’ll also need between 8 and 20MB free hard disk space, depending on the Setup options you select.
The applications you develop will run comfortably on even those machines
meeting only the minimum requirements for these operating systems. The
applications are complete - however not suitable for sale because there
is a splash screen at the start of any application advising that this is
only an evaluation copy and then there is the limit of 100 records per
database file. However for teaching purposes it is an excellent tool.
SQL [ Structured Query language ]
Here we have many programs and resources for you, which we will add over time !
An extensive SQL course (working with dBASE - .dbf - files). 140 pages of documentation is provided in this package. Very recommend (I have learned the basics of SQL myself with this package). Runs on very modest machines !
SSQL SPECIFICATIONS
Requires only one floppy diskette
Program only takes up about 122K
Minimum Memory 256K
Maximum number of columns 128
Maximum length of a row 500 bytes (characters)
Maximum number of rows:
It is limited by memory. With a 640K PC, the OUTPUT size
of the table cannot exceed about 400K. The tables on the disk can
be larger, you just could not display all the rows and columns at once.
Also, you could join multiple large tables as long as the resultant table
was not over 400K. This means that a table with rows 100 characters wide
could contain about 4,000 rows.
Maximum levels of subqueries 14
Maximum number of tables you can join 14
If you compare this with the "monster" applications nowadays .... !?
( this part will be under permanent development )
Additional resources you will also find at:
www.knowwareglobal.com
www.customguide.com
We will add to this list over time - there is
of course much more to come !
( These pages are permanently under development
) Printer friendly !