PrestwoodBoards.com
Find Member or Company: 
Find by ID#: 
Tech Search: 
Join Today Sign In
-Collapse +Expand

Paradox
Search Paradox Group:

Advanced
-Collapse +Expand Paradox Group Home◄╣
-Collapse +Expand Message Board
-Collapse +Expand Knowledge Base
-Collapse +Expand Paradox To/From
To/FromCODEGuides
-Collapse +Expand Paradox Study Test
PRESTWOODCERTIFIED
-Collapse +Expand Paradox Store
PRESTWOODSTORE
-Collapse +Expand Members Only
   PrestwoodBoards ► All Groups   

New to PrestwoodBoards?

Sign up, it's free and anyone can join.

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.

Paradox 9 Developer's EditionWelcome 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:
Paradox Content!
Chat!
Paradox Board:
Posts =  6,857
Threads =  1,691
Unanswered =  69
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
Sign In To Check If Stuff Is New
22
Hits
 1. Printing forms as reports doesnt get all pages
I have a 3 page form that I need to open as a report.  When I open it, however, I only get the ...
8/12/2010, 10:29:46 AM
MB Post 		Paradox Reports  
Sign In To Check If Stuff Is New
48
Hits
 2. RE: Paradox 7 Update
Never mind, I've applied the patch selectively.
8/11/2010, 3:28:53 AM
MB Post 		Paradox Setup, Vista, etc.  
   3. Paradox 7 Update...again! By Paul.R
Sign In To Check If Stuff Is New
144
Hits
 4. pdox 9 crashes
My Pdox 9 crashes whenever I try to run a new form.  I'm running Windows 7   64bit.&n...
8/5/2010, 3:32:30 AM
MB Post 		Paradox Reports  
Sign In To Check If Stuff Is New
555
Hits
 5. RE: Paradox11 on MS Server 2000 w/...
Hi Tom,  We work in...
8/4/2010, 11:35:20 AM
MB Post 		Paradox Setup, Vista, etc.  
   6. Music App...again! By tomhowes
More...

New: Paradox Message Board Posts
Go To: Paradox Message Board
 Thread StarterReplies Last Post Topic
Sign In To Check If Stuff Is New
8
Hits
 PrinterSetCurrent
I have the following code on a form to switch printers behind the scenes.  There is a table that lists the users printers and a field in that table that defines what the printer is used for (i.e....
0New!
9/2/2010
 ObjectPAL
Sign In To Check If Stuff Is New
7
Hits
 ReportPrintInfo DynArray
Can anybody explain to me the syntax to use ReportPrintInfo - the syntax # 3 version that uses an array? I need to set the PrintToFile option to create a postscript file and it seems to only be availa...
0New!
9/2/2010
 ObjectPAL
Sign In To Check If Stuff Is New
10
Hits
 ReportPrintInfo DynArray
Can anybody explain to me the syntax to use ReportPrintInfo - the syntax # 3 version that uses an array? I need to set the PrintToFile option to create a postscript file and it seems to only be availa...
0New!
9/2/2010
 ObjectPAL
Sign In To Check If Stuff Is New
22
Hits
 Changing account records based on a list
Does anyone know how to write this Paradox 4.5 code into a Paradox 11 script? This works in my old Paradox. It goes through a list of account names finds the account in another table and scans to pro...
0New!
8/29/2010
 ObjectPAL
More...

Unanswered: Paradox Message Board

 Thread StarterReplies Last Post Topic
Sign In To Check If Stuff Is New
8
Hits
 PrinterSetCurrent
I have the following code on a form to switch printers behind the scenes.  There is a table that lists the users printers and a field in that table that defines what the printer is used for (i.e....
0New!
9/2/2010
 ObjectPAL
Sign In To Check If Stuff Is New
7
Hits
 ReportPrintInfo DynArray
Can anybody explain to me the syntax to use ReportPrintInfo - the syntax # 3 version that uses an array? I need to set the PrintToFile option to create a postscript file and it seems to only be availa...
0New!
9/2/2010
 ObjectPAL
Sign In To Check If Stuff Is New
10
Hits
 ReportPrintInfo DynArray
Can anybody explain to me the syntax to use ReportPrintInfo - the syntax # 3 version that uses an array? I need to set the PrintToFile option to create a postscript file and it seems to only be availa...
0New!
9/2/2010
 ObjectPAL
Sign In To Check If Stuff Is New
22
Hits
 Changing account records based on a list
Does anyone know how to write this Paradox 4.5 code into a Paradox 11 script? This works in my old Paradox. It goes through a list of account names finds the account in another table and scans to pro...
0New!
8/29/2010
 ObjectPAL
More...

New: Paradox Knowledge Base Posts
Go To: Paradox Knowledge Base
    KB Article KB Topic
Sign In To Check If Stuff Is New
190
Hits
Download		 1. StruList

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

6/23/2010
Paradox Tables
Sign In To Check If Stuff Is New  
573
Hits

Code
KB Post
2. ObjectPAL Array (Array[] type)

Languages Focus: Array

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

3/29/2010
Paradox & ObjectPAL
Sign In To Check If Stuff Is New
802
Hits
Download		 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
Sign In To Check If Stuff Is New
430
Hits
Code		 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 35, Posted Monday 8/30/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

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 Commercial Apps

Commercial applications built using Paradox. Add your commercial app!

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!

PrestoEdit
ThesaurusThe 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 9 BookParadox 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.

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.

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.
Contact Us   Comment On Page   Report Problem       Email This Page   Printable Version   
 
Who's Online! PrestwoodBoards
306 People Online Now!!  
Online Now: Sign In to see who's online now!  Not a member? Join Prestwood now. It's free!