| |
KB Article |
|
Mike Prestwood
|
1. The Future of Paradox Blog
If you have an existing Paradox system you can keep using it but you'll need to skip the Vista operating system and either stick with Windows XP or move to Windows 7. Because better tools exist, you may very well want 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.
21 years ago, and updated 94 days ago
(46 Entries
, last by crossy.r )
|
 Blog
 74013 Hits
|
 Corel Paradox / ObjectPAL Coding
|
NE Ohio Computer Guy
|
2. Paradox Search Technique Code
An alternate solution for a Corel Paradox query that fails to yield accurate results due to a huge number of records in a data table.
12 years ago, and updated 6 years ago
|
 Article
 6423 Hits
|
 Corel Paradox / ObjectPAL Coding
|
NE Ohio Computer Guy
|
3. Paradox ObjectPAL Email Blast Programming
This article will discuss an ObjectPAL coding technique I use to send out an email blast from a Paradox data table of email addresses via a third party email client.
12 years ago, and updated 6 years ago
|
 Article
 8636 Hits
|
 Corel Paradox / ObjectPAL Coding
|
NE Ohio Computer Guy
|
4. What to do When Your Paradox Data Table View Comes up Black
A simple fix for Paradox data tables appearing totally black in data table view mode.
12 years ago, and updated 6 years ago
(3 Comments
, last by Elliott.O )
|
 Article
 10283 Hits
|
 Corel Paradox / ObjectPAL Coding
|
Mike Prestwood
|
5. Prospect, Monthly App Support Plan
Initial Concerns:
We provide app support and maintenance with our monthly App Maintenance plans.
Process:
- If Paradox, send Paradox Support Plan flyer; otherwise, send App Maintenance flyer.
- Follow up, ask, "How much support and/or coding per week or month do you need?"
- If interested, determine entry level from question above, create SLA.
- Send SLA.
- Follow up until yes/no.
|
 SS
 1671 Hits
|
 Prestwood IT Solutions
|
Wes Peterson
|
6. Connecting to Paradox Databases Via .NET
Recently, one of our message board visitors asked if was possible to connect to - and use - an existing Paradox databases with Visual Studio .NET. The answer is "Yes!"
19 years ago, and updated 15 years ago
(1 Comments
, last by yaret.r )
|
 Article
 14611 Hits
|
 Corel Paradox / ObjectPAL Coding
|
Mike Prestwood
|
7. Power: Chapter 16, Handling the Keyboard
Chapter 16, "Handling the Keyboard" from Paradox 9 Power Programming by Mike Prestwood.
23 years ago, and updated 15 years ago
(5 Comments
, last by Vicki.O )
|
 KB Post
 19427 Hits
|
 Corel Paradox / ObjectPAL Coding
|
Wes Peterson
|
8. Paradox, .NET, and the Wicked Back-Tick
Using spaces within database column names may be "legal," but that doesn't mean it won't make your life harder. It's legal in Paradox tables and most database systems but you might want to avoid using spaces. Here's why - and one way to use spaces if you're using Paradox tables under .NET.
(2 Comments
, last by mprestwood )
|
 KB Post
 14083 Hits
|
 Corel Paradox / ObjectPAL Coding
|
Mike Prestwood
|
9. Paradox 14 Is Paradox 11 SP2
Does Paradox X4 have any new features over X3?
18 years ago, and updated 16 years ago
(10 Comments
, last by Uwais.Q )
|
 FAQ
 38393 Hits
|
 Corel Paradox / ObjectPAL Coding
|
Mike Prestwood
|
10. Recommended Paradox Preferences
Step by step instructions for setting some of Paradox's more useful preferences.
18 years ago, and updated 16 years ago
(2 Comments
, last by Jenni.O )
|
 Article
 22029 Hits
|
 Corel Paradox / ObjectPAL Coding
|
Mike Prestwood
|
11. Power: Chapter 24, SQL and Client/Server Applications
Chapter 24 "SQL and Client/Server Applications" of Paradox 9 Power Programming by Mike Prestwood.
23 years ago, and updated 16 years ago
(3 Comments
, last by Yertay.P )
|
 KB Post
 26587 Hits
|
 Corel Paradox / ObjectPAL Coding
|
Mike Prestwood
|
12. ObjectPAL Sort Records (switchIndex, sortTo, setGenFilter)
In Paradox, you add an index for each sort your wish to perform on a table then use switchIndex(). Alternatively, you can use sortTo() to sort a table into a new table.
(1 Comments
, last by Alex.M4 )
|
 Code
 12888 Hits
|
 Corel Paradox / ObjectPAL Coding
|
Wes Peterson
|
13. Using Paradox Tables with .NET
Although the .NET Framework is well "tuned" for MS SQL Server, it can also be pressed into service with other databases.
A somewhat unusual case is using ASP .NET to access and modify data in Paradox tables. If you're going to do that, the most important thing to know is which ODBC driver to use - because you will be using an ODBC Driver.
The driver to use was created by Intersolv and bundled with Paradox v9. That driver has a version designation of v3.11
|
 Tip
 8404 Hits
|
 Coding & OO
|
Mike Prestwood
|
14. ObjectPAL Overview and History
Language Overview: Object based language. Although ObjectPAL uses object oriented techniques "under the hood", it is not object oriented. Although you cannot create classes, ObjectPAL has built-in objects you can use in your code. You code in a traditional approach attaching code to objects or within a script. Most Paradox applications are form based. You may have a short startup script but you design forms and reports and tie them together with a common form. You can store reusable code such as custom methods and procedures in a library.
Target Platforms: Corel Paradox is most suitable for creating business desktop applications that run within Corel Paradox for Windows.
18 years ago, and updated 17 years ago
|
 Code
13964 Hits
|
 Corel Paradox / ObjectPAL Coding
|
Mike Prestwood
|
15. Power: Chapter 12, Handling Reports
Chapter 12, "Handling Reports" from Paradox 9 Power Programming by Mike Prestwood.
23 years ago, and updated 17 years ago
|
 KB Post
 19766 Hits
|
 Corel Paradox / ObjectPAL Coding
|
Mike Prestwood
|
16. BDE Best Practices: Safely Use Paradox Tables
Use a file server (not a workstation) to store your data, disable Oplocks on the filer server, and configure the BDE (local share to true and optimize if desired). Finally, if workstations are crashing, fix em so they don't. You want clean running computers that don't crash.
18 years ago, and updated 17 years ago
(5 Comments
, last by Davis.M )
|
 KB Post
 154203 Hits
|
 Corel Paradox / ObjectPAL Coding
|
Mike Prestwood
|
17. 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.
18 years ago, and updated 17 years ago
(3 Comments
, last by Aaron.R )
|
 Download
 17935 Hits
|
 Corel Paradox / ObjectPAL Coding
|
Mike Prestwood
|
18. JavaScript Report Tools Overview
No built-in report writer but because JavaScript most frequently targets website development (a document interfaced GUI), a common solution is to simply output an HTML formatted page with black text and a white background (not much control but it does work for some situations).
|
 Code
 19310 Hits
|
 JavaScript and AJAX
|
Mike Prestwood
|
19. Java Report Tools Overview
Both Eclipse 3.3 and JBuilder 2008 come bundled with Business Intelligence and Reporting Tools (BIRT). BIRT is an Eclipse-based open source reporting system with both a report designer based on Eclipse, and a runtime component that you can add to your app server plus a charting engine that lets you add charts.
|
 Code
 13917 Hits
|
 Java
|
Mike Prestwood
|
20. ObjectPAL File Extensions
Paradox for Windows has two primary file types: source files and delivered files. Source files in Paradox are binary but can can be opened in later versions of Paradox and even in earlier versions if you don't use any new features: .FSL = Form, .RSL = Report, .SSL = Script, and .LSL = Library. Since Paradox source files do not compile to an EXE, Paradox developers tend to use a startup form or script to start the application.
18 years ago, and updated 17 years ago
(2 Comments
, last by KevinT.Win.K )
|
 Code |
 KB Post |
21214 Hits
|
 Corel Paradox / ObjectPAL Coding
|
Mike Prestwood
|
21. Delphi Report Tools Overview
Rave Reports comes closest to a Delphi standard now but historically there has been no real standard in Delphi development. Do-it-yourself developers sometimes like to use TPrinter for very simple reports. ReportSmith was bundled with the first few versions of Delphi.
Delphi has offered many embedded VCL component report options. Quick Reports has been a part of Delphi since Delphi 2.0 and has been the default report writer for many Delphi developers. Ace Reporter, ReportBuilder and Rave Reports are also very popular. During the time of Kylix, FastReports was popular because of it's cross-platform nature.
18 years ago, and updated 17 years ago
(4 Comments
, last by Logan.N )
|
 Code |
 KB Post |
 33652 Hits
|
 Pascal and Delphi Coding
|
Mike Prestwood
|
22. C++/CLI Report Tools Overview
Use any report writer you are comfortable with but Crystal Reports remains popular for Visual C++ and C++/CLI.
|
 Code
 8765 Hits
|
 C++
|
Mike Prestwood
|
23. C++ Report Tools Overview
Use any report writer you are comfortable with. C++Builder 2009 comes bundled with Rave Reports and Crystal Reports remains popular for Visual C++.
(5 Comments
, last by Adam.S4 )
|
 Code
 10981 Hits
|
 C++
|
Mike Prestwood
|
24. ObjectPAL Overloading
Paradox & Overloading
- Operator - No.
- Method - No.
However, you can have the same named method or procedure so long as they are in different libraries. This is important if you use libraries in a class-like OOP way and wish to implement some form of polymorphism (i.e. libMember.Open and libVendor.Open). This is an OOP-like technique for implementing a subtyping-like polymorphism which is also known as inclusion polymorphism.
Also, some developers like to pass an array and then handle the array for a pseudo technique. Although not overloading, it's useful.
18 years ago, and updated 17 years ago
(1 Comments
, last by bittern.s )
|
 Code
11351 Hits
|
 Corel Paradox / ObjectPAL Coding
|
Mike Prestwood
|
25. ObjectPAL Development Tools
Corel Paradox for Windows (was Borland Paradox). Also, Borland used to offer a Paradox for DOS tool which support it's Paradox Application Language (PAL) which is not compatible with ObjectPAL. The biggest drawback to Paradox is that Corel does not have anyone at Corel actively developing Paradox for Windows (as opposed to Microsoft Access which does).
18 years ago, and updated 17 years ago
|
 Code
 10572 Hits
|
 Corel Paradox / ObjectPAL Coding
|
Mike Prestwood
|
26. Access VBA Development Tools
Languages Focus: Development ToolsPrimary development tool(s) used to develop and debug code.
Access VBA Development ToolsMicrosoft Office Access is the primary tool and does include pretty good debugging features, some limited OOP features such as designing a class and instantiating an object, and, best of all, MS still has developers working on MS Access (as opposed to Corel Paradox).
18 years ago, and updated 17 years ago
(1 Comments
, last by Andreaa.F )
|
 Code
 8960 Hits
|
 Microsoft Access
|
Mike Prestwood
|
27. VB.Net Report Tools Overview
Microsoft includes ReportViewer Starting with Visual Studio 2005. You can even surface this .Net solution in your VB Classic application if you wish. For WebForm applications the client target is the browser (a document interfaced GUI), a common solution is to simply output an HTML formatted page with black text and a white background (not much control but it does work for some situations). For WinForm applications, Crystal Reports is still very popular with VB.Net developers because it has been bundled with Visual Basic since VB 3, it's overall popularity, and compatibility with many different development tools.
18 years ago, and updated 18 years ago
|
 Code
 12127 Hits
|
 VB.Net Language
|
Mike Prestwood
|
28. C# Report Tools Overview
For WebForm applications the client target is the browser (a document interfaced GUI), a common solution is to simply output an HTML formatted page with black text and a white background (not much control but it does work for some situations). For WinForm applications, Crystal Reports is still a popular choice with C# developers because it has been bundled with many Microsoft products, it's overall popularity, and compatibility with many different development tools.
18 years ago, and updated 18 years ago
(1 Comments
, last by Anonymous )
|
 Code
 12688 Hits
|
 C# (Visual C# & VS.Net)
|
Mike Prestwood
|
29. PHP Report Tools Overview
Because website development targets a client browser (a document interfaced GUI), a common solution is to simply output an HTML formatted page with black text and a white background (not much control but it does work for some situations).
18 years ago, and updated 18 years ago
|
 Code
 9067 Hits
|
 PHP & Delphi for PHP
|
Mike Prestwood
|
30. Perl Report Tools Overview
Because website development targets a client browser (a document interfaced GUI), a common solution is to simply output an HTML formatted page with black text and a white background (not much control but it does work for some situations).
18 years ago, and updated 18 years ago
|
 Code
 11013 Hits
|
 Perl
|
Mike Prestwood
|
31. Delphi Prism Report Tools Overview
For WebForm applications the client target is the browser (a
document interfaced GUI), a common solution is to simply output an HTML
formatted page with black text and a white background (not much control
but it does work for some situations). For WinForm applications Rave Reports and Crystal Reports are very popular with Delphi Prism and Delphi for .Net developers.
18 years ago, and updated 18 years ago
|
 Code
 10098 Hits
|
 Delphi Prism
|
Mike Prestwood
|
32. ASP Classic Report Tools Overview
Because ASP Classic targets a client browser (a document interfaced GUI), a common solution is to simply output an HTML formatted page with black text and a white background (not much control but it does work for some situations).
18 years ago, and updated 18 years ago
(4 Comments
, last by maria.k )
|
 Code
 13368 Hits
|
 ASP Classic Coding
|
Mike Prestwood
|
33. VB Classic Report Tools Overview
Crystal Reports was very popular with VB Classic developers and came bundled with Visual Basic 3 through 6. VB6 offers both Crystal Reports and the new Microsoft Data Report Designer.
18 years ago, and updated 18 years ago
|
 Code
 12084 Hits
|
 Visual Basic Classic
|
Mike Prestwood
|
34. ObjectPAL Report Tools Overview (Built-In)
Paradox offers a built-in reporting tool that will suffice for most desktop database applications.
18 years ago, and updated 18 years ago
(22 Comments
, last by Amy.M2 )
|
 Code
 12739 Hits
|
 Corel Paradox / ObjectPAL Coding
|
Mike Prestwood
|
35. Access VBA Report Tools Overview (Built-In)
Microsoft Access offers a built-in reporting tool that will suffice for most desktop database applications.
18 years ago, and updated 18 years ago
(17 Comments
, last by RomanJay.A )
|
 Code
 12814 Hits
|
 Microsoft Access
|
Mike Prestwood
|
36. Borland TUtility wrapped up in a Prestwood Installation
This Win32 program will verify and rebuild all versions of Paradox tables (3.5, 4, 5, and 7). To be clear, this program was not written by us. We simply packaged up the appropriate two files from Borland's BDE Utilities and Updates page in an installation program.
18 years ago, and updated 18 years ago
(4 Comments
, last by abeljame.a )
|
 Download
 25084 Hits
|
 Corel Paradox / ObjectPAL Coding
|
count-dowm
|
37. Whats new in Paradox 13 (Office X3 Pro)
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?
19 years ago, and updated 18 years ago
(12 Comments
, last by gowsi.s )
|
 FAQ
 12208 Hits
|
 Corel Paradox / ObjectPAL Coding
|
Mike Prestwood
|
38. Import Excel 2003, XP, 2007 into Corel Paradox
How do I import an Excel 2003, XP, or 2007 spreadsheet?
|
 FAQ
 14089 Hits
|
 Corel Paradox / ObjectPAL Coding
|
CliffSuttle
|
39. A Data Normalization Primer - Part 3
In October we finally normalized our invoice data base. In this final part III, there will be little in the way of review, so if you’re lost, don’t be lazy, read parts I and II.
24 years ago, and updated 18 years ago
(7 Comments
, last by Nathan.A )
|
 Article
 14956 Hits
|
 Corel Paradox / ObjectPAL Coding
|
Mike Prestwood
|
40. Corel Ships Paradox with WordPerfect Office X3 Pro!
Paradox 11 with SP2 already applied shipped as part of the WPO X3 Pro Edition.
19 years ago, and updated 18 years ago
(3 Comments
, last by Rodgers.G )
|
 News
 24207 Hits
|
 Corel Paradox / ObjectPAL Coding
|
Mike Prestwood
|
41. Chapter 29: An ObjectPAL Primer for Paradox for Linux
Chapter 29 by Mike Prestwood from the book WordPerfect Office 2000 for Linux: The Official Guide. First published June 2000 by Osborne-McGraw/Hill. ISBN 0-07-212238-2.
|
 Article
 12306 Hits
|
 Corel Paradox / ObjectPAL Coding
|
Mike Prestwood
|
42. Chapter 28: Using Forms and Queries in Paradox for Linux
Chapter 28 by Mike Prestwood from the book WordPerfect Office 2000 for Linux: The Official Guide. First published June 2000 by Osborne-McGraw/Hill. ISBN 0-07-212238-2.
(2 Comments
, last by Bennett.J )
|
 Article
 14906 Hits
|
 Corel Paradox / ObjectPAL Coding
|
Mike Prestwood
|
43. Chapter 27: Designing Your Database With Paradox for Linux
Chapter 27 by Mike Prestwood from the book WordPerfect Office 2000 for Linux: The Official Guide. First published June 2000 by Osborne-McGraw/Hill. ISBN 0-07-212238-2.
(13 Comments
, last by apurva.b )
|
 Article
 17135 Hits
|
 Corel Paradox / ObjectPAL Coding
|
Mike Prestwood
|
44. Chapter 26: Introduction to Paradox for Linux
Chapter 26 by Mike Prestwood from the book WordPerfect Office 2000 for Linux: The Official Guide. First published June 2000 by Osborne-McGraw/Hill. ISBN 0-07-212238-2.
(6 Comments
, last by patel.L )
|
 Article
 18667 Hits
|
 Corel Paradox / ObjectPAL Coding
|
Mike Prestwood
|
45. Power: Chapter 03, How to Develop Forms
Chapter 3, "How to Develop Forms" from Paradox 9 Power Programming by Mike Prestwood.
23 years ago, and updated 20 years ago
|
 KB Post
 18549 Hits
|
 Corel Paradox / ObjectPAL Coding
|
Mike Prestwood
|
46. Power: Chapter 13, Crosstabs and Charts
Chapter 13, "Crosstabs and Charts" from Paradox 9 Power Programming by Mike Prestwood.
23 years ago, and updated 23 years ago
(2 Comments
, last by Rebecca.M2 )
|
 KB Post
 11852 Hits
|
 Corel Paradox / ObjectPAL Coding
|
Mike Prestwood
|
47. Workbench 1.5 for Paradox 10 Ships!
Add 50+ options to Paradox 4.5, 5, 7 (32-bit), 8, 9, AND 10!
23 years ago, and updated 23 years ago
(1 Comments
, last by Mike.R5 )
|
 News
 7485 Hits
|
 Corel Paradox / ObjectPAL Coding
|