Coding Services
Prestwood
Coding Services
Prestwood Software offers a full line of coding services including developer help, maintenance coding, conversions, testing, database design, and more.


Prestwood eMagazine
Subscribe to our popular FREE monthly eMagazine.

Enter your email:

Subscription Center
 
Support Us!
Support this community,
buy from our store!

Prestwood Ping Server

$29.95
Visit Store
Online Now: 1031 Guests, 14 Members>>>Nancee  Gary Mulcahy  kwolfson  Wes Peterson  Adam Lum  davidb  randy_danho  joseph_restle  ަѶQ  hhb03610  ciuly  Amit_Pandey993  swawsji  test1  
Newest Paradox group members:  1. Stan   (7 visits. USA) 2. adam59  (2 visits. PARMA, OH USA) 3. simd01  (5 visits. Terrigal USA) 4. tsensor   (7 visits. Union, NJ USA) 5. info3  (2 visits. St Austell USA)

Not a member of this group? Join Now!

Corel Paradox Group

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!

This group is hosted by Mike Prestwood (author of several Paradox books). If you need professional Paradox help, consider us. Visit our Paradox Outsourcing Info page for more information. If your curious about the future of Paradox, check out The Future of Paradox Blog.

Paradox 9 Developer's Edition


This group is THE online resource for learning and keeping up with Paradox.



This page lists NEW and UPDATED Corel Paradox content from all areas (news, message board, knowledge base, blogs, comments, FAQ lists, file library, resumes, job postings, etc.). In addition, this page contains weekly content posted each Monday at 1 AM from our tib-bits (smaller KB posts).

Paradox News

5/15/2008
WPO X4 Ships! Paradox Still Does Not Support Vista!
According to current information on the official Corel X4 home page, WPO X4 ships with Paradox 11 SP2 and still does not support Vista. Yet.

2/23/2008
WordPerfect Office X3 Service Pack 2
Service Pack 2 is now available for WordPerfect Office X3.

1/17/2006
Corel Ships Paradox with WordPerfect Office X3 Pro!
Paradox 11 with SP2 already applied shipped as part of the WPO X3 Pro Edition.

2/14/2003
Workbench 1.5 for Paradox 10 Ships!
Add 50+ options to Paradox 4.5, 5, 7 (32-bit), 8, 9, AND 10!

11/26/2002
Prestwood Helps in Conversion of Haney Accountants Inc. Assessment Collection Software
Haney employs Prestwood paradox expertise in application upgrade.


Our Paradox News List | Post Your News

Weekly Paradox Content!

Week 33, Posted Monday 8/18/2008

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

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.

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.

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.
Link of the Week
Corel WordPerfect X3 Pro Home Page
Code Snippet of the Week
What does this code do?

sqlQuery =
SQL
;execute proc here
ENDSQL


if not dbSQL.executeSQL(sqlQuery, tcAnswer) then
errorShow()
endIf

File of the Week
Playing Sounds in 32-bit versions of Paradox
This download demonstrates playing sounds in 32-bit versions of Paradox (Paradox 7 32-bit and above).

Paradox Board Overview Q&A!

Techie talk! Post your Q&A to our Paradox board. Our custom built message board uses a traditional Q&A message board format you can browse, search, post new topics, and reply to existing topics.
 TopicThreadsPostsLast Active ThreadLast By
Sign In To Check If Stuff Is New Paradox Setup, Vista, etc.1811061
RE: Error: attempt to acces...
by dfought
Sign In To Check If Stuff Is New Paradox Tables34228
RE: px file gets dropped wh...
by David_Florer
Sign In To Check If Stuff Is New Paradox Forms3111223
RE: How? Windows Calendar i...
by S 0 n Y
Sign In To Check If Stuff Is New Paradox Reports1674
RE: Reports from laptops ca...
by vinylsol
Sign In To Check If Stuff Is New QBE & SQL22113
RE: QBE Specifications...
by Alexandre_Roitm
Sign In To Check If Stuff Is New Application Framework1140
Print report from App Frame...
by jondm
Sign In To Check If Stuff Is New ObjectPAL7683171
RE: how to display a table ...
by staff
Sign In To Check If Stuff Is New Paradox for Linux1051
Free Paradox for Linux Book...
by mprestwood
Sign In To Check If Stuff Is New Paradox Third Party Books &...944
New Paradox User...
by FlaglerMuseum
Sign In To Check If Stuff Is New Paradox Third Party Softwar...2259
RE: Configure, open and rea...
by pronegot
Sign In To Check If Stuff Is New Paradox to/from Other Data ...57202
RE: SQL Server Access via B...
by greens
Sign In To Check If Stuff Is New Paradox Web Stuff42252
RE: Paradox 9 ODBC Driver...
by mprestwood
Sign In To Check If Stuff Is New Paradox Graphs & Charts1043
Charts and Graphs probs...
by jondm
Sign In To Check If Stuff Is New Paradox Runtime & Distribution34140
RE: Runtime - 9 Install...
by mprestwood
Sign In To Check If Stuff Is New Convert To/From Paradox1032
Paradox 11 app conversion...
by manuzzin
Sign In To Check If Stuff Is New Paradox for DOS745
RE: Paradox DOS 4.5...
by mprestwood

New Paradox MB Posts

 Thread
Started By Replies
 Last Post TopicViews
Sign In To Check If Stuff Is New QBE Specifications
Posted Tue@07:32 EST, Updated Wed@11:04 EST
alexrtmn10 RE: QBE Spe...
Posted Wed@10:58 EST
by Alexandre_Roitm
QBE & SQL44
Sign In To Check If Stuff Is New SQL Server Access via BDE for Paradox
Posted Sun@17:36 EST, Updated Tue@18:02 EST
simd013 RE: SQL Ser...
Posted Tue@18:01 EST
by greens
Paradox to/from Other Data Sources37
Sign In To Check If Stuff Is New sqlserver2005 / Paradox 9.0 connection
Posted 8/6/2008, Updated Tue@15:49 EST
bt1 RE: sqlserv...
Posted Tue@15:46 EST
by greens
Paradox to/from Other Data Sources77
Sign In To Check If Stuff Is New Setting up an alias in BDE for SQL Server 2005
Posted 8/4/2008, Updated 8/6/2008
simd012 RE: Setting...
Posted 8/6/2008
by simd01
Paradox to/from Other Data Sources101
Sign In To Check If Stuff Is New how to display a table AND use it for queries
Posted 7/28/2008, Updated 7/29/2008
peorthyr2 RE: how to ...
Posted 7/29/2008
by staff
ObjectPAL127
Sign In To Check If Stuff Is New Error: attempt to access unknown file past its end
Posted 7/23/2008, Updated 7/23/2008
Hoosier Boy1 RE: Error: ...
Posted 7/23/2008
by dfought
Paradox Setup, Vista, etc.155
Sign In To Check If Stuff Is New psSendMail + Pdox v9 + Vista
Posted 7/21/2008, Updated 7/21/2008
Martin Evans1 RE: psSendM...
Posted 7/21/2008
by dfought
Paradox Setup, Vista, etc.185
Sign In To Check If Stuff Is New Email hanging
Posted 7/17/2008, Updated 7/18/2008
frumiami 1 RE: Email h...
Posted 7/18/2008
by mprestwood
ObjectPAL184
Sign In To Check If Stuff Is New No PDox 9 so may have to buy 11+
Posted 7/16/2008, Updated 7/17/2008
Emailparadox4 RE: No PDox...
Posted 7/17/2008
by mprestwood
Paradox Setup, Vista, etc.212
Sign In To Check If Stuff Is New access violation error
Posted 7/16/2008, Updated 7/16/2008
gcasper0New ThreadParadox Setup, Vista, etc.128

New Stuff Since Your Last Visit=New or Updated, Not New Since Your Last Visit=Not new.

New Thread Notifications

New thread subscribers: ANDRESJ    ASPGuy   bt   f00768500   geichenblatt    H. Tadema    jn316sc   joeroark    josephpnorris   leslie2   Mike Prestwood   MRBOB    Philip G Graham   philiptdotcom    pronegot   psantoro    RalphG   SAJJADS    themadhatter1    tsensor   

Want to subscribe? Sign in to subscribe to new threads posted to this group.

New Paradox Knowledge Base Articles

    KB Article By KB Topic Counters
Sign In To Check If Stuff Is New
Post

1. Paradox Runtime Limitations

Listing of Paradox features NOT available in Paradox Runtime.
  +Add Comment (0 Comments )
Mike Prestwood
Runtime, PDE, Package-It! All: 264
Members: 4
Non-Mem: 258
Mods: 0
Clients: 0
Staff: 2
Sign In To Check If Stuff Is New
Definition
Flashcard

2. Data Model

Short Definition: A data model is a diagram of the tables used in a form or report. It identifies the tables, defines the relationships between them (links), and has features including the ability to filter each table and mark any table as read-only. You can save a data model (.dm) and reuse it with another form or report.
  +Add Comment (0 Comments )
Mike Prestwood
2-Interactive Paradox: Getting Going All: 210
Members: 3
Non-Mem: 207
Mods: 0
Clients: 0
Staff: 0
Sign In To Check If Stuff Is New
Definition
Flashcard

3. Camel Casing

Short Definition: Camel Casing capitalizes the first character of each word except the first word, so it frequently looks like a one or two hump camel. Used by many languages including Paradox's ObjectPAL. You can contrast Camel Casing with Pascal Casing which capitalizes the first character of each word (including acronyms over two letters in length) and was popularized by Pascal.
  +Add Comment (0 Comments )
Mike Prestwood
Getting Started with OPAL All: 203
Members: 0
Non-Mem: 203
Mods: 0
Clients: 0
Staff: 0
Sign In To Check If Stuff Is New
FAQ
Flashcard

4. Import Excel 2003, XP, 2007 into Corel Paradox

Question: How do I import an Excel 2003, XP, or 2007 spreadsheet?
  +Add Comment (0 Comments )
Mike Prestwood
3-Interactive Paradox: Using Data All: 213
Members: 0
Non-Mem: 213
Mods: 0
Clients: 0
Staff: 0
Sign In To Check If Stuff Is New
Tip

5. Table Lookups and Directory Paths (more than 8 characters)

Tip: Lookup tables for Paradox table level 5 or lower are limited to 8 characters. If you use lookup tables in other directories, upgrade all tables involved to the Paradox table level 7. You can do this with Table Repair or by defining a level 7 feature (for example, a descending index).
  +Add Comment (0 Comments )
Mike Prestwood
4-Paradox Tables All: 241
Members: 0
Non-Mem: 241
Mods: 0
Clients: 0
Staff: 0

Updated Paradox Knowledge Base Articles

    KB Article By KB Topic Counters
Sign In To Check If Stuff Is New
Download

1. psSendMail DLL

Easily send e-mail directly from your custom applications. Works with all 32-bit Windows development environments and includes Paradox, Access, and Visual Basic examples.
  +Add Comment (1 Comments  last by martin2 )
Mike Prestwood
ObjectPAL Coding All: 437
Members: 6
Non-Mem: 431
Mods: 0
Clients: 0
Staff: 0
Sign In To Check If Stuff Is New
Article

2. Paradox and the Internet

Using Paradox internet features. Content from chapter 25 of my "Paradox Power Programming: The Official Guide" book.
  +Add Comment (2 Comments  last by mprestwood )
Mike Prestwood
OPAL: Coding Tasks All: 1008
Members: 28
Non-Mem: 977
Mods: 0
Clients: 1
Staff: 2
Sign In To Check If Stuff Is New
Article

3. Introduction to OO for the Paradox Community

Compromise OO implementation strategies for Paradox developers.
  +Add Comment (4 Comments  last by mprestwood )
Mike Prestwood
OPAL: Wicked Coding Tasks All: 892
Members: 9
Non-Mem: 875
Mods: 3
Clients: 0
Staff: 1
Sign In To Check If Stuff Is New
Code

4. Assocative Arrays in ObjectPAL

An associative array links a set of unique values (keys) to another set of values (not necessarily unique). In ObjectPAL associative arrays are known as dynamic arrays.

  +Add Comment (0 Comments )
Mike Prestwood
Paradox & ObjectPAL All: 322
Members: 4
Non-Mem: 311
Mods: 4
Clients: 1
Staff: 2
Sign In To Check If Stuff Is New
Article

5. A 10 Minute Paradox Reports Quick Start

Creating reports in Paradox. The purpose of this article is to walk you through the main features of Paradox's report designer starting with a quick report.
  +Add Comment (0 Comments )
Mike Prestwood
3-Interactive Paradox: Reports All: 352
Members: 15
Non-Mem: 336
Mods: 0
Clients: 0
Staff: 1

New Paradox KB Comments/Entries

Steve Green
Diamond Software Group, Inc.
Send greens a Private Message Visit greens's Home Page
Rank: Cadet 4th Year

Joined: May 2008
MB Posts: 17

KB Articles: 0

Location: Myrtle Beach, SC USA
Tuesday, August 19, 2008 Read | +Add Comment

you must delete the toolbar files.. see details on Bertil's web site..

http://hem.bredband.net/bertilisberg/paradox/errdocs2/eid230.htm



Regarding...
Install Paradox 9 on Vista
Instructions to install Paradox 9 for Windows on Vista.

j.malcolmson
APR
Send j.malcolmson a Private Message Visit j.malcolmson's Home Page
Rank: Cadet 3rd Year

Joined: Mar 2004
MB Articles: 0

KB Articles: 0

Location: Burnaby, BC CA
Tuesday, August 19, 2008 Read | +Add Comment

Has anyone gotten the following dialogue when opening Paradox 9 in Vista?

"An attempt was made to access an unmanned file past its end."

After clicking Ok, the program starts and runs in a fairly stable manner.  When I tried installing higher versions of Paradox in Vista (like the one from the X3 package), the same message comes up and blocks the program from running at all.

John Malcolmson, Burnaby, BC

 



Regarding...
Install Paradox 9 on Vista
Instructions to install Paradox 9 for Windows on Vista.

Mike Prestwood
Prestwood Software
Send mprestwood a Private Message Visit mprestwood's Home Page
PS Staff
Moderator
Rank: Fleet Admiral

Joined: Oct 2000
Visits: 21411
MB Posts: 980

KB Articles: 872

Location: Citrus Heights, CA USA
Monday, August 04, 2008 Read | +Add Comment

Refer to the section titled "Defeat Vista's Application Virtualization" in the Paradox 9 on Vista article. That should help.



Regarding...
Corel Paradox for Windows on Vista
Does Corel Paradox for Windows run on Vista? If so, are there any issues?

grantr
Send grantr a Private Message Visit grantr's Home Page
Rank: Cadet 3rd Year

Joined: Apr 2003
MB Articles: 0

KB Articles: 0

Location: CA
Friday, August 01, 2008 Read | +Add Comment

Installed Pdox 7/32 on VHP yesterday.. Ran into errors, and just blanket changed permissions on directories to get running.. Today installing Ultimate32 and will try domain connection and idapi.. hopin it works.. works on every OS to date :)

 

Grant



Regarding...
Corel Paradox for Windows on Vista
Does Corel Paradox for Windows run on Vista? If so, are there any issues?

Martin Evans
Arenig Ltd
Send martin2 a Private Message Visit martin2's Home Page
Rank: Cadet 3rd Year

Joined: Jul 2008
MB Posts: 1

KB Articles: 0

Location: Betws Gwerfil Goch UK
Monday, July 21, 2008 Read | +Add Comment

Hi, I've just downloaded your trial version of psSendMail to run with Paradox 9.  It appears to work fine and be just what I need - EXCEPT.  When I run it on a Vista machine and send HTML emails, it just seems to send plain text.  Yes, I do have the HTML flag set to True - works great with XP.

Your help appreciated.

Regards

Martin Evans



Regarding...
psSendMail DLL
Easily send e-mail directly from your custom applications. Works with all 32-bit Windows development environments and includes Paradox, Access, and Visual Basic examples.

Paradox Blogs

Latest Blogs
    KB Article By KB Topic Counters
Sign In To Check If Stuff Is New
Blog

1. The Future of Paradox Blog

If you're still using Paradox for any of your business database applications, you need to put a plan together now for converting to another development tool or at least understand what the future is likely to hold. If you're a power-user or researcher working with data, stick with Paradox at least for now.
  +Add Blog Entry (21 Entries  last by mprestwood )
Mike Prestwood
0-Paradox Presales & Info All: 4036
Members: 34
Non-Mem: 3993
Mods: 4
Clients: 3
Staff: 2
Sign In To Check If Stuff Is New
Blog

2. Is Paradox a good Internet solution?

My thoughts on whether Paradox for Windows is a good solution for building web-based Internet solutions.
  +Add Blog Entry (3 Entries  last by mprestwood )
Mike Prestwood
0-Paradox Presales & Info All: 1031
Members: 9
Non-Mem: 1016
Mods: 1
Clients: 1
Staff: 3

Recruiters and Employers

Prestwood Staffing Options
To receive an email notification when a new resume is posted to this group, you must post at least one job posting and specify this group as one of your 3 job posting groups. When there is a reasonable match, either the applicant is near your location, your willing to pay for relocation and/or the applicant is willing to relocate, or remote work is a possibility, our system will automatically notify you.

Employer Overview

 

Featured Paradox Job Posting

Receive New Job Postings? To receive an email notification when a new job posting is posted to this group, you must post your resume and specify this group as one of your 3 resume groups. When there is a reasonable match, either the job is near your location or remote work is a possibility, our system will automatically notify you.

1 Job Postings...

1.  View Job Posting Job #24: Paradox / ObjectPAL Developer Prestwood Software salaried position, core developer position, or ongoing remote-okay hourly work.
ObjectPAL programming for Prestwood Software clients. Also, includes in-house programming for our products. Work closely with Mike Prestwood, author of 6 programming books. Remote work possible for the right ObjectPAL developer.

Skills: Paradox, ObjectPAL
Area Code: 916
Physical Location: Citrus Heights, CA USA

Ad Dates: 7/10/2007 thru 1/31/2008
Within 6 Months @Prestwood Ongoing Part-time Emp.Pref./Corp Okay

Paradox Outsourcing

We can turn your software and website ideas into reality!

Includes building new software and larger maintenance such as adding more than a few features.

Paradox Support Account

Use your support account for code audits, to get developer help, complete projects and for maintenance type work.

Training and Mentoring

You can also use a support account to work one on one with one of our Paradox developers. Learn from a real Paradox developer.

 

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.

Paradox Stuff 4 Sale
Purchase any of our products or services online. You can even open a support account and pre-pay for support hours at a discount!

 

About New Paradox Applications
Paradox is a great application development tool and may be the right tool for your next project. However, you need to be sure to use the right tool for the right job. There are things you should consider BEFORE choosing ANY application development tool. Call us today for a FREE consultation with Mike Prestwood to discuss your project and tool selection. Mike Prestwood is our President & CEO, and author of six Paradox books.

Paradox Application Conversions
If you're looking to convert your existing Paradox application to a leading technology, there is no one in the world better equipped than Prestwood.

About Paradox Maintenance Programming
Our position on legacy systems written in Paradox is that if you don't have the budget for a conversion to a leading technology, then leave the application in the tool it is in now. The problem is finding programmers that can program in that tool. Luckily, Prestwood can fulfill your legacy programming needs. We can add that needed feature or remove that annoying bug. We can even upgrade you to version 10 (the most current version). To get started, open a support account.