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

Advanced
-Collapse +Expand Paradox To/From
To/FromCODEGuides
-Collapse +Expand Paradox Store
PRESTWOODSTORE
   ► KBDesktop Data...Paradox & Ob...ObjectPAL Co...   Print This     

Paradox KB: ObjectPAL Coding Topic

History: ObjectPAL was developed by Borland and released in 1993. ObjectPAL is short for Object Paradox Application Language and is the language used by Paradox for Windows. ObjectPAL is the object-based version of PAL (the programming language used by Paradox for DOS).

Topics

107 Articles Found in the ObjectPAL Coding Topic  (or one of the sub-topics in bold above)

  KB Article    

Mike Prestwood
1. A 10 Minute ObjectPAL Quick Start

If you've never programmed in ObjectPAL, spend 10 minutes and see how easy it is to program Paradox for Windows.

Posted to KB Topic: OPAL: Language Basics
11 years ago, and updated 11 years ago
(3 Comments , last by Vance.V )

Article
Nothing New Since Your Last Visit
19284
Hits

Corel Paradox / ObjectPAL Coding

Douglas.M
2. A Customized Software Glitch That Was Not

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

10 months ago
(2 Comments , last by Pervez.J )

Article
Nothing New Since Your Last Visit
597
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
3. Add an Option to Paradox's Tool's Menu How to add an option to the tools menu.
Posted to KB Topic: OPAL: Wicked Coding Tasks
11 years ago

KB Post
Nothing New Since Your Last Visit
8045
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
4. Add ObjectPAL to a delivered form You cannot directly add code to a delivered form. For example, methodSet does not work on delivered files. However, you can use executeString() to execute ObjectPAL code even on a delivered form.
Posted to KB Topic: Runtime, PDE, Package-It!
11 years ago

Tip
Nothing New Since Your Last Visit
6494
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
6. An ObjectPAL Primer: Part 1

This detailed ObjectPAL primer will get you up and running developing in Paradox/ObjectPAL within a few hours.

Posted to KB Topic: OPAL: Language Basics
16 years ago, and updated 9 years ago
(3 Comments , last by goldieridge.g )

Article
Nothing New Since Your Last Visit
19458
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
7. An ObjectPAL Primer: Part 2 Part 2.
Posted to KB Topic: OPAL: Language Basics
16 years ago, and updated 11 years ago
(1 Comments , last by Marion.F )

Article
Nothing New Since Your Last Visit
16398
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
8. An ObjectPAL Primer: Part 3

Part 3.

Posted to KB Topic: OPAL: Language Basics
16 years ago, and updated 10 years ago
(5 Comments , last by Xanthus.H )

Article
Nothing New Since Your Last Visit  
29348
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
9. Assocative Arrays in ObjectPAL

An associative array links a set of unique values (keys) to another set of values (not necessarily unique). In ObjectPAL associative arrays are known as dynamic arrays.

Posted to KB Topic: OPAL: Language Details
11 years ago, and updated 11 years ago

Code
Nothing New Since Your Last Visit
9383
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
10. Before You Code

Before you code in ObjectPAL, ask yourself two questions. Does Paradox already do this? Is there a better and easier way? Remember, simple solutions for simple problems.

Posted to KB Topic: OPAL: Language Basics
12 years ago, and updated 10 years ago

Tip
Nothing New Since Your Last Visit
6997
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
11. Calling an Oracle Stored procedure from Paradox

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.

Posted to KB Topic: OPAL: Wicked Coding Tasks
17 years ago, and updated 11 years ago

Code
Nothing New Since Your Last Visit
10445
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
12. Camel Casing Camel Casing capitalizes the first character of each word except the first word, so it frequently looks like a one or two hump camel. Used by many languages including Paradox's ObjectPAL. You can contrast Camel Casing with Pascal Casing which capitalizes the first character of each word (including acronyms over two letters in length) and was popularized by Pascal.
Posted to KB Topic: OPAL: Language Basics
11 years ago, and updated 11 years ago
(2 Comments , last by peter.s7 )

Definition
Nothing New Since Your Last Visit
13391
Hits

Corel Paradox / ObjectPAL Coding

CliffSuttle
13. Cliff's Corner: Improving the Code

Cliff's Corner by Cliff Suttle: Feb/Mar/Apr edition.

Posted to KB Topic: OPAL: Commands
16 years ago, and updated 10 years ago

Article
Nothing New Since Your Last Visit
10755
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
14. Consolas Font If you're looking for a replacement for Courier when editing ObjectPAL code, consider Consolas. The Microsoft Consolas Font Family is a set of highly legible fonts designed for ClearType. It is intended for use in programming environments and other circumstances where a monospaced font is specified. This installation package will set the default font for Visual Studio to Consolas, but if you don't have Visual Studio installed, it just skips that process without error.
Posted to KB Topic: OPAL: Language Basics
11 years ago

Download
Nothing New Since Your Last Visit
11514
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
15. Correct Event To Trap a Key Press As long as a field has focus, key presses do not bubble because the key press is used up by the field. Therefore, the two best choices to trap for key presses are the form's prefilter or on the field itself.
Posted to KB Topic: OPAL: Commands
12 years ago, and updated 11 years ago

Tip
Nothing New Since Your Last Visit
6633
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
16. Debugging ObjectPAL Code Tracinging built-in events, setting breakpoints, compiler options, debugging without the debugger, types of errors, the error event, errorShow, and the try structure.
Posted to KB Topic: OPAL: Commands
11 years ago, and updated 11 years ago
(2 Comments , last by Anonymous )

Article
Nothing New Since Your Last Visit
12849
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
17. DLL Uses Block

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?

Posted to KB Topic: OPAL: Win32 Calls
10 years ago

FAQ
Nothing New Since Your Last Visit  
7488
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
18. Don't Leave Experiments In Your Code!

If, in experimentation, you use sleep(), doDefault, or DisableDefault to overcome some odd or misunderstood behavior, do not leave the commands in your code. If using the command didnt seem to make a difference, then take it out. Use commands only when they are called for. One great way to really learn the event model and the power of these and other commands is to experiment with adding them. Remember to take them out, however, if they do not do what you wanted.

Posted to KB Topic: OPAL: Language Basics
12 years ago, and updated 10 years ago

Tip
Nothing New Since Your Last Visit
6642
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
19. Download Paradox 9 Runtime

How to get Paradox 9 Runtime.

Prestwood clients only!

Posted to KB Topic: Runtime, PDE, Package-It!
11 years ago, and updated 9 years ago

Download
Nothing New Since Your Last Visit
24275
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
20. Exploring Where To Put Code

Think levels when you code in the Pardox ObjectPAL development environment.

Posted to KB Topic: OPAL: Language Basics
11 years ago
(1 Comments , last by Anonymous )

Article
Nothing New Since Your Last Visit
13904
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
21. Finding and Listing a Set of Files ObjectPAL example that demonstrates listing a set of files and allowing the user to launch any one of them by double clicking.
Posted to KB Topic: OPAL: Commands
11 years ago, and updated 11 years ago
(1 Comments , last by peter_dissing )

KB Post
Nothing New Since Your Last Visit
7802
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
22. Finding the Path of a File ObjectPAL example where user selects a file and you extract the path.
Posted to KB Topic: OPAL: Commands
11 years ago, and updated 11 years ago
(1 Comments , last by Uwais.Q )

KB Post
Nothing New Since Your Last Visit
7781
Hits

Corel Paradox / ObjectPAL Coding

Douglas.M
24. How I Generate a List of Top Customers for a Specific Sales Representative

This is a useful report I made using the Paradox ObjectPAL coding to create a listing of top customers for a specific sales representative along with an order date range input. It’s a good insight into who your sales people are selling to and how much in a given time period.

Posted to KB Topic: OPAL: Reports
6 years ago, and updated 11 months ago

Article
Nothing New Since Your Last Visit
7803
Hits

Corel Paradox / ObjectPAL Coding

Douglas.M
25. How to Make Programmed Paradox Queries with Microsoft Notepad

Takeaway: This article discusses a technique I use to create ObjectPAL queries that can easily be modified for other purposes such as customized reporting.

56 months ago, and updated 11 months ago
(3 Comments , last by mprestwood )

Article
Nothing New Since Your Last Visit
7271
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
26. Implementing a Reusable Progress Bar in Paradox This overview helps you create and use a reusable progress bar.
Posted to KB Topic: OPAL: Wicked Coding Tasks
16 years ago, and updated 11 years ago

KB Post
Nothing New Since Your Last Visit
7477
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
27. Importing and Exporting Spreadsheets Demo of importing and exporting spreadsheets using ObjectPAL.
Posted to KB Topic: OPAL: Language Details
11 years ago, and updated 11 years ago
(2 Comments , last by quhum.m )

KB Post
Nothing New Since Your Last Visit
12122
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
28. In Paradox, use enumRTLMethods to List all commands Q. How can you create a table of all the ObjectPAL commands?
Posted to KB Topic: OPAL: Language Details
17 years ago

KB Post
Nothing New Since Your Last Visit
5982
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
29. Introduction to OO for the Paradox Community Compromise OO implementation strategies for Paradox developers.
Posted to KB Topic: OPAL: OOP
13 years ago, and updated 11 years ago
(5 Comments , last by mprestwood )

Article
Nothing New Since Your Last Visit
15009
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
30. Looping in ObjectPAL

Using loop structures in ObjectPAL (for, forEach, scan, while, and looping with timers).

Posted to KB Topic: OPAL: Language Details
11 years ago, and updated 10 years ago
(1 Comments , last by Gonzalo.C )

Article
Nothing New Since Your Last Visit
15422
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
32. Modify groups of objects in a report. How to use enumUIObjectNames and attach to manipulate a group of objects on a report.
Posted to KB Topic: OPAL: Reports
16 years ago
(3 Comments , last by Karen.g )

KB Post
Nothing New Since Your Last Visit
6907
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
33. Moving a Text Box With Your Mouse Getting started with moving objects with the mouse.
Posted to KB Topic: OPAL: Wicked Coding Tasks
11 years ago, and updated 11 years ago

KB Post
Nothing New Since Your Last Visit
6234
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
34. Object.Method() Syntax

The syntax of object.method() is consistent throughout ObjectPAL. If an object with the name box has code on its mouseClick event, you can access that code with box.mouseClick() method from any other object. When this code executes, the UIObject method mouseClick() calls the mouseClick event.

How do you know when you can call the code in a built-in method of an object? Easy, if the run-time library has a method equivalent, then you can use itfor example, mouseClick() and pushButton().

Posted to KB Topic: OPAL: Language Basics
12 years ago, and updated 10 years ago

Tip
Nothing New Since Your Last Visit
7445
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
35. ObjectPAL ObjectPAL stands for Object Paradox Application Language.
Posted to KB Topic: OPAL: Language Basics
12 years ago, and updated 11 years ago

Definition
Nothing New Since Your Last Visit
10727
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
36. ObjectPAL Assignment (=)

ObjectPAL uses = for it's assignment operator.

Posted to KB Topic: OPAL: Language Basics
11 years ago, and updated 11 years ago

Code
Nothing New Since Your Last Visit  
7620
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
37. ObjectPAL Associative Array (DynArray)

In ObjectPAL associative arrays are known as dynamic arrays.

Posted to KB Topic: OPAL: Language Details
11 years ago, and updated 10 years ago

Code
Nothing New Since Your Last Visit
9165
Hits

Corel Paradox / ObjectPAL Coding

Laura Lage
38. ObjectPAL Calendar Packaged as a Form

Some time ago I created a calendar form that I have been using instead of attaching to Microsofts calendar. This calendar works better for me than the OCX version from Microsoft did, so I thought that I would share it with you.

9 years ago, and updated 8 years ago

Article
Nothing New Since Your Last Visit
12759
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
39. ObjectPAL Case Sensitivity (No)

ObjectPAL is not case sensitive. My preference for ObjectPAL is to follow the camel casing promoted in the examples and help files originally developed by Borland.

Posted to KB Topic: OPAL: Language Basics
11 years ago, and updated 10 years ago

Code
Nothing New Since Your Last Visit  
8169
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
40. ObjectPAL Code Blocks (endXxxx)

ObjectPAL code blocks are surrounded by statement ending keywords that all use End with camel caps such as endMethod, endVar, endIf, endSwitch, and endTry.

Posted to KB Topic: OPAL: Language Basics
11 years ago, and updated 10 years ago

Code
Nothing New Since Your Last Visit
6847
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
41. ObjectPAL Comments (; and { ... })

Commenting Code
ObjectPAL uses ; for a single line comment and { } for a multiple line comment.

Posted to KB Topic: OPAL: Language Basics
11 years ago, and updated 10 years ago
(7 Comments , last by Jenkins.A )

Code
Nothing New Since Your Last Visit  
8057
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
42. ObjectPAL Comparison Operators (=, <>)

Common comparison operators:

= equal
<> not equal
< less than
> greater than
<= less than or equal
>= greater than or equal

Posted to KB Topic: OPAL: Language Basics
10 years ago
(2 Comments , last by Kellie.H )

Code

KB Post
Nothing New Since Your Last Visit
16753
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
43. ObjectPAL Constants (const..endConst)

In ObjectPAL, you declare one or more constant values within a const..endConst block. Optionally, you can specify the dataType by casting the value as part of the declaration. If you do not specify the data type, the data type is inferred from the value as either a LongInt, a Number, a SmallInt, or a String. As with variables, the const..endConst block can come within a method or procedure as the first bit of code, or in the Const window. Putting it above the method or procedure is allowed but has no significance so don't.

Posted to KB Topic: OPAL: Language Basics
11 years ago, and updated 10 years ago

Code
Nothing New Since Your Last Visit  
8117
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
44. ObjectPAL Custom Routines (method, procedure)

ObjectPAL is a non-OOP language (an object-based language) that offers custom methods and custom procedures. When you create a custom method, you associate it with an existing object like a button, form, or library.

When calling a custom method or procedure that has a by reference parameter (uses var), then you cannot use a literal value. this is different than in many other languages which do allow you to pass literals by reference.

Posted to KB Topic: OPAL: Libraries
11 years ago, and updated 10 years ago
(1 Comments , last by Anonymous )

Code
Nothing New Since Your Last Visit  
7610
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
45. ObjectPAL Date, Time, and DateTime Data Types Demonstration of how to handle dates and times in ObjectPAL.
Posted to KB Topic: OPAL: Language Details
11 years ago, and updated 11 years ago

KB Post
Nothing New Since Your Last Visit
12740
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
46. ObjectPAL Deployment Overview

To deploy a Paradox application, you need to deploy either the full version of Paradox or the Paradox Runtime both of which will include the BDE as well as any dependecies you've added such as psSendMail DLL, ezDialogs, etc.

Posted to KB Topic: Runtime, PDE, Package-It!
10 years ago

Code
Nothing New Since Your Last Visit
6535
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
47. 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).

Posted to KB Topic: OPAL: Language Basics
11 years ago, and updated 10 years ago

Code
Nothing New Since Your Last Visit
7584
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
48. ObjectPAL Edit Record (insertRecord, postRecord, edit)

In ObjectPAL, you use Cursor.InsertRecord to add a new record, Cursor.postRecord to post the record, and Cursor.deleteRecord() to delete it. To edit a record, you must put the cursor into edit mode, Cursor.Edit(). (A cursor applies to both a TCursor and UIObject.)

ObjectPAL gives you tremendous flexibility with editing data and includes many additional commands such as insertAfterRecord and isEdit. For dBASE tables, you can also use unDeleteRecord() to un-delete a record. See the ObjectPAL help for more commands.

Posted to KB Topic: OPAL: Language Basics
9 years ago

Code
Nothing New Since Your Last Visit
8939
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
49. ObjectPAL Empty String Check (isBlank() or not isAssigned())

In ObjectPAL, an empty variable can be unassigned (essentially null) or blank (equivalent to ""). You have to use both isBlank and isAssigned to check for an empty string.

Posted to KB Topic: OPAL: Language Basics
10 years ago, and updated 9 years ago
(2 Comments , last by Carry.M )

Code

KB Post
Nothing New Since Your Last Visit
11080
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
50. ObjectPAL End of Statement (whitespace)

Languages Focus: End of Statement

In coding languages, common End of statement specifiers include a semicolon and return (others exist too). Also of concern when studying a language is can you put two statements on a single code line and can you break a single statement into two or more code lines.

ObjectPAL End of Statement

ObjectPAL is a bit unique in that it doesn't use a semicolon nor a return to mark the end of a line, it uses whitespace which can be a return, space, or tab. This is a bit unusual but does allow for some nice formatting of code.

Posted to KB Topic: OPAL: Language Basics
11 years ago, and updated 10 years ago
(6 Comments , last by jiya.j )

Code
Nothing New Since Your Last Visit  
8953
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
51. ObjectPAL Exception Trapping (try...onFail)

ObjectPAL has a try...onFail statement but does not have a finally-type component. However, the code afer endTry will execute.

try
onFail
endTry
Posted to KB Topic: OPAL: Language Details
11 years ago, and updated 11 years ago

Code
Nothing New Since Your Last Visit
6668
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
52. ObjectPAL Filter Records (setRanger, setGenFilter)

In ObjectPAL, you can filter set a TCursor, UIObject, and Table objects using setRange() and setGenFilter().

Posted to KB Topic: OPAL: Language Details
9 years ago

Code
Nothing New Since Your Last Visit
9749
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
53. ObjectPAL Find Record (locate, qLocate)

ObjectPAL provides a rich set of commands for finding a record with a TCursor or UIObject including:

  • locate() -  Seach for a value based on a criteria. Uses indexes as appropriate.
  • locatePattern() - Search for a pattern within a value.
  • moveToRecord() - Moves to a specific record number.
  • qLocate() - Search using currently set index.

Each of these basic find record commands has supporting commands such as locateNext() and recNo().

Posted to KB Topic: OPAL: Language Details
9 years ago

Code
Nothing New Since Your Last Visit
8769
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
54. ObjectPAL If Statement (If..Else..EndIf, or switch)

ObjectPAL supports a simple If...Else...EndIf statement.

Notice ObjectPAL does not support an ElseIf feature as part of an if statement. Instead use a switch statement

Posted to KB Topic: OPAL: Language Basics
11 years ago, and updated 10 years ago

Code
Nothing New Since Your Last Visit  
11486
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
55. ObjectPAL Inheritance (Not Supported)

ObjectPAL does not support developer defined class creation nor sub-classing (inheritance).

Posted to KB Topic: OPAL: OOP
11 years ago, and updated 10 years ago

Code
Nothing New Since Your Last Visit  
7460
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
56. ObjectPAL Level Beginner or Advanced? Whether your ObjectPAL level is set to Beginner or Advanced, you can use all the ObjectPAL methods, procedures, properties, constants, keywords, and so on. The level panel is a help filter used just for learning purposes. However, because you could in effect "hide" code from yourself, I recommend setting this to Advanced (never use beginner).
Posted to KB Topic: OPAL: Language Basics
12 years ago, and updated 11 years ago

Tip
Nothing New Since Your Last Visit
5874
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
57. ObjectPAL Literals (quote)

Literals are quoted as in "Prestwood".  If you need to embed a quote use a slash in front of the quote as in \"

In ObjectPAL, string literals are limited to 255 characters but there's nothing preventing you from using multiple string literals together as in:

msgInfo("", "Hi Mike: " + "You can add literals together in ObjectPAL")
Posted to KB Topic: OPAL: Language Basics
11 years ago, and updated 10 years ago

Code
Nothing New Since Your Last Visit  
10314
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
58. ObjectPAL Logical Operators

ObjectPAL logical operators:

and and, as in this and that
or or, as in this or that
Not Not, as in Not This

Posted to KB Topic: OPAL: Language Basics
10 years ago, and updated 10 years ago
(1 Comments , last by Anonymous )

Code

Article
Nothing New Since Your Last Visit  
13318
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
59. 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.

Posted to KB Topic: OPAL: Language Details
11 years ago, and updated 10 years ago

Code
Nothing New Since Your Last Visit  
7512
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
60. 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.

11 years ago, and updated 10 years ago

Code
Nothing New Since Your Last Visit  
10025
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
61. ObjectPAL Parameters (var, const)

By Reference or Value (and by constant)
The default for parameters is by value. For by reference, add var in front of the parameter. ObjectPAL also offers constant parameters where you add const in front of the parameter. A constant parameter is like a read-only parameter the compiler can optimize. You cannot assign a value to a constant parameter.

Posted to KB Topic: OPAL: Language Details
11 years ago

Code
Nothing New Since Your Last Visit  
9106
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
62. ObjectPAL Pointers

ObjectPAL doesn't use pointers except for use with DLLs where you use a special CPTR uses keyword to refer to a DLL string pointer data type.

Posted to KB Topic: OPAL: Libraries
10 years ago

Code
Nothing New Since Your Last Visit  
7876
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
63. ObjectPAL Polymorphism (Not Supported)

Built-in: In ObjectPAL, polymorphism is the capability of the built-in objects to act differently depending on the context in which they are being used. For example, Table.Open and TCursor.Open. The Open method works differently depending on the object type used.

Custom: No. However,you can have the same named method or procedure so long as they are in different libraries.This is importantif you use librariesin a class-like OOP way and wish to implement some form of interfaces-like polymorphism(i.e. libMember.GetName and libVendor.GetName).

Posted to KB Topic: OPAL: OOP
11 years ago, and updated 11 years ago

Code
Nothing New Since Your Last Visit
7046
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
64. ObjectPAL Record Movement (home, end, nextRecord)

ObjectPAL uses home(), end(), nextRecord(), priorRecord() to move a database cursor (works with either a TCursor or UIObject).

TCursor.nextRecord()

These commands send a message to the object. Specifically, they send an action constant using the action command. The above snippet is equivalent to:

TCursor.action(DataNextRecord)

It is handy to  with familiar with action constants because not all action constants have an ObjectPAL equivalent comment.

Posted to KB Topic: OPAL: Language Details
9 years ago

Code
Nothing New Since Your Last Visit
7336
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
65. ObjectPAL Rules for Beginners http://www.injection-moldings.com/codesamples/Opal_for_Beginers.html
11 years ago

Link
Nothing New Since Your Last Visit
5573
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
66. ObjectPAL Self Keyword (Self)

A built-in object variable that represents the UIObject to which the currently executing code is attached.

Posted to KB Topic: OPAL: Language Details
10 years ago

Code
Nothing New Since Your Last Visit  
7618
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
67. ObjectPAL setTitle()

This code sets the title of your Paradox application in the application's title bar.

Posted to KB Topic: OPAL: Commands
12 years ago, and updated 9 years ago
(3 Comments , last by funny.j )

Code
Nothing New Since Your Last Visit
9741
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
68. 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.

Posted to KB Topic: OPAL: Language Details
9 years ago

Code
Nothing New Since Your Last Visit
9709
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
69. ObjectPAL String Concatenation (+)

String literals s are limited to 255 characters but you can simply add two strings together as in:

s = "A long string." + "Another long string."
Posted to KB Topic: OPAL: Language Basics
11 years ago, and updated 10 years ago

Code
Nothing New Since Your Last Visit
7072
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
70. ObjectPAL subStr

substr ( const startIndex LongInt [ , const numberOfChars LongInt ] ) String

Alternative syntax:

LeftString = subStr(NameVar, 1, 3)
Posted to KB Topic: OPAL: Language Details
11 years ago, and updated 11 years ago

Code
Nothing New Since Your Last Visit
7308
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
71. ObjectPAL Unary Operators

The ObjectPAL unary operators are:

+
-
Not

Posted to KB Topic: OPAL: Language Basics
10 years ago
(4 Comments , last by adv.y )

Code
Nothing New Since Your Last Visit
7998
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
72. ObjectPAL Variables (var x SmallInt endVar)

Declaring variables is optional unless you click Program | Compiler Warnings while in the ObjectPAL editor for every form, script, and library you create. Using Compiler Warnings is strongly recommended to avoid incorrectly typing an existing variable and to avoid any confusion about variable scope. Also recommended is turning on Compile with Debug for every form, script, and library too for tighter, cleaner code.

Undeclared variables are AnyType variables. Common data types include Currency, Date, Datetime, Logical, LongInt, Number, SmallInt, String, and Time.

Declare local variables within a method. If you want a local static variable (retains it's value because it is not destroyed), declare the varialbes above the method. Variables declared in an object's Var window are visible to all methods attached to that object, and objects that it contains.

Posted to KB Topic: OPAL: Language Basics
11 years ago, and updated 9 years ago
(2 Comments , last by Jesse.L )

Code
Nothing New Since Your Last Visit  
12668
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
73. OLEAuto Paradox to Outlook

The following code snippet adds an appointment to your Outlook calendar. Tested with Paradox 9 and Outlook 2003 but should work with later versions of both programs.

Note, you will get a Error opening server 'Outlook.Application' error if your antivirus program is blocking Outlook access.

Posted to KB Topic: OPAL: Wicked Coding Tasks
9 years ago
(1 Comments , last by Lotfi.F )

Code
Nothing New Since Your Last Visit
8863
Hits

Corel Paradox / ObjectPAL Coding

runlir
74. Paradox and OpenOffice

Export to OpenOffice

Posted to KB Topic: OPAL: Language Details
10 years ago, and updated 10 years ago
(2 Comments , last by mprestwood )

Code
Nothing New Since Your Last Visit
11948
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
75. Paradox and the Internet

Using Paradox internet features. Content from chapter 25 of my "Paradox Power Programming: The Official Guide" book.

Posted to KB Topic: OPAL: Commands
12 years ago, and updated 11 years ago
(3 Comments , last by Weyland.m )

Article
Nothing New Since Your Last Visit
97520
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
76. Paradox and TWAIN Support

Does Paradox for Windows support TWAIN?

Posted to KB Topic: OPAL: Wicked Coding Tasks
10 years ago

FAQ
Nothing New Since Your Last Visit
7201
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
77. Paradox Character Sets Paradox character sets: ANSI, OEM, Virtual keycodes (VK Keyboard Constants), and Hex
Posted to KB Topic: OPAL: Language Details
13 years ago, and updated 11 years ago
(1 Comments , last by mprestwood )

KB Post
Nothing New Since Your Last Visit
6625
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
78. Paradox Command-Line Options

Paradox for Windows Command-Line Options, runtime registry settings, adding menu items to Paradox, and manually setup a Vista shortcut.

Posted to KB Topic: Runtime, PDE, Package-It!
13 years ago, and updated 10 years ago
(2 Comments , last by AIBreveleri )

Article
Nothing New Since Your Last Visit
35914
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
79. Paradox Commercial Applications List of commercial applications developed in Paradox for Windows
Posted to KB Topic: Runtime, PDE, Package-It!
13 years ago, and updated 11 years ago

Article
Nothing New Since Your Last Visit
8119
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
80. Paradox Looks for Non-Delivered, Then Delivered

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.

Posted to KB Topic: Runtime, PDE, Package-It!
12 years ago, and updated 10 years ago

Tip
Nothing New Since Your Last Visit
7148
Hits

Corel Paradox / ObjectPAL Coding

Douglas.M
81. Paradox ObjectPAL Dormant Customer Ordering Trend Report (Old and New Versions)

This article describes a Paradox ObjectPAL ordering trend reporting program I made that accepts a purchase order date range and a non-purchase order date range. It will report customers who bought during the purchase time period, but not during the non-purchase time period. There are 2 versions of this report. The older version uses only ObjectPAL Tcursors to perform the processing. The newer one incorporates programmatically executed queries in addition to Tcursors. The purpose of this report is to reveal those customers with declining sales.

Posted to KB Topic: OPAL: Reports
7 years ago, and updated 11 months ago

Article
Nothing New Since Your Last Visit
7684
Hits

Corel Paradox / ObjectPAL Coding

Douglas.M
82. 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.

56 months ago, and updated 11 months ago

Article
Nothing New Since Your Last Visit
6103
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
83. Paradox Runtime Limitations

Listing of Paradox features NOT available in Paradox Runtime.

Posted to KB Topic: Runtime, PDE, Package-It!
11 years ago, and updated 10 years ago
(1 Comments , last by Collin.P )

KB Post
Nothing New Since Your Last Visit
12059
Hits

Corel Paradox / ObjectPAL Coding

Douglas.M
84. 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.

5 years ago, and updated 11 months ago

Article
Nothing New Since Your Last Visit
4167
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
86. Playing Sounds in 32-bit versions of Paradox Playing Sounds in 32-bit versions of Paradox
11 years ago

Download
Nothing New Since Your Last Visit
7850
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
88. 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.
11 years ago, and updated 10 years ago
(2 Comments , last by mprestwood )

Download
Nothing New Since Your Last Visit
13424
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
89. Set Your Working Directory With ObjectPAL Use setWorkingDir then trap for MenuChangingWork in menuAction.
Posted to KB Topic: OPAL: Commands
11 years ago, and updated 11 years ago

KB Post
Nothing New Since Your Last Visit
9026
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
90. Speed Up TCursors with setBatchOn() You can speed up a TCursor in by using update(), setBatchOn(), or copyToArray(). If you use setBatchOn(), make sure to follow it with setBatchOff() every time you use it.
Posted to KB Topic: OPAL: Wicked Coding Tasks
12 years ago, and updated 11 years ago
(3 Comments , last by greens )

Tip
Nothing New Since Your Last Visit
10208
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
91. Study The Experts

Paradox provides experts that generate code at the field level, in the form open, etc. It is a good idea to study the ObjectPAL generated by these experts.

Posted to KB Topic: OPAL: Language Basics
12 years ago, and updated 10 years ago

Tip
Nothing New Since Your Last Visit
6602
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
93. Testing the Speed of Your code To test the speed of your code, capture the time before and after your code executes and view the milliseconds between the two dates.
Posted to KB Topic: OPAL: Commands
11 years ago, and updated 11 years ago

KB Post
Nothing New Since Your Last Visit
7702
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
94. Turn Paradox into an EXE My company has a Paradox application. Can I turn it into a true Windows application? A true Win-32 executable?
Posted to KB Topic: Runtime, PDE, Package-It!
11 years ago, and updated 11 years ago

FAQ
Nothing New Since Your Last Visit
7430
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
95. Use a Dialog form with app.Hide() If you wish to show ONLY your form and hide Paradox, use a dialog form and app.hide().
Posted to KB Topic: OPAL: Commands
12 years ago, and updated 11 years ago

Tip
Nothing New Since Your Last Visit
6366
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
96. Use Constants & Make Your Code Easier to Maintain Two advantages of using constants are that they humanize your code and help make managing your code easier. They humanize your code by making your code easier to read. A constant named tax is easier to remember and understand than 8.125. Constants help you maintain your code by centralizing values. If the tax rate in your area changes from 8.125 to 8.5, you change the constant in one location.
Posted to KB Topic: OPAL: Language Details
12 years ago, and updated 11 years ago

Tip
Nothing New Since Your Last Visit
6033
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
97. User ForceRefresh() to Update Calculated Fields If you ever have a calculated field on a form not update when you think it should, then use forceRefresh() to make the calculated field display the correct values.
Posted to KB Topic: OPAL: Commands
12 years ago, and updated 11 years ago

Tip
Nothing New Since Your Last Visit
8822
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
98. Using Execute in Paradox's ObjectPAL Using execute() in ObjectPAL.
Posted to KB Topic: OPAL: Language Details
13 years ago, and updated 13 years ago
(1 Comments , last by Eugene.L )

KB Post
Nothing New Since Your Last Visit
10223
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
99. Using Extended Uses

Using extended uses in ObjectPAL example.

Posted to KB Topic: OPAL: Libraries
13 years ago, and updated 13 years ago

Article
Nothing New Since Your Last Visit
6637
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
100. Using IsFile() Example ObjectPAL IsFile example demonstrates how to check if a file exists.
Posted to KB Topic: OPAL: Language Details
11 years ago, and updated 11 years ago

KB Post
Nothing New Since Your Last Visit
7888
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
101. Using ObjectPAL in reports (Undocumented) How to use the limited ObjectPAL support in reports.
Posted to KB Topic: OPAL: Wicked Coding Tasks
16 years ago, and updated 11 years ago

KB Post
Nothing New Since Your Last Visit
7087
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
102. Using ObjectPAL's TCursor Object Type

Exploring ObjectPAL's TCursor object type.

Posted to KB Topic: OPAL: Language Details
11 years ago, and updated 10 years ago
(1 Comments , last by Anonymous )

KB Post
Nothing New Since Your Last Visit
39167
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
103. Using Paradox 9's Application Framework Getting started using the application framework in Paradox 9.
Posted to KB Topic: Runtime, PDE, Package-It!
11 years ago, and updated 11 years ago

Article
Nothing New Since Your Last Visit
8403
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
105. Using the Win32 API and TAPI to Dial the Phone TAPI ObjectPAL example.
Posted to KB Topic: OPAL: Win32 Calls
11 years ago

KB Post
Nothing New Since Your Last Visit
6849
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
106. Using The Windows Registry with Paradox ObjectPAL methods for using the Window's registry to store and retrieve configuration settings.
Posted to KB Topic: OPAL: Language Details
12 years ago, and updated 11 years ago
(1 Comments )

KB Post
Nothing New Since Your Last Visit
7681
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
107. Where to Put Code - Short Overview Techniques for thinking about where to put code in Paradox's object-based event model.
Posted to KB Topic: OPAL: Language Basics
12 years ago, and updated 11 years ago

Article
Nothing New Since Your Last Visit
9575
Hits

Corel Paradox / ObjectPAL Coding

Icon Legend:
Recent or not:
- Recent activity (within last two weeks).
- No activity last two weeks.
 Since your last logged visit:
- New to you or updated since your last visit (sign in now to activate).
- NOT new to you since your last visit (sign in now to activate).

New Corel Paradox / ObjectPAL Coding Knowledge Base Post...

Share your knowledge with the WORLD! In addition to adding comments to existing posts, you can post knowledge you've acquired. We welcome full articles (intro with screen shots), general posts (shorter), and tidbits (tips, FAQs, definitions, etc.).

Post New...

Tidbit Post: Short Flashcard FAQ Definition Quick Tip Code Snippet
Longer Post: Full Article General Post File Link Error News
Other: Blog Topic
Or, if YOU have a question...
  Corel Paradox / ObjectPAL Coding Message Board
Follow PrestwoodBoards on: 


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