Differences

This shows you the differences between two versions of the page.

--- guides:programming:programmers_reference_manual:btree.extract [2025/06/24 19:31] – bshumsky
+++ guides:programming:programmers_reference_manual:btree.extract [2025/06/24 19:34] (current) – bshumsky
@@ Line 52: / Line 52: @@
 Btree.Extract(search_criteria, table, @DICT, keylist, option, flag)
 Return keylist
-Searching by NOT                The search values in //srch_strng// are substrings, and as such, you can modify the search relations using substring search characters. For example,
+</code>
+=== Searching by NOT ===
+The search values in //srch_strng// are substrings, and as such, you can modify the search relations using substring search characters. For example,
 srch_strng = "COMPANY_NAME":@VM:"#TRUST INSURANCE":@FM
 will find all values of the indexed column COMPANY_NAME that are not "TRUST INSURANCE".
-Searching by BETWEEN            Btree.Extract supports a special search operator, **between** ("~" (tilde)). The operator **between** differs from **range** in that it is not inclusive. For example, the following search string will return row keys for all rows having ZIP codes between, but not including, 98100 and 98111:
+=== Searching by BETWEEN ===
+Btree.Extract supports a special search operator, **between** ("~" (tilde)). The operator **between** differs from **range** in that it is not inclusive. For example, the following search string will return row keys for all rows having ZIP codes between, but not including, 98100 and 98111:
 srch_strng = "ZIP":@VM:"98100~98111":@FM
-Searching by AND                As noted above, multiple search criteria are linked with an implicit And. The OpenList filter sub-statement With STATE = "CT" And CITY = "Stamford" is performed in Btree.Extract by the code:
+=== Searching by AND ====
+As noted above, multiple search criteria are linked with an implicit And. The OpenList filter sub-statement With STATE = "CT" And CITY = "Stamford" is performed in Btree.Extract by the code:
 "STATE":@VM:"CT":@FM:"CITY":@VM:"Stamford":@FM
-Searching by OR                 To change the implicit And to an Or, insert a semicolon (;) before each search value in the second (and subsequent) search column(s). The statement With STATE = "CT" Or CITY = "Stamford" is performed in Btree.Extract by the code:
+=== Searching by OR ===
+To change the implicit And to an Or, insert a semicolon (;) before each search value in the second (and subsequent) search column(s). The statement With STATE = "CT" Or CITY = "Stamford" is performed in Btree.Extract by the code:
 "STATE":@VM:"CT":@FM:"CITY":@VM:";Stamford":@FM
-Starting, Ending, and ContainingThe "starting with" indicator (]) is also a valid search string argument.  To extract keys of all rows with City starting with S, code the following search string:
+=== Starting, Ending, and Containing ===
+The "starting with" indicator (]) is also a valid search string argument.  To extract keys of all rows with City starting with S, code the following search string:
 srch_strng = "CITY":@VM:"S]":@FM
@@ Line 77: / Line 97: @@
 srch_strng = "CITY":@VM:"[P]":@FM
-====   ====
-</code>