 |
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
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 16 March,
2009
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 - 2009 Resource Development
Associates. All rights reserved.
Last Revised: 3/16/2009
