The FindItems function compares values from the source table and adds search results to the target table.
If erase is false, target table fields are not modified. Otherwise the target table is cleared and source table fields are added to it.
Syntax
Integer Table.FindItems(
Table result,
String field,
String sign = "==",
String value = "",
Integer erase = true)
Table result,
String field,
String sign = "==",
String value = "",
Integer erase = true)
Parameters
| result | The target table to store results. | Required |
|---|---|---|
| field | The name of the field. | Required |
| sign | The comparison sign. Value list that can be used: "==", "!=", "<", ">", "<=", ">=", "?=" | Optional |
| value | The value to compare. | Optional |
| erase true, false | Erase target table data and add all the same fields. | Optional |
Return value
The FindItems function returns the number of results.
Example
Integer i
Table results new
myTable.FindItems(results, "Job", "==", "Programmer")
for i=0 ; i<results.GetItemCount() ; i++
// Your code here
end
Table results new
myTable.FindItems(results, "Job", "==", "Programmer")
for i=0 ; i<results.GetItemCount() ; i++
// Your code here
end