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

Find Record◄╣

+OOP Basics

+OOP Details

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

► KB ► To/From Guides ► Corel Paradox

Print This

Find Record (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.

Find Record

[Other Languages]

Languages Focus

Finding a record is about moving a cursor to a specific record within a set of records (documented here). In addition to finding a record, you can sort, filter, and loop a set of records (documented in their topics).

Corel Paradox: 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().

Syntax Example:

var
  tc TCursor
endVar

tc.open("Customer.db")

if tc.locate("Name", "Proffessional Divers, Ltd.") then 
  tc.edit()
  tc.Name = "Professional Divers, Ltd." 
  msgInfo("Success", "Corrected spelling error.") 
endIf

tc.endEdit()

[Not specified yet. Coming...]