IT SOLUTIONS
Your full service technology partner! 
-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...OPAL: Langua...     Print This   

Paradox KB: OPAL: Language Details Topic



25+ Articles Found in the OPAL: Language Details Topic 

  KB Article    

Mike Prestwood
1. Adding & subtracting months from a date The following code demonstrates one technique for adding and subtracting months from a date in Paradox's ObjectPAL.
12 years ago, and updated 12 years ago

KB Post
Nothing New Since Your Last Visit
2918
Hits

Corel Paradox / ObjectPAL Coding

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

6 years ago, and updated 6 years ago

Code
Nothing New Since Your Last Visit
4069
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
3. Importing and Exporting Spreadsheets Demo of importing and exporting spreadsheets using ObjectPAL.
6 years ago, and updated 6 years ago
(1 Comments , last by marianchovan )

KB Post
Nothing New Since Your Last Visit
5125
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
4. In Paradox, use enumRTLMethods to List all commands Q. How can you create a table of all the ObjectPAL commands?
12 years ago

KB Post
Nothing New Since Your Last Visit
2478
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
5. Looping in ObjectPAL

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

6 years ago, and updated 5 years ago
(1 Comments , last by Gonzalo.C )

Article
Nothing New Since Your Last Visit
5642
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
7. ObjectPAL Associative Array (DynArray)

In ObjectPAL associative arrays are known as dynamic arrays.

6 years ago, and updated 59 months ago

Code
Nothing New Since Your Last Visit
4453
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
8. ObjectPAL Date, Time, and DateTime Data Types Demonstration of how to handle dates and times in ObjectPAL.
6 years ago, and updated 6 years ago

KB Post
Nothing New Since Your Last Visit
4769
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
9. 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
6 years ago, and updated 6 years ago

Code
Nothing New Since Your Last Visit
3109
Hits

Corel Paradox / ObjectPAL Coding

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

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

55 months ago

Code
Nothing New Since Your Last Visit
3665
Hits

Corel Paradox / ObjectPAL Coding

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

55 months ago

Code
Nothing New Since Your Last Visit
3297
Hits

Corel Paradox / ObjectPAL Coding

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

6 years ago, and updated 5 years ago

Code
Nothing New Since Your Last Visit  
3431
Hits

Corel Paradox / ObjectPAL Coding

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

6 years ago

Code
Nothing New Since Your Last Visit  
4121
Hits

Corel Paradox / ObjectPAL Coding

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

55 months ago

Code
Nothing New Since Your Last Visit
2991
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
15. ObjectPAL Self Keyword (Self)

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

5 years ago

Code
Nothing New Since Your Last Visit  
3863
Hits

Corel Paradox / ObjectPAL Coding

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

55 months ago

Code
Nothing New Since Your Last Visit
4769
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
17. ObjectPAL subStr

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

Alternative syntax:

LeftString = subStr(NameVar, 1, 3)
6 years ago, and updated 6 years ago

Code
Nothing New Since Your Last Visit
3532
Hits

Corel Paradox / ObjectPAL Coding

runlir
18. Paradox and OpenOffice

Export to OpenOffice

5 years ago, and updated 59 months ago
(2 Comments , last by runlir )

Code
Nothing New Since Your Last Visit
4578
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
19. Paradox Character Sets Paradox character sets: ANSI, OEM, Virtual keycodes (VK Keyboard Constants), and Hex
8 years ago, and updated 6 years ago
(1 Comments , last by mprestwood )

KB Post
Nothing New Since Your Last Visit
2841
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
20. Playing Sounds in 32-bit versions of Paradox In 32-bit Windows 95/98/ME/NT/2000, you use the PlaySound function in WINMM.DLL.
12 years ago, and updated 6 years ago

KB Post
Nothing New Since Your Last Visit
2960
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
21. 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.
7 years ago, and updated 6 years ago

Tip
Nothing New Since Your Last Visit
2715
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
22. Using Execute in Paradox's ObjectPAL Using execute() in ObjectPAL.
8 years ago, and updated 8 years ago
(1 Comments , last by Eugene.L )

KB Post
Nothing New Since Your Last Visit
4683
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
23. Using IsFile() Example ObjectPAL IsFile example demonstrates how to check if a file exists.
6 years ago, and updated 6 years ago

KB Post
Nothing New Since Your Last Visit
4001
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
24. Using ObjectPAL's TCursor Object Type

Exploring ObjectPAL's TCursor object type.

6 years ago, and updated 5 years ago
(1 Comments , last by Anonymous )

KB Post
Nothing New Since Your Last Visit
11861
Hits

Corel Paradox / ObjectPAL Coding

Mike Prestwood
25. Using The Windows Registry with Paradox ObjectPAL methods for using the Window's registry to store and retrieve configuration settings.
7 years ago, and updated 6 years ago
(1 Comments )

KB Post
Nothing New Since Your Last Visit
3566
Hits

Corel Paradox / ObjectPAL Coding

Icon Legend:
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
-
  Load Time=less than 1 second.
 
Print This
-
 
Have a question? Need our services? Contact us now.
--Mike Prestwood

Call: 916-726-5675

email: info@prestwood.com


-
 
Connect With Us...
PrestwoodBoards
Join Us!
Facebook
Like our page!!!
Twitter
Follow us!
LinkedIn
Join Group
YouTube
View channel.
Go ahead!   Use Us! Call: 916-726-5675 


©1995-2014 Prestwood IT Solutions.   [Security & Privacy]   Made in the U.S.A..   No H1-B.   No offshoring.