To/From Code

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

	Categories
BROWSEBYCATEGORY -Tool Basics Deployment Overview Development Tools File Extensions Overview and History Report Tools Overview +Language Basics +Language Details +Data Structures +Statements +Operators +Commands +Database +OOP Basics +OOP Details

	ObjectPAL Guides
ObjectPAL To/From Conversion Guides ObjectPAL and ASP Classic ObjectPAL and C# ObjectPAL and C++ ObjectPAL and C++/CLI ObjectPAL and Delphi ObjectPAL and Delphi Prism ObjectPAL and Java ObjectPAL and JavaScript ObjectPAL and Perl ObjectPAL and PHP ObjectPAL and VB Classic ObjectPAL and VB.Net

Cross Ref Guide

OBJECTPALLANGUAGE

ObjectPAL

OBJECTPALANDACCESS VBATOC

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 ► ObjectPAL ► Tool Basics

Find Record (Cross Ref > Tool Basics)

By Mike Prestwood

ObjectPAL versus Access VBA: A side by side comparison between ObjectPAL and Access VBA.

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).

ObjectPAL: 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...]