IT SOLUTIONS
Your full service technology partner! 
-Collapse +Expand
To/From Code
-Collapse +Expand Cross Ref Guide
-Collapse +Expand Members-Only
Sign in to see member-only pages.
   ► KBTo/From GuidesCorel ParadoxTool Basics  Print This     

Cross Ref > Tool Basics

By Mike Prestwood

Corel Paradox versus Access VBA: A side by side comparison between Corel Paradox and Access VBA.

 
Tool Basics
 

Developer environment basics such as common file extensions, common keyboard shortcuts, etc.

Deployment Overview

[Other Languages] 
Corel Paradox: 

To deploy a Paradox application, you need to deploy either the full version of Paradox or the Paradox Runtime both of which will include the BDE as well as any dependecies you've added such as psSendMail DLL, ezDialogs, etc.

More Info / Comment
Access VBA: 

You can deploy your Microsoft Access application either with the full version of Access or with the Access Runtime (see Deploying Applications Using the Access Runtime).

More Info / Comment




Development Tools

[Other Languages] 

Languages Focus

Primary development tool(s) used to develop and debug code.

Corel Paradox: 

Corel Paradox for Windows (was Borland Paradox). Also, Borland used to offer a Paradox for DOS tool which support it's Paradox Application Language (PAL) which is not compatible with ObjectPAL. The biggest drawback to Paradox is that Corel does not have anyone at Corel actively developing Paradox for Windows (as opposed to Microsoft Access which does).

Access VBA: 

Microsoft Office Access is the primary tool and does include pretty good debugging features, some limited OOP features such as designing a class and instantiating an object, and, best of all, MS still has developers working on MS Access (as opposed to Corel Paradox).

More Info / Comment




File Extensions

[Other Languages] 

Languages Focus

Common or primary file extensions used (not a complete list, just the basics).

Corel Paradox: 

Paradox for Windows has two primary file types: source files and delivered files:

Source Files
Source files in Paradox are binary but can can be opened in later versions of Paradox and even in earlier versions if you don't use any new features.

  • .FSL = Form
  • .RSL = Report
  • .SSL = Script
  • .LSL = Library

Since Paradox source files do not compile to an EXE, Paradox developers tend to use a startup form or script to start the application.

Access VBA:   .MDB
  • .MDB - Access Database
  • .MDE - Protected Access Database




Overview and History

[Other Languages] 
Corel Paradox: 

Language Overview: Object based language. Although ObjectPAL uses object oriented techniques "under the hood", it is not object oriented. Although you cannot create classes, ObjectPAL has built-in objects you can use in your code. You code in a traditional approach attaching code to objects or within a script. Most Paradox applications are form based. You may have a short startup script but you design forms and reports and tie them together with a common form. You can store reusable code such as custom methods and procedures in a library.

Target Platforms: Corel Paradox is most suitable for creating business desktop applications that run within Corel Paradox for Windows.

More Info / Comment  
Access VBA: 

Language Overview: Class-based language. Although you can create classes, Access VBA is not fully OOP. It is a traditional language with a few OOP extensions. You code in a traditional approach using functions, procedures, and global data, and you can make use of simple classes to help organize your reusable code.

Target Platforms: Microsoft Access is most suitable for creating business desktop applications that run within Microsoft Access for Windows.

More Info / Comment




Report Tools Overview

[Other Languages] 

Languages Focus

Built-In: Some development tools have a reporting tool built-in and some do not. For example, typically desktop databases such as Paradox and Access have a built-in reporting tool and typically that reporting tool is used with nearly every application built with it. A built-in reporting tool makes development of reports across many clients and applications consistent and therefore easy.

Add-On: Development tools that do not have a built-in reporting tool need to use either a currently bundled report writer, or one of the popular reporting tools that integrates well with the development tool. For example, popular reporting tools include Crystal Reports, ReportBuilder, and MS SQL Reporting Services (tied to MS SQL).

Corel Paradox:   Built-In

Paradox offers a built-in reporting tool that will suffice for most desktop database applications.

More Info / Comment
Access VBA:   Built-In

Microsoft Access offers a built-in reporting tool that will suffice for most desktop database applications.

More Info / Comment




Go ahead!   Use Us! Call: 916-726-5675  Or visit our new sales site: 
www.prestwood.com


©1995-2020 Prestwood IT Solutions.   [Security & Privacy]