IT SOLUTIONS

916-726-5675

Client Sign In

Paradox

	Paradox Group Home◄╣
eMag: Paradox Edition New/Updated Posts

	Message Board
MESSAGEBOARD Q&A Message Board -New Activity -Unanswered Threads -Most Active Threads -Most Read Threads

	Knowledge Base
KNOWLEDGEBASE Knowledge Base -New & Updated -Most Read -10 Min Quickstarts -Recent Comments Tech Articles Paradox News Errors Library File Library Resource Links PARADOXTIDBITS: All as FlashCards Code Snippets FAQs Tips Terms & Definitions

	Paradox To/From
To/FromCODEGuides Paradox To/From

	Paradox Study Test
PRESTWOODCERTIFIED Paradox Study Test

	Paradox Store
PRESTWOODSTORE Store Home Buy Paradox Items

	Members Only
MEMBERSONLY Paradox Member List Member Only KB Posts Paradox Content Stats Random Article Random MB Thread Random Tidbit Random CrossRef Code MYGROUPSETTINGS My Group Settings

Prestwood IT ► PrestwoodBoards ► All Groups

New to PrestwoodBoards?

Join Today for a free account,
or Sign In if you are already a member.

Paradox Group

Welcome Guest!

This page is the Paradox Group home page (summary page).

Corel Paradox

Corel Paradox for Windows and ObjectPAL group (was Borland Paradox). Covering all versions of Paradox for Dos, Paradox for Windows, and Paradox for Linux including help with the BDE and Paradox tables.

Welcome Paradox power-users
and ObjectPAL developers!

Start Here: Everyone Articles

We have tons of info here, but the following are important Paradox articles everyone should read:

General:

Installation:

Install Paradox 9 on Vista
Install Paradox 10 or 11+ on Vista
Paradox 9, 10, 11 on Windows 7 Question
Download: Runtimes (get the latest)
Download: Borland Database Engine 5.202 (latest BDE)
BDE Best Practices: Safely Use Paradox Tables

Featured Interactive Articles:

Get Started Coding with ObjectPAL:

Paradox Content!

Chat!
Paradox Board:
Posts =	6,841
Threads =	1,685
Unanswered =	66
Topics =	16

Research!
Paradox KB:
Articles =	108
News =	9
10 Min Starts =	3
Code =	41
Tips =	27
FAQs =	19
Dictionary =	6
Errors =	4
Links =	16
Files =	26

Translate!
To/From Code:
Topics =	55
Code =	660

Study!
eCertified:
Beg Q. =	9
Int Q. =	9
Adv Q. =	6

Write!
Member Blogs:
Blogs =	2
Entries =	33

What's happening now! Paradox Group!

(New, updated, and unanswered.)

New: All Post Types

Message board, knowledge base, article comments, blogs, news, etc.

Title

Type

Topic

14
Hits

Don.C

1. Paradox 9 Runtime - Report with QBE included

I've inherited a Paradox 9 application that needs to be cleaned up and stabilized. The biggest singl...

7/30/2010, 12:44:53 PM

MB Post

Paradox Runtime & Distribution

485
Hits

Tom Howes

2. Paradox for First Presbyterian Church of Honolulu

Hi Mike, It's been 3 years since I updated you on my project here at First Prez. Lots of chan...

7/29/2010, 2:23:26 PM

MB Post

Paradox Setup, Vista, etc.

19
Hits

Mike Prestwood

3. RE: Debugger wont go away

Hi Jon, Verify the debugger is not set to open in run nor design modes. Select Tools | Settings | ...

7/28/2010, 7:56:16 AM

MB Post

ObjectPAL

4. Debugger wont go away...again! By jondm

34
Hits

Julian.H

5. RE: Opening a tcursor with a passw...

Many thanks Dan, that works perfectly!Cheers,Julian

7/26/2010, 6:08:37 AM

MB Post

ObjectPAL

6. RE: Opening a tcursor with a passw......again! By Dan

More...

New: Paradox Message Board Posts

Go To:

Paradox Message Board

Thread Starter

Replies

Last Post

Topic

15
Hits

Don.C

Paradox 9 Runtime - Report with QBE included

I've inherited a Paradox 9 application that needs to be cleaned up and stabilized. The biggest single problem is that all users have access to the full version of Paradox so they go in an make copies ...

New!

7/30/2010

Paradox Runtime & Distribution

28
Hits

Jon

Debugger wont go away

I recently wrote a piece of code that locked up paradox and i hit Ctrl + Break a bunch of time to try to get it to stop. No Success - had to pull up task ...

mprestwood

RE: Debugge...

Hi Jon, Verify the debugger is not set to open in run nor design modes. Select Tools | Settings | ...

7/28/2010

ObjectPAL

41
Hits

Julian.H

Opening a tcursor with a password

Hi thereI'm new to ObjectPAL and enjoying learning! I'm working with a Paradox database that has a password assigned to all the tables (the same password). Howe...

Julian.H

RE: Opening...

Many thanks Dan, that works perfectly!Cheers,Julian

7/26/2010

ObjectPAL

44
Hits

brationer1

Networking Paradox 9

My company has intentions of running Paradox 9 on Server 2008. The Operating System on most of our computers is Windows 7 Pro. Is this a good ...

mprestwood

RE: Network...

Sure, this will work well. Just stay away from Vista which it sounds like you are. If you need help,...

7/25/2010

QBE & SQL

More...

Unanswered: Paradox Message Board

Thread Starter

Replies

Last Post

Topic

15
Hits

Don.C

Paradox 9 Runtime - Report with QBE included

New!

7/30/2010

Paradox Runtime & Distribution

No activity last 2 weeks. Post a reply to make active.

41
Hits

Daniel Fought

Are you getting error messages...

Are you getting error messages during startup? Have you double checked the netdir setting in the BDE? What about the drive mapping of the Q drive on the Win7 PC?

New!

7/6/2010

Paradox Setup, Vista, etc.

57
Hits

Jay.M

StruList Documentation

I have downloaded the StruList Utility, but the Installation documentation is missing.. do you still have that? The Strulist is experciencing problems and I am sure it is my mistake in ins...

New!

7/6/2010

Paradox Tables

186
Hits

Charles Hudson

P9 Project Viewer Anomalies

I have Paradox 9 Developer Edition installed on two machines here in my cube. On one machine I am running Win 2k (for testing legacy applications) and the other runs Win XP. Both ma...

New!

4/12/2010

Paradox Runtime & Distribution

More...

New: Paradox Knowledge Base Posts

Go To:

Paradox Knowledge Base

KB Article

KB Topic

111
Hits

Download

Steve Caple

1. StruList

Paradox utility for listing Paradox table structures (requires Paradox 9, 10, or 11).

6/23/2010

Paradox Tables

466
Hits

Code

KB Post

Mike Prestwood

2. ObjectPAL Array (Array[] type)

Languages Focus: Array

A data structure in which individual values (called elements or it...

3/29/2010

Paradox & ObjectPAL

700
Hits

Download

Mike Prestwood

3. Paradox 9 Help & PDF Files

Paradox 9 ships with several very valuable help files. For convenience, you can also download them here.

3/21/2010

Paradox & ObjectPAL

374
Hits

Code

Mike Prestwood

4. OLEAuto Paradox to Outlook

The following code snippet adds an appointment to your Outlook calendar. Tested with Paradox 9 an...

2/18/2010

OPAL: Wicked Coding Tasks

More...

New: To/From Code

Go To:

Paradox To/From Guides

Code Snippets

	Code Snippet	Created
1.	Array	3/23/2010
2.	Sort Records	2/8/2010
3.	Filter Records	2/7/2010
4.	Find Record	2/7/2010
5.	Edit Record	2/7/2010
6.	Record Movement	2/7/2010
7.	Comments	1/1/2009
8.	subStr	1/1/2009
9.	End of Statement	1/1/2009
10.	Case Sensitivity	1/1/2009

Topics

	Topic	Category	Created
1.	Array	Data Structures	3/20/2010
2.	Sort Records	Database	2/8/2010
3.	Filter Records	Database	2/7/2010
4.	Find Record	Database	2/7/2010
5.	Edit Record	Database	2/7/2010
6.	Record Movement	Database	2/7/2010
7.	Comments	Language Basics	1/1/2009
8.	Left of String	Commands	1/1/2009
9.	Prevent Derivation	OOP Details	1/1/2009
10.	Abstraction	OOP Details	1/1/2009

New: eCertified Study Questions

Go To:

eCertified

Question	Level	Type	Based on KB Post	KB Topic
An ObjectPAL array is 0-based, meaning, ...	2	TF	ObjectPAL Array (Array[] ...	Paradox & ObjectPAL
ts.setPosition(1) ts.writeLine("bb") ts.close() ">Given a text file named TextStreamTest.t...	3	MC	An ObjectPAL Primer: Part...	OPAL: Language Basics
What are the logical operators?	1	MC	ObjectPAL Logical Operato...	OPAL: Language Basics
Which is the correct syntax to assign a ...	1	MC	ObjectPAL Assignment (=)	OPAL: Language Basics
OjectPAL does not offer an ElseIf statem...	2	TF	ObjectPAL If Statement (I...	OPAL: Language Basics
Which statement is true?	2	MC	ObjectPAL Self Keyword (S...	OPAL: Language Details
Which code statement correctly embeds a ...	1	MC	ObjectPAL Literals (quote...	OPAL: Language Basics
">It is legal to put two code statements o...	2	TF	ObjectPAL End of Statemen...	OPAL: Language Basics
Which answer best describes ObjectPAL co...	1	MC	ObjectPAL Comments (; and...	OPAL: Language Basics
With regard to commands and variable nam...	1	YN	ObjectPAL Case Sensitivit...	OPAL: Language Basics

Weekly Paradox Lesson

[Print Lesson]

Week 30, Posted Monday 7/26/2010

Content changes every Monday @ 1AM!! Check back once per week. Learn! Review! Test Yourself!

FAQ of the Week Question: I was just reviewing the Paradox Table Specs in your Paradox developer reference area. I found specs through Paradox 7 only, and I'm really interested in Paradox 10. Is it available? Answer: No. Actually Paradox 7 "table structure" is the latest very flexible table structure. The only table structures are 1...3.x, 4.x, 5, and 7. No such thing as a Paradox 9 or 10 or 13 table structure.	Tip of the Week Tip: If you ever have a calculated field on a form not update when you think it should, then you can use the ObjectPAL method forceRefresh() to make the calculated field display the correct values. This can occur, for example, when you update a field involved with a calculated field using a TCursor.
Code Snippet of the Week Calling an Oracle Stored procedure from Paradox In Paradox, use an sqlQuery block to call store procedures. The following code uses an sqlQuery block to call an Oracle stored procedure. Use the syntax of whatever SQL server you're going against. With Oracle, if I remember correctly, you use an "execProc" or "exec" command. sqlQuery = SQL ;execute proc here ENDSQL if not dbSQL.executeSQL(sqlQuery, tcAnswer) then errorShow() endIf	Definition of the Week Project Alias: A project alias, like public aliases, point to a folder. Project aliases are stored in the PDOXWORK.CFG file, which is loaded whenever you change working directories. You can create either a public or project alias. A project alias, like public aliases, point to a folder. Project aliases are stored in the PDOXWORK.CFG file, which is loaded whenever you change working directories. You can think of project aliases as aliases that belong to a certain project stored in a specific working directory.
Link of the Week Corel WordPerfect X3 Pro Home Page	File of the Week Audio: Introduction to OO for the Paradox Community View File Info Page

Lastest Paradox Flashcard

Our flashcards are part of our library of tidbits.

Tidbits are FAQs, Definitions, Tips, and Code Snippets from our knowledge base.

ObjectPAL Array (Array[] type)

Arrays in ObjectPAL use a 1-based indice.

Use size() to get the number of elements. size() returns 0 if the array has no elements.

var
  MyArray Array[4] String ;Fixed size array.
  i LongInt
endVar
MyArray[1] = "Mike"
MyArray[2] = "Lisa"
MyArray[3] = "Felicia"
MyArray[4] = "Nathan"
if MyArray.size() > 0 then
  for i from 1 to MyArray.size()
    msgInfo("", MyArray[i])
  endFor
endIf

Posted By Mike Prestwood, Post #102138, KB Topic: Paradox & ObjectPAL

Mike Prestwood Interview

This interview was conducted by SSAPCS in April 1999 and this is the result of that interview.

Paradox Books

List of Paradox books. Lots to download here!

Paradox Books

Paradox Commercial Apps

Commercial applications built using Paradox. Add your commercial app!

Commercial Apps

Paradox Coding Convention
Prestwood Coding Convention: Paradox Edition

Standards help ensure a successful end product. Our standards include a documented software development process (the recipe for building software), and a coding convention (which guides us on the details of using specific software). Our standards are here for you or your organization to adopt!

Prestwood Coding Convention

PrestoEdit
The serious programmer's editor of choice! Advanced multi-tabbed source code editor includes support for HTML, ObjectPAL, C++, Batch files, Delphi, SQL, Java, VB, Perl, and more.

Paradox Power Programming
By Mike Prestwood.
The official developer's guide to ObjectPAL and Paradox. The Most Complete Guide to Programming in Paradox. This book explains how to use the key components of Paradox programming, including ObjectPAL, Database Design, Object-Based Programming, SQL, Crosstabs, Graphs, Application Framework, Runtime, and Distribution Expert.

Official Home Page

Workbench for Paradox
Add 50+ options to Paradox.
Workbench is an add-on suite of tools for the 32-bit version of Paradox and is geared toward speeding up the development of business database applications. This tool suite installs right into Paradox's Tools menu giving you easy access to over 50 options.

Workbench Home

psSendMail DLL
Send e-mail directly from your application. Works with all 32-bit Windows development environments and includes Paradox, Access, and Visual Basic examples.