To/From Code

	Languages
BROWSEBYLANGUAGE Access VBA ASP Classic C# C++ C++/CLI Corel Paradox Delphi Delphi Prism Java JavaScript Perl PHP VB Classic VB.Net

	Categories
BROWSEBYCATEGORY +Tool Basics +Language Basics +Language Details +Data Structures +Statements +Operators +Commands +Database +OOP Basics +OOP Details

	Corel Paradox Guides
Corel Paradox To/From Conversion Guides Corel Paradox and Access VBA Corel Paradox and ASP Classic Corel Paradox and C# Corel Paradox and C++ Corel Paradox and C++/CLI Corel Paradox and Delphi Corel Paradox and Delphi Prism Corel Paradox and JavaScript Corel Paradox and Perl Corel Paradox and PHP Corel Paradox and VB Classic Corel Paradox and VB.Net

Cross Ref Guide

COREL PARADOXLANGUAGE

Corel Paradox

COREL PARADOXANDJAVATOC

Overview

+Tool Basics

Report Tools Overview

+Language Basics

+Language Details

+Data Structures

Array

+Statements

+Operators

+Commands

+Database

Filter Records◄╣

+OOP Basics

+OOP Details

	Members-Only
Sign in to see member-only pages.

► KB ► To/From Guides ► Corel Paradox

Print This

Filter Records (Corel Paradox and Java Cross Reference Guide)

By Mike Prestwood

Corel Paradox versus Java: A side by side comparison between Corel Paradox and Java.

Database

This category documents connecting and using data including database commands, and common technologies used.

Filter Records

[Other Languages]

Corel Paradox: setRanger, setGenFilter

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

Syntax Example:

The following example loads, filters, and runs a report.

var
 r Report
 dyn DynArray[] String
endVar

dyn["Name"] = "SCUBA Heaven"
Customer.setGenFilter(dyn)

r.load(":Sample:customer")
r.Customer.setGenFilter(dyn)

r.run()

You can also drop a flter with:

r.Customer.dropGenFilter()

[Not specified yet. Coming...]