I.T. Discussion Community!
-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:

   ► KBDesktop Data...Paradox & Ob...ObjectPAL Co...   Print This    All Groups  
Paradox ObjectPAL Coding:
A Customized Software Glitch That Was Not
Posted 23 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...
Comment 1 of 3

The guitar has different features and if you looking to play something on guitar so you have to learn it first. The papercoach has a complete course that you can watch completely and try to understand how it works.

Posted 8 months ago

Comment 2 of 3

Good day guys! Do you need to do an essay and you do not have time to do that?! So, I know only one cool www.essay-company.com/ company that can help you with your writing problems and the assignments will be ready at the right time for you. They promise the highest level of writing and confidentiality. I am using their online services for a long time and I am sure for 100%, that you will be satisfied with your paper tasks.

Posted 5 months ago

Comment 3 of 3

Stop worrying about grades and deadlines. Choose PayMeToDoYourHomework writing service and order paper round the clock. 


Posted 4 months ago
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 = P1271A1
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

Follow PrestwoodBoards on: 

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