ASP Classic:
Find, Seek
In ASP, using ADO, you use Find and Seek to move a cursor of a RecordSet to a matching record.
|
Syntax Example:
Given a valid ADO recordset, the following code snippet finds a specific user and prints out their age: TC.Find " UserID='mprestwood' "
Response.Write TC.Fields("Age")
More Info
|
|
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()
More Info
|
|
To/From Code
Print This
To/From Code Guide: 
