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

Advanced
-Collapse +Expand Paradox To/From
To/FromCODEGuides
-Collapse +Expand Paradox Store
PRESTWOODSTORE

Prestwood eMagazine

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

   ► KBParadox Knowledge Base  Print This    All Groups  

Paradox FAQ Page

These FAQs are contributed by you (our online community members). They are organized by our knowledge base topics. Specifically, by the Paradox sub-topics.

Contribute a FAQ
Expand All

20 Corel Paradox / ObjectPAL Coding FAQs

Group: Corel Paradox / ObjectPAL Coding


Topic: Paradox & ObjectPAL

-Collapse +Expand Q1. Currently using Pdx 11.0.0.302 on laptop with Win7 64 bit, no problems with essentially interactive use for year past.  Now have need for access to Pdx tables by ODBC. Have installed drivers supplied on the Pdx 9 install disk but the drivers do not show up on the Drivers tab of the ODBC Administrator window. In past, have successfully installed drivers ex Pdx 9 cd with same Pdx 11 set up on machines running Win XP. Except this time used a backup cd copy of the original installation disk. Made 2 attempts, first prompted for licence code, entered and it ran. The driver files have copied to the default location as prompted by the setup procedure. Also accepted default installation path for Pdx 11.
 
Answer:
Posted By paulh, Post #102496, KB Topic: Paradox & ObjectPAL



Topic: Tool Basics

-Collapse +Expand Q2. I wanted to check out if there was a 64 bit Paradox for Windows. I believe this database tool is excellent especially in defining a database.
 
Answer:

No 64-bit version of Paradox for Windows. Just the current 32-bit version and the older 16-bit version. However, 64-bit versions of Windows can run 32-bit programs very well. If you're running Vista 64-bit, you may wish to stick with Paradox 9 but Vista isn't a good OS for older programs. Interestingly enough, Paradox 9, 10, and 11 run fairly well on Windows 7 which means you can keep using your Paradox applications long into the future (just skip Vista).

Posted By Mike Prestwood, Post #101303, KB Topic: Tool Basics
-Collapse +Expand Q3. Does Paradox X4 have any new features over X3?
 
Answer:

No, Paradox X4 (version 14) is Paradox 11 with SP2 applied (build 11.0.0.411). There is no version 12, 13, or 14. In fact, no new features since version 10. Version 11 does have some significant bug fixes though and SP2 has even more fixes. Also, there are lots of rumors that Corel will release a patch for Paradox 11 soon that will address the Vista problems many users are struggling with.

Posted By Mike Prestwood, Post #101067, KB Topic: Tool Basics
-Collapse +Expand Q4. How can I purchase Paradox?
 
Answer:

Answer from Corel...

Paradox was not updated from Paradox 10. It was given a new look, but the functionality remains mainly the same. Paradox 11 is available in the WordPerfect Office Professional version and can be purchased through Corel's online store or by calling us [Corel].  Paradox is also available as a standalone if you already own WordPerfect Office, and is [available] through our licensing program.  Within North America, please call 1-800-772-6735, Corel's Customer Support Services, to purchase the Paradox upgrade. We are open from Monday - Friday, 9:00 am - 7:00 pm E.S.T. and would be happy to serve you. For customers outside of North America, please visit www.corel.com/contact to locate a Corel Customer Support Services Center nearest you.

Posted By Mike Prestwood, Post #100870, KB Topic: Tool Basics
-Collapse +Expand Q5. Whats new in Paradox 13? My Paradox Version is 9 Developer. Is it right what Paradox 9 forms are not compatible with Paradox 13? Is there anything else happens?
 
Answer:

[answered by Mike Prestwood] Paradox version 11 shipped with WPO X2 and Paradox 11 with SP2 ships with WPO X3 and WPO X4. Paradox 11 is essentially the same as Paradox 10 with NO NEW features (minor defects and compatibility issues were resolved). There is no Paradox 12, 13, or 14. Currently Corel states that Paradox is in maintenance mode (meaning no new features are planned).

As for your Paradox 9 forms, you can simply resave them and/or redeliver them in the new version. If you used the Application Framework in 9, it's not in 10 nor 11 so you have some work to do.

Posted By count-dowm , Post #100705, KB Topic: Tool Basics



Topic: Installation, Setup, & BDE

-Collapse +Expand Q6. Does Corel Paradox for Windows run on Vista? If so, are there any issues? What about Windows 7?
 
Answer:

Paradox 9, 10, and 11 run well on Windows 7, so skip Vista. Paradox 9 does run on Vista (not well, but you can do it) and Paradox 10 and above do run but there are some issues to keep an eye out here for detailed notes. If you have an earlier version, it will run on Vista but we do recommend you upgrade to Paradox 9 or Paradox Runtime. Refer to the links on this FAQ for complete and detailed instructions.

All the latest versions of Paradox run very well on Windows 7 including Paradox 9, 10, and 11. We are currently recommended to our clients that they skip Vista.

Posted By Mike Prestwood, Post #100449, KB Topic: Installation, Setup, & BDE
-Collapse +Expand Q7. I have recently started learning to work with Paradox 9 and have found your book Paradox 9 power programing extremely helpful. I have encountered a problem and hope that you will be kind enough to assist. The problem has occured twice now so I don't think it is a finger problem. When I nearly reach a stage of completion, on opening the program it goes into tile mode, a few seconds later the program tell me to abort (Corel Paradox crashes on startup). Should you be able to give me any assistance I would be most appreciative.
 
Answer:

Using Paradox 9 on XP with CorelDraw or any other programs is fine. No problem there. Not sure what the issue is though. You might want to try starting Paradox with a clear desktop using the -c command line option. You can search the help file for command line options for usage. If that isn't the problem, then you must have a bad installation of Paradox (try reinstalling) or some other program is causing it to crash (doubtfull with XP memory management).

Posted By Mike Prestwood, Post #100256, KB Topic: Installation, Setup, & BDE
-Collapse +Expand Q8. 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).
 
Answer:

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

Posted By Mike Prestwood, Post #100436, KB Topic: Installation, Setup, & BDE
-Collapse +Expand Q9. Paradox does not remember desktop settings. I just installed Paradox 11 on a new computer and my working directory and other settings do not stick when I restart Paradox. Why?
 
Answer:

Paradox 11 installs a registry cleaner (PdxRegCl) and that is the culprit. The quick fix is to delete the PdxRegCl.exe file in the Paradox folder. For a more complete "cleanup", delete the PdxRegCl.ini file and any PdxRegCl registry entries you find.

Posted By Mike Prestwood, Post #101574, KB Topic: Installation, Setup, & BDE



Topic: Paradox Tables

-Collapse +Expand Q10. What is the best way to copy my Paradox tables?
 
Answer:

What I recommend for our clients is to make sure no one is using the tables and then copy the entire folder. To make sure no-one is using the tables, check for .LCK lock files. If they exist, try deleting them. If you can delete them, then they were left over from an abandoned BDE session. Next, rename the folder to lock out users for the duration of the copy. Copy the folder, then rename the folder back.

To copy live tables, I suggest you write an application in Paradox, Delphi, etc. that uses the BDE copy table code. It's safe, effective, and you can build in error checking.

Posted By Mike Prestwood, Post #101177, KB Topic: Paradox Tables
-Collapse +Expand Q11. 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.

Posted By Mike Prestwood, Post #100028, KB Topic: Paradox Tables



Topic: Interactive Paradox: Using Data

-Collapse +Expand Q12. How do I import an Excel 2003, XP, or 2007 spreadsheet?
 
Answer:

Corel Paradox 9, 10, and 11+ can import Excel spreadsheets up through Excel 97 so you need to save the spreadsheet as an Excel 97 spreadsheet. Then you can import it in Paradox using either the interactive File | Import option or with ObjectPAL's importSpreadsheet procedure.

If you have trouble with then Excel 97 file format (and you may depending on the version of Excel you are using), try saving the file as an Excel 4 file format. The worst case scenario, is that you may have to save the file as a dBASE table file format (.DBF) which you can directly use in Paradox and even copy it to a Paradox table (.DB).

Posted By Mike Prestwood, Post #101227, KB Topic: Interactive Paradox: Using Data
-Collapse +Expand Q13. Does Paradox for Windows support .PNG image files?
 
Answer:

Yes, Paradox 10 and 11 support .PNG graphics. For example, you can insert a .PNG using Edit | Paste From. However, Paradox 9 and earlier do not.

Note: All images stored in a Graphic field in Paradox tables are stored as uncompressed BMP images. This FAQ is about Paradox for Windows' ability to paste or import .PNG images into the .BMP formatted Graphic field type. For earlier versions of Paradox, you have to first convert the image.

Posted By Mike Prestwood, Post #102054, KB Topic: Interactive Paradox: Using Data



Topic: OPAL: Wicked Coding Tasks

-Collapse +Expand Q14. Does Paradox for Windows support TWAIN?
 
Answer:

Yes, interactive support was added with Paradox 9 SP1 and ObjectPAL support was added with Paradox 10. Here's a good article for Paradox and TWAIN:

http://www.techtricks.com/paradox/twain/part1.php

Posted By Mike Prestwood, Post #102067, KB Topic: OPAL: Wicked Coding Tasks



Topic: OPAL: Win32 Calls

-Collapse +Expand Q15. I'm making a DLL Call and I need to pass a logical, I tried passing an ObjectPAL logical data type and that didn't work. How do I pass a logical to a function in a DLL?
 
Answer:

With DLLs you are limited to the DLL Uses types of CWORD, CLONG, CDOUBLE, CLONGDOUBLE, CPTR, and CHANDLE. All other parameter types must be mapped to one of these fundamental data types. Because logicals are really just null, 0, or 1, you can use a CWORD which maps to ObjectPAL's SmallInt data type (an integer).

Posted By Mike Prestwood, Post #101942, KB Topic: OPAL: Win32 Calls



Topic: Professional Paradox/ObjectPAL Help

-Collapse +Expand Q16. I like the concept and feature-set of Paradox, but wonder if it can handle very large transactions and storage?
 
Answer:

We like Paradox's feature set too but it's not the right tool for every situation. For very large transactions and storage, we prefer a true SQL server over ALL file-based databases including over Paradox. Although we judge and discuss the viability of toolsets for each project, we do have standards we steer our clients toward. For example, we steer our Paradox-oriented large transaction/large storage needs clients toward SQL Server 2005 with either VS.Net as a front-end or Delphi (for a true native code solution).

Posted By Mike Prestwood, Post #101304, KB Topic: Professional Paradox/ObjectPAL Help



Topic: Runtime, PDE, Package-It!

-Collapse +Expand Q17. My company has a Paradox application. Can I turn it into a true Windows application? A true Win-32 executable?
 
Answer:

No. To deploy your Paradox application, you can use either the full version of Paradox or the runtime version. The runtime version is almost as big as the full version but it's been free since version 9. If you deploy using the full version of Paradox, you need a license for each user. You can order a multi-user license from Corel at a deep discount.

If you really need a true Windows executable, you'll have to rewrite the application in another development tool like Delphi or Visual Studio.Net. If you need help with this you can contact a company like Prestwood Software who has experts in Paradox and in the target development tool.

Posted By Mike Prestwood, Post #101030, KB Topic: Runtime, PDE, Package-It!



Topic: Paradox for DOS

-Collapse +Expand Q18. Does Paradox for DOS' CPUTest.EXE run on Vista?
 
Answer:

Ok, that's a bit of a silly question, but yes it does. It may not appear to run but if you tell Windows not to close on exit, it works just fine.

  1. Right click on CPUTEST.EXE, select Properties.
  2. From the Program tab, uncheck Close on exit.

By the way, my dual core 2 GHz CPU passed.

Posted By Mike Prestwood, Post #101007, KB Topic: Paradox for DOS
-Collapse +Expand Q19. Can I run Paradox for DOS on 64-bit editions of Windows Vista, Windows 7, 8, 10?
 
Answer:

No. DOS has been removed. 16-bit programs are not directly supported on 64-bit versions of Windows Vista, Windows 7, 8, or 10. Although 64bit Windows editions come with the Command Prompt for executing DOS commands and creating scripts, it does not run DOS programs.

Recommendation: Download a DOS emulator such as DOSBox.

Posted By Mike Prestwood, Post #101120, KB Topic: Paradox for DOS
-Collapse +Expand Q20. Does Paradox for DOS run on Vista?
 
Answer:

Yes, but you must use the compatibility mode.

Posted By Mike Prestwood, Post #101005, KB Topic: Paradox for DOS
Follow PrestwoodBoards on: 


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