 |
RDA's
|
We also maintain an opt-in mailing list for RDA updates. We do not provide this list to anyone else. If you wish to be included mail to: RDAmail@RDAWorldWide.Com
Help Support this Site
We are now maintaining a set of links
which are recommended resources you may wish to investigate. These sites pay a
small commission to RDA if you purchase from them after clicking through these
links. We will attempt to test all these links and services both for quality of
service and reasonableness of price. So, if you need any of these products or
services anyway, why not try accessing them through us and help support the
free content and services we provide such as our freeware and our Paradox
resources page? Any feedback on these sites is also welcome. Please use the
contact page or the e-mail address at the bottom of this page for feedback.
About RDA and Corel
Paradox®
RDA is a company that provides a variety of
tools and services. One of our primary areas of expertise is database
development in Paradox. In addition to being a registered Corel Paradox
Developer Solution Partner RDA is also a 3rd party developer for Paradox. Below
is some information about our products and services. We hope you will take some
time to check out the rest of our web site and that you will find our products
useful. We also hope you find the rest of the info and the links provided here
to be a valuable resource.
Click these links to jump
to documents, code
samples, freeware, or shareware
RDA's Products
Security Guard is a tool for
Corel Paradox® developers and users who want to manage table and field
level security without giving users actual table and field level passwords.
This improves security and eliminates the need to restructure tables to modify
system security. Security Guard can be used with interactive Paradox sessions,
can be built in to your applications or can be used with your Paradox Internet
applications. Security Guard is currently available for Corel Paradox®
versions 5 to 10.Return to Top
RDA's BubbleHelp for Corel
Paradox® adds pop up help to buttons, fields and other objects. It is
simple to use and you can essentially put in any amount of text in a BubbleHelp
message. Because you create your own help message text BubbleHelp works in any
language! Return to Top
RDA's AutoReplicator is a tool
for Corel Paradox® developers who want to manage remotely running copies of
their applications by updating them from a master code source. AutoReplicator
manages the copying of components from the master to the local copy. As a
developer you can implement it by adding as little as 3 lines of code and a
variable to your application! The time saved on application management and
updates should pay for the product on the first update. Return
to Top
AutoArchive, a
tool for creating record archives, audit trails and undelete functions and
deploying that functionality in your applications. It also provides an archive
cleanup utility which helps you delete archives or delete records from archives
which are older than a specific date. AutoArchive allows you to plug in
functions to your application which will capture changes in your database at
various levels of granularity. You determine the granularity level from field
level changes to just record changes that are actually posted. You can also
chose to have the archive records date and time stamped or date, time and user
name stamped. Archives are created as records are changed giving you the
ability to restore records by copying them back out of archives or to maintain
full audit trails simply by keeping the archives. There is also a
demonstration application available
in the AutoArchive deluxe version or separately.Return to
Top
AutoKey a tool for
creating and deploying automatically incrementing integer keys for Corel
Paradox® tables. Paradox's autoincrement field type present potential
problems when used as keys, and should not be used for that purpose because of
these problems. These include the loss of data links or incorrect links created
when autoincrement fields are resequenced in a table rebuild and the
replacement of these fields' values in table adds. AutoKey presents you with an
easy to use and implement alternative. AutoKey has two modes: Administration
and Deployment. Administration helps you set up the automated key function for
your applications. The deployment mode consists of the library and calls to
methods in the library as well as the table which manages the automatic key
incrementation. There is also a demonstration application available in
the AutoKey deluxe version or separately.
Our Security Guard is
currently available for Corel Paradox® versions 5, 7-16, 7-32 bit, 8, 9 and
10. AutoReplicator and AutoArchive are currently available for Versions 7-32
bit through 10. BubbleHelp and AutoKey are also available for Paradox 7-32
through 10 and Paradox for Linux. We continue to add tools so check out site
for new tools which may not be listed here. Return to
Top
We also provide database design and custom application
development services.
Paradox Related
Documents
Documents here are available for download. They
are organized by Author and listed by Title in the order which the author
submitted them. These documents can range from discussions of general database
issues to specific examples of how to provide various functions and features in
Paradox. They may contain code samples in text but do not contain any actual
paradox objects. They are either in PDF format (pdf), or plain ascii text
(txt). Return to Top Jump to
code samples, freeware,
shareware.
Santoro,
Dennis: Data Normalization: A
Primer. Download Now (40K)
This
document lays out the basics of normalizing organizational data for building
databases. The rules of normalization are presented and a sample contact
management system is taken from unstructured through each normal form from
first to fifth. Current version from 16 October, 2002
Santoro, Dennis: Data Base Basics:
Getting Started in Paradox. Download Now
(25K)
This paper describes some general database development issues
and some specific basic do's and don't for getting started developing databases
in Paradox. This is a work in progress and topic suggestions and other feedback
are welcome. Keep an eye out for revisions. Current version from 15 January,
2002
Santoro, Dennis:
Hammering Screws or Designing Databases. Download Now (13K)
This is an opinion
piece on the need for proper use of tools and proper database designs. It may
be useful in thinking about design and also possibly helpful in justifying
design time to management.
Santoro,
Dennis: Change Partners: A Technology Dance.
Download Now (15K)
This document
discusses what happens when an organization develops new technology standards.
How these standards often are, and how they should be, applied to existing
systems and new development are presented including questions which should be
asked and answered in this process. The responsibilities of proponents of
change and of stake holders in existing systems are also discussed. If you have
recently heard the statement "your system no longer conforms to our standards"
or "we have decided the organization will switch to [product name here]
software" this paper is a must read.
Santoro, Dennis: Containership on Forms.
Download Now (380K)
This document
describes issues relating to placing fields on forms with and without record
containers such as multi record objects. It includes graphics showing how such
containers can be embedded in each other and discusses when and why you would
want to do this.
Santoro,
Dennis: Apache and Apache-SSL Proxy Setup to Paradox Web Server
OCX for Internet Enabled Databases. Download
Now (15K) Paradox makes a wonderful web server for database oriented web
sites. You can harness the power of the Object PAL language with your web site
through the Web Server OCX included with Paradox. Tony McGuire's "Paradox Web
Server" article describes how to use the OCX. This is a how to article which
describes how to use Paradox as a database back end proxy from Apache web
server or, if you need Secure Socket Layers (SSL), from Apache-ssl to add
further functionality and security to your site. Keep an eye out for
revisions. Current version from 11 December, 2000
Dickerson, Chad: The Unsung Heroes
View
Article at the Infoworld Site This is an excellent article describing
the realities and difficulties of explaining and quantifying software
development. From the article itself: "..when you get to software development,
the business people in your organization start wondering, "What in the world
are these people doing?" You can see the help desk fixing desktop machines and
you can watch the networks and systems staff work with servers and switches,
but how do you observe the building of software? As a manager, how do you make
sure that your software developers get the real recognition they deserve when
all of their work is virtual? In many projects that involve building
substantial back-end "plumbing," it's nearly impossible to demonstrate the
scope and detail of the work to a nontechnical business person. This is the
world in which developers operate every day."
McGuire, Tony: Paradox Web Server.
Download Now (55K)
This is a how to
article and Q & A on using Paradox as a web server to provide web sites
with database capabilities. It contains a step by step process for how to
accomplish this. This is currently in draft form and suggestions and feedback
are welcome. Keep an eye out for revisions. Current version from 7 November,
2000
Woodhouse, Liz:
Connecting Paradox to ODBC. Download Now
(9K)
This is a how to article on using Paradox to connect to and
access a variety of ODBC database sources. It specifically addresses connecting
to MS Access tables but also covers differences connecting to other
sources.
Code Samples
Included here for download are samples of code which have been
submitted. They are organized by Author and listed by Title in the order which
the author submitted them. These samples show methods of solving common Paradox
related problems and how to provide various functions and features. These
documents do contain Paradox objects. They are all available here in compressed
format and may contain multiple components.Return to Top
Jump to documents,
freeware, shareware.
Santoro, Dennis: VCR Record Navigation
Control. Download Now (4K)
This document
is a zip file which contains a paradox form which contains a VCR style record
navigation control which you can copy and paste into your own forms.
Santoro, Dennis: Widgets.
Download Now (6K)
This document is a zip
file which contains a paradox form with a set of controls which you can copy
and paste into your forms. These include a cut, copy and paste control, Edit
toggle button with swapping Begin Edit and End Edit label, search and search
next buttons and next page and previous page buttons. Updated on 3 October,
2000
Santoro, Dennis:
Trap X: RDA's Action trapper. Download Now
(40K)
This document is a zip file which contains a paradox form
trapx.fsl and a table, constant.db and its associated files. You can drop
objects and code into this form and run it to see the action Constant NAMES
which are triggered rather than the ID integers. You can also use the table and
code, which you can copy and paste into your own forms to get the same effect.
This makes determining event model behavior and which constants to trap for and
or use much simpler than getting the constants and then enuming them.
Santoro, Dennis: Basic Password
Dialog. Download Now (4K)
This
document is a zip file which contains a paradox form rdapwdlg.fsl. This is a
basic password dialog form which demonstrates substitution of * for keystrokes,
backspace deletion of single characters, delete key deletion of the whole
password line etc. It is expected you may have to modify the OK and Cancel
buttons and manage the way you return the password itself but it will easily
for the basis for password handling. If you need more sophisticated password
handling you may wish to check out our
Security Guard product.
Updated on 10 October, 2001
Santoro, Dennis: Time Calculation Demo.
Download Now (4K)
This document is a zip
file containing a form and a table. The form uses calculated fields to convert
datetime values to Hours, Minutes, Seconds and Milliseconds. The formulas are
accessible so you can see how this is done.
Santoro, Dennis: Application Sizing and Titling
Demo. Download Now (4K)
This
document is a zip file containing a form. The Code in this form demonstrates:
1. how to use explicit sizing code to size your Application's desktop on the
windows desktop, 2. how to use an application variable to title your
application desktop and its button on the start bar 3. how to use a form to
specify its own location folder and add an alias to that folder on startup 4.
how to attach a form variable to a form
Caple, Steve: Custom Lookup Dialog Form.
Download Now (47K)
This document is a
zip file which contains forms, tables and instructions which can be used to
demonstrate custom lookup dialogs and to incorporate custom lookup into your
applications. It also includes a short list lookup using a popup menu.
Updated on 20 January, 2006
Caple,
Steve: Filter Demonstration. Download Now (21K)
This form demonstrates a
technique to remind users that a filter has been set on the table they are
using. Play the script "FilterDemoStart" to establish a project alias
FILTERDEMO before opening the form. To use this technique, copy the button
FilterCheckBtn and associated text object FilterTxt to your form. Most of the
code is in events and custom methods on the FilterCheckBtn object. You do need
to add two pieces of code at form level: a constant kFilterObj, set to the name
of the uiObject the filter check applies to, and a dynArray variable
dyGenFilter.
Caple, Steve:
List Demo Form. Download Now (9K)
This document is a zip file which contains a small form that demonstrates
filling lists from a table and changing the contents of one list based on the
selection from another list. It uses tCursors and setRange and list item
assignment within a scan loop. Updated on 24 May, 2004
Caple, Steve: Progress Dialog.
Download Now (7K)
This document is a zip
file which contains a Paradox form "ProgDlg.fsl" and a Paradox script
"ProgDlgExample.ssl" that demonstrates calling the dialog form. Open the script
in design mode and substitute your table for assignment to the variable stTbl.
Once the form is opened, you can use the form handle inside a tCursor scan
loop, a while loop, or other iterative process, calling the form method
ShowPct(nPct number), passing it a numeric value <= 1.00. ShowPct adjusts
the size of a colored bar (a box object) to that portion of its full
range.
Cronk, Paul: Twain
Support in Paradox. Download Now (52K)
This document is a zip file which contains a PDF document describing Twain
and using twain in Paradox. Also included are 3 Paradox forms,
"SelectSourceDlg.fsl," "PictureSaver.fsl" and "AddPicture.fsl" a Paradox script
"PictureSaverStartup.ssl" and a table, "Pictuers.db" that demonstrate using
Twain in Paradox. Start with the document which also includes the instructions
for the forms and script. Updated 15 February, 2002.
Evans, Martin: Table Compare
Utility. Download Now (10K)
This
document is a zip file which contains a readme file and a form, compare.fsl.
This form will compare 2 tables identical in structure and indexing, but not
identical in contents. It ignores graphic, binary, formatted memo fields and
any field names you type as a comma separated list into the Ignore field on the
form. Tables must have a primary index. Presently hard-coded for 5 keys max,
easily extended. The use of FileBrowserEx() procedure restricts this form to
later versions of Paradox. However, switching to the older FileBrowser()
procedure will make this work in older versions.
Haines, Randy: File Uploading Via HTTP
with Apache, ActivePerl, and Corel Web Server OCX.
Download Now (11K)
This document is a
zip file which contains 4 attachments: FileUpload.pm, SmplForm.htm, UpLoad.cgi
and FileUpld.rtf. FileUpld.rtf contains all the instructions. The other 3 files
are required for setup. The file uploading solution described in this document
is intended to enhance the capabilities of Paradox and Corel Web Server OCX,
which, as of version 9 does not support file uploading. The use of shareware
programs Apache Web Server and ActivePerl, allow file uploading to be achieved
with minimal or no additional cost.
Kolar,
Ivica: Locked Tableframe columns demo.
Download Now (38K)
A fully working
example with Custom Horizontal Scroll bar with lock columns feature, switching
a tableframe to an arbitrary arrangement of columns, rearranging columns using
drag and drop etc. Documentation is also included in the form by placing it in
design mode and right object exploring the aLib text object.
Krieg, Tom: Printing from Dot Matrix
Printers. Download Now (12K)
This
document is a zip file which contains an undelivered Paradox library (lsl) with
the code needed to print a report from a table to a dot matrix printer. Also
included is a text file documenting how to use the library. You can modify the
code to meet your specific needs.
Millsaps, Gene: Twip to Other Units
Calculaor. Download Now (17K)
This
document is a zip file which contains the form TwipCalc.fsl, which performs
conversions of dimensions for Paradox objects. When the user enters a dimension
in inches, twips or centimeters, the form displays the related equivalent
values in the other units. The document TwipCalc.zip contains the form,
associated table, and setup notes. Updated on 20, May, 2001
O'Griofa, Padraig: Various Tools.
Download Now (41K)
This zip file contains
FILESTAMP.FSL - Changes the datestamp on file(s), MOVEOBJECT.FSL - Allows
runtime users to modify object positions on FSL form, EDITMTHD.FSL - Allows
runtime users to edit OPAL code in a FSL form, EDITRPT.FSL - Allows runtime
users to edit the text labels in a RSL report, EDIT_TBL.FSL, _TBLVIEW.FSL -
Allows runtime users to edit tables. These tools are undocumented and provided
as is. Read the included txt file for conditions of use.
Straus, Harald: Paradox Twain.
Download Now (108K)
This zip file
contains a code sample for OPAL (Paradox 7-9) with Twain support using the
EZTWAIN.DLL (Freeware for personal use from DOSADI http://www.dosadi.com). A
copy of EZTw32.dll must be in the Windows system directory and a TWAIN scanner
(or camera etc.) must be installed. The functionality depends on the Twain
version you use.
Wendover,
Carolyn: Table Compare Utitlity. Download Now (16K)
This document is a zip
file which contains a form a script and a report. When the script is run it
creates a private table used by the form and report.
Woodhouse, Liz: Custom Locate Value dialog.
Download Now (17K)
This document is a zip
file which contains a form a library and instructions which provide a custom
locate value dialog to replace the built in dialogs invoked by Ctrl+Z and
Ctrl+A. Use of this dialog and corresponding code gives the developer more
control over searches performed by the user.
Woodhouse, Liz: Show Users.
Download Now (8K)
This zip file includes a
form which shows the number of users currently in the .NET file. Click on the
number to display the user names alphabetically. Also includes instructions and
a batch file to run the shareware WHOHAS (not included) program for Novell
networks to resolve the problem of certain versions of Client32 occasionally
reporting a blank user name (this shows which user the blank really
is).
Woodhouse, Liz:
Playfair Square Encryption/Decryption Toy. Download Now (18K)
This zip file includes a
form and tables which will encrypt and decrypt text using the rules of the
Playfair Square. The code was used early in World War II. Rules for the code
and an example are in the included text file. This form is strictly for fun,
however, the encryption/decryption routine may be of some interest (if not
use).
Woodhouse, Liz:
Calendar Maker. Download Now (27K)
The enclosed form, table and reports generate printable calendars - large (2
months/page), medium (6 months/page) or small (2 years/page, formatted like on
the back of most personal check registers found in the US). You cannot add
additional text or formatting to specific days.
Woodhouse, Liz: Type Ahead Demo.
Download Now (15K)
This zip file includes
typea.fsl which is a form which demonstrates various ways of using 'type ahead'
code. It demonstrates searching for values in a tableframe using an unbound
field to type in search criteria, searching a field in a tableframe (whose
table is read-only in the data model) by typing in the field you're searching
and populating a field in a new record by searching the same field in the same
table for values which start the same as what's been typed thus far.
Woodhouse, Liz: Reorder Keyed
Records Demo. Download Now (18K)
This
zip file includes reorder.fsl contains code which allows one to re-order
records in a table without requiring the key value to be changed. This may be
useful if records need to be in some order not defined in a logical fashion
(such as copied from a paper document).
Zevenaar, Peter: Generic Custom Dialog Demo.
Download Now (17K)
This zip file includes
a custom dialog form for different kinds of user input for different data
types, called CmView. Along with its 4 methods it offers more efficient
programmatic control over user's input then Paradox's built-in view( ) method
and prevents you from having to make many custom dialog input forms yourself.
CmView allows you to pass and return the following data types: Date, Datetime,
Time, Small Integer, Long Integer, Number, and String. It works in Paradox
versions 7 to 10.Updated on 22, August, 2002
Freeware
Listed in this section
are freeware items submitted for general use or links to freeware sites which
include Paradox freeware. These items are also listed by Author and by Title in
the order the author submitted them. Note that other freeware may be available
from the Partner's and Links page. Return to Top Jump to
documents, code samples,
shareware.
Diamond
Software Group, Inc. Click
here. This site includes various freeware and documents related to
Paradox. It is run by Steve Green who is also a Corel C-tech.
Hutton, Pascal:
Click here. This site includes
tips and freeware demonstrating what it is possible to do with Paradox and
Win32 API. It includes a DLL, built with Delphi for copying directories using
the API. These tools are designed to make Paradox more powerful and have access
to API calls that require structures or arrays.
Isberg, Bertil:
Click here. This site
includes various freeware and documents. Although much of it is in Swedish some
is in English and some is useful regardless. Rebld32 is a utility for automated
table repair. Code is also an example on how to use tutil32.dll and tuwwr.dll.
Other documents include a regularly updated bug list.
Menkin, Vladimir:
Click here. Various Freeware
including Proview which is a project viewer replacement, a calendar tool and
more. Mirror Site
Moore, John:
Click here. Site
includes BDE backup and configuration utilities, delete lck file utility,
shortcut maker beta an Interbase migration tool beta and more.
Shareware
Listed in
this section are shareware items submitted for general use. These items are
also listed by Author and by Title in the order the author submitted them. Note
that other shareware may be available from the Partner's and Links page.Return
to Top Jump to documents,
code samples, freeware.
| ------------------------- |
|
|||||||
| Send comments to:
info@RDAWorldWide.Com Or use the contact mail form here on the site |
 |
Copyright © 2000 - 2006 Resource Development Associates. All
rights reserved.
Last Revised: 8/22/2006
