Your full service technology partner! 
-Collapse +Expand
Search Paradox Group:

-Collapse +Expand Paradox To/From
-Collapse +Expand Paradox Store

Prestwood eMagazine

September Edition
Subscribe now! It's Free!
Enter your email:

   ► eMag   Print This    All Groups  
View Group Edition:
Full Edition Your Edition || Prev Next || Subscription Center

Prestwood IT Newsletter Feb 2008 Issue - Paradox Edition


Start subscribing now! It's free!

Each month on or after the 1st, and only once a month, we will send you content from up to 5 community groups. If you select this Paradox group, you'll receive the following content below mixed in with the other groups you elect to include.

Prestwood eMag
Our monthly opt-in coupons+newsletter.
  February 2008 - Paradox Edition (1699 of 4,788 subscribers receive this group's content.) Year 10 Issue 2  
Your full service technology partner!
From The Editor
Mike Prestwood

In addition to bringing you the usual combination of group specific information, this issue focuses a bit on virtualization. Whether you're a client or developer using Windows Vista or another OS, virtualization is an interesting subject you should know about so you can leverage resources.

About Windows Virtualization
The act of isolating or unbinding one computing resource from another. Windows virtualization adds virtualization services to the core Windows operating system at a fundamental level. Windows virtualization takes advantage of virtualization assistance in hardware based on Intel Virtualization Technology and AMD "Pacifica." Virtualization enables workloads such as server consolidation, efficient software development and testing, resource management for dynamic data centers, application re-hosting and compatibility, and high-availability partitions.

Here are the categories of Windows Virtualization:

  • Application Virtualization 
  • Desktop Virtualization
  • Server Virtualization
  • Storage Virtualization
  • Network Virtualization

Application Virtualization
Introduced with Vista, creates application-specific copies of all shared resources. It separates the application configuration layer from the OS making deployment easier in some cases.

In addition to reading our feature article, here is a good link to start with...

Expert guidance from working professionals!
Wes Peterson
Desktop Databases topic:
Application Virtualization: The Good, the Bad, the Ugly
by Wes Peterson

Virtualization is a concept greatly expanded in Vista. This article discusses the impact of Application Virtualization on you development. It can have a huge impact on how the programs you write will behave when installed on Vista.

Removable Storage Technology topic (classic post):
Removable Disks - a brief overview & history
by Wes Peterson
Wherever would we be without portable, inexpensive removable media? From the old, eight-inch floppy, to the latest Blue Ray DVD format, little spinning disks have provided computer users with convient, off-line storage. This is a brief overview and history of the various disk formats that have come, gone, and are - for the moment - sticking around.

Coding Services topic (classic post):
Software Testing? We Do That!
by Wes Peterson
Everything about our web site makes it pretty clear that we specialize in custom application development. Less frequently mentioned is another service we provide: Professional software testing. Software testing is a discipline unto itself. It's certainly related to development, but developers aren't the best testers. That's why Prestwood retains highly experienced, professional software testers. This is a service we make available - whether or not we're involved in a product's actual development. This article provides more details about this service.

Desktop Databases topic (classic post):
MSI Installers: Whats Up with These?
by Wes Peterson
For a while, now, Windows has supported a new mechanism for installing applications: MSI. This is quite a bit different than the familiar setup.exe, and here we begin exploring the differences - and the significance of MIS installations.

General News & Trends topic (classic post):
Microsoft Trying to Buy Yahoo

MS wants Yahoo. What about MSN? Will Yahoo survive?

Role-Based Tech Talk topic:
Crash, Bomb, Hang, and Deadlock
by Scott Wehrly
This article explores and defines the following terms: crash, bomb, hang, deadlock, exception, fatal error, and blue screen of death.

 Paradox Group Top 
Visit Group | My Group Settings
Professional Paradox/ObjectPAL Help topic (classic post):
About Paradox Maintenance Programming
by Mike Prestwood
Should you continue supporting your Paradox legacy applications?

P9 Book: Power Programming topic (classic post):
Power: Chapter 02, Tables and Developing
by Mike Prestwood
Chapter 2 "Tables and Developing" from Paradox 9 Power Programming: The Official Guide by Mike Prestwood.

 Monthly Paradox Lesson
OPAL: Wicked Coding Tasks Topic:
Code Snippet of the Month

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 =
;execute proc here

if not dbSQL.executeSQL(sqlQuery, tcAnswer) then
Interactive Paradox: Using Data Topic:
Definition of the Month: Paradox Database
A Paradox Database is a set of related Paradox tables (usually in the same directory).

A database is an organized collection of information. For Paradox table users, the meaning of the term Paradox Database is stretched to mean a set of related Paradox tables (usually in the same directory).

Paradox & ObjectPAL Topic:
Resource Link of the Month: Corel WordPerfect X3 Pro Home Page

Paradox 11 with SP2 applied ships with WordPerfect Office X3 Professional Edition. There are two ways to get the current Paradox, buy the WPO Pro Edition (X2, X3, etc.) or buy a license directly from Corel.

System requirements

Windows® Vista (Home Basic, Home Premium, Ultimate, Business 32 bit and Business 64 bit Edition with latest SP and Critical Updates)*, Windows® XP (Home, Media or Professional Edition with latest SP and Critical Updates), Windows® 2000 (with latest Critical Updates) or Windows® 98 SE (with latest Critical Updates)
128 MB RAM (256 MB recommended)
466 MHZ (Pentium® III or equivalent processor recommended)
450 MB hard disk space for minimum installation
Super VGA, 16-bit color monitor with 800 x 600 or greater resolution
CD-ROM drive
Mouse or Tablet

*Paradox and the SDK (software development kit), included in the Professional Edition, will be updated for Windows® Vista at a later date.

Installation, Setup, & BDE Topic:

I recently upgraded to Windows XP and now Paradox 11 cannot open SQL Server database tables. In the open-dialog-box, I see the aliases, but cannot select one which is linked to a SQL server database. The same thing happens, trying to create a QBE query, new form, etc... All existing queries, forms, ... are working (using these aliases).


Solution was to apply the latest BDE patch, all works as it should.

Runtime, PDE, Package-It! Topic:
Tip of the Month

Whenever you open a form, report, library, or script using the open() method and do not specify a file extension, Paradox always looks first for the nondelivered .?SL file and then for the delivered .?DL file.

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

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