I.T. Discussion Community!
-Collapse +Expand
Search Paradox Group:

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

Prestwood eMagazine

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

   ► KBDesktop Data...Paradox & Ob...ObjectPAL Co...   Print This     
Paradox ObjectPAL Coding:
A Customized Software Glitch That Was Not
Posted 6 months ago on 10/23/2018
Take Away:

This article discusses what seemed to initially be a Corel Paradox programming glitch in objectPAL language that was actually something completely different.


I recently received a call from a longtime customer today. She said they could not import a Microsoft Excel spreadsheet into a Corel Paradox data table that is used for their GSA pricing (government discount pricing). This is very simple objectPAL software that is activated by clicking a pushbutton. It is detailed below. Note that the network drive letter, Paradox alias name and file folder names have been changed for privacy.

method pushButton(var eventInfo Event)


                itemNameSQL       SQL

                db                Database



db.open (":GENERIC:")

itemNameSQL =


Delete from ":GENERIC:gsa_price.db"


executeSQL(db, itemNameSQL, ":GENERIC:gsa_price.db")

importSpreadsheet ( "x:\\generic_folder\\gsa_price.xls", ":GENERIC:gsa_price.db","A:A1", "A:H5000", True )



This custom app does two things. First, it uses Corel Paradox objectPAL SQL code to empty out all the records in the ":GENERIC:gsa_price.db" data table. Next, it uses the Paradox directive, importSpreadsheet ( "x:\\generic_folder\\gsa_price.xls", ":GENERIC:gsa_price.db","A:A1", "A:H5000", True ), to import the Excel spreadsheet into the empty Paradox data table from before.

The programming code seems simple enough and it actually is. However, on the girl’s computer she was using the software bugged out and shut down Corel Paradox and Microsoft Windows. This would appear to be a programming defect in the code itself. Suspicious as to why this relatively simple program would crash, I asked the employee to run it on the computer I work at. I requested this because it worked fine on my PC when I was there last time. And sure enough, it executed flawlessly on mine again after she ran it.

Like life, things are not always as they seem in the software design world. A programming glitch that appeared to exist, but was only a mirage. The real culprit was the Microsoft Windows installation on this employee’s computer or the computer architecture or some application that was loading up and running resident in the machine. I never found out exactly what the problem was, but I knew by process of elimination that it was not the Corel Paradox programming code.


Share a thought or comment...
Write a Comment...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.

Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P1196A1
Enter key:
Article Contributed By Douglas.M:

Please visit my software developer website for more information about my services. I offer application development as well as Android app coding services. My developer skills are best suited to dealing with custom software projects. I can perform programming for Corel Paradox as well as C# Sharp and PHP.

In my local area of northeast Ohio, I can cater to computer repair and "fix my computer" issues.

Use my contact web page today to reach me about any software design ideas you have.

Visit Profile

 KB Article #103851 Counter
Since 10/23/2018
   Contact Us!
PrestwoodBoards.com was developed and is maintainted by me. Do you have a question or suggestion? Do you see a problem? Contact me now. My goal is to build an ad-free and spam-free source of I.T. information with many contributers (ok to promote your website/company in your bio). Yes, my company Prestwood IT Solutions is mentioned in my bio which shows with every post, but you can contribute and promote your pet project too!

2,803 People Online Now!!  
Sign In to see who's online now!  Not a member? Join now. It's free!
Show more stats...

©1995-2019 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech