Programmer Guide/Command Reference/QUERY - Revision history

Jw at 10:47, 16 May 2018

2018-05-16T10:47:06Z

← Older revision		Revision as of 12:47, 16 May 2018
Line 1:		Line 1:
	{{DISPLAYTITLE:{{SUBPAGENAME}}}}		{{DISPLAYTITLE:{{SUBPAGENAME}}}}
	The <code>QUERY</code> command, although similar to the <code>[[Programmer Guide/Command Reference/FIND\|FIND]]</code> command, offers the programmer more choice in how to search.		The <code>QUERY</code> command, although similar to the <code>[[Programmer Guide/Command Reference/FIND\|FIND]]</code> command, offers the programmer more choice in how to search. It returns the zero-based index of the first entry matching the search criteria, or an empty string if the search criteria were not matched.

	#pos := QUERY [ /i ] [ /t ] [ /m=<var>matchtype</var> ] [[Programmer_Guide/Command_Reference_Options/-\|/-]] <var>table</var> <var>startentry</var> <var>field</var> <var>querystring</var>		#pos := QUERY [ /i ] [ /t ] [ /m=<var>matchtype</var> ] [[Programmer_Guide/Command_Reference_Options/-\|/-]] <var>table</var> <var>startentry</var> <var>field</var> <var>querystring</var>

Jw at 10:45, 16 May 2018

2018-05-16T10:45:46Z

← Older revision		Revision as of 12:45, 16 May 2018
Line 2:		Line 2:
	The <code>QUERY</code> command, although similar to the <code>[[Programmer Guide/Command Reference/FIND\|FIND]]</code> command, offers the programmer more choice in how to search.		The <code>QUERY</code> command, although similar to the <code>[[Programmer Guide/Command Reference/FIND\|FIND]]</code> command, offers the programmer more choice in how to search.

	QUERY [ /i ] [ /t ] [ /m=<var>matchtype</var> ] [[Programmer_Guide/Command_Reference_Options/-\|/-]] <var>table</var> <var>startentry</var> <var>field</var> <var>querystring</var>		#pos := QUERY [ /i ] [ /t ] [ /m=<var>matchtype</var> ] [[Programmer_Guide/Command_Reference_Options/-\|/-]] <var>table</var> <var>startentry</var> <var>field</var> <var>querystring</var>

	QUERY /m=find <var>table</var> <var>startentry</var> <var>cepr</var> [ <var>copr</var> <var>cexpr</var> ... ] [ /t ] // works like <code>[[Programmer_Guide/Shell_Items/Table/SET_TABLE#FINDEXPR\|SET table FIND]]</code>		#pos := QUERY /m=find <var>table</var> <var>startentry</var> <var>cepr</var> [ <var>copr</var> <var>cexpr</var> ... ] [ /t ] // works like <code>[[Programmer_Guide/Shell_Items/Table/SET_TABLE#FINDEXPR\|SET table FIND]]</code>

	;<var>matchtype</var>: one of the keywords <code>regular</code>, <code>wildcard</code>, <code>substring</code>, <code>full</code>, and <code>find</code>.		;<var>matchtype</var>: one of the keywords <code>regular</code>, <code>wildcard</code>, <code>substring</code>, <code>full</code>, and <code>find</code>.

Christian at 13:58, 28 April 2014

2014-04-28T13:58:28Z

@@ Line 1: / Line 1: @@
 {{DISPLAYTITLE:{{SUBPAGENAME}}}}
 The <code>QUERY</code> command, although similar to the <code>[[Programmer Guide/Command Reference/FIND|FIND]]</code> command, offers the programmer more choice in how to search.
-<code>QUERY [ /i ] [ /t ] [ /m=<var>matchtype</var> ] /- <var>table startentry</var> <var>field</var> <var>querystring</var></code>
+ QUERY [ /i ] [ /t ] [ /m=<var>matchtype</var> ] [[Programmer_Guide/Command_Reference_Options/-|/-]] <var>table</var> <var>startentry</var> <var>field</var> <var>querystring</var>
-:The search will be case insensitive (by default, it is case sensitive).
+ QUERY /m=find <var>table</var> <var>startentry</var> <var>cepr</var> [ <var>copr</var> <var>cexpr</var> ... ] [ /t ] // works like <code>[[Programmer_Guide/Shell_Items/Table/SET_TABLE#FINDEXPR|SET table FIND]]</code>
-;<var>/t</var>
+;<var>matchtype</var>: one of the keywords <code>regular</code>, <code>wildcard</code>, <code>substring</code>, <code>full</code>, and <code>find</code>.
 :<var>querystring</var> will be considered a POSIX regular expression.
+;<code>/m=wildcard</code>
-;<var>/m=wildcard</var>
+:<var>querystring</var> will be considered an {{STX}} wildcard expression (just like <code>[[Programmer Guide/Command Reference/FIND|FIND]]</code>).
+;<code>/m=substring</code>: All characters in <var>querystring</var> will be considered autonomous, i.e. naming themselves. The <code>[[Programmer Guide/Command Reference/FIND|FIND]]</code> command will find the first entry of which <var>querystring</var> is a substring.
-:<var>querystring</var> will be considered an S_TOOLS-STx wildcard expression (just like <code>[[Programmer Guide/Command Reference/FIND|FIND]]</code>).
+;<code>/m=full</code>:All characters in <var>querystring</var> will be considered autonomous, i.e. naming themselves. The <code>[[Programmer Guide/Command Reference/FIND|FIND]]</code> command will find the first entry whose content is exactly identical to <var>querystring</var> (with the possible exception of case).
+;<code>[[Programmer_Guide/Command_Reference_Options/-|/-]]</code>: You should always use the [[Programmer_Guide/Command_Reference_Options/-|/-]] "non-option" option before the first argument in order not to cause arguments to be mistaken for options.

Christian: Reverted edits by Christian (talk) to last revision by Admin

2014-04-28T13:52:44Z

Reverted edits by Christian (talk) to last revision by Admin

@@ Line 1: / Line 1: @@
 {{DISPLAYTITLE:{{SUBPAGENAME}}}}
 The <code>QUERY</code> command, although similar to the <code>[[Programmer Guide/Command Reference/FIND|FIND]]</code> command, offers the programmer more choice in how to search.
- QUERY [ /i ] [ /t ] [ /m=<var>matchtype</var> ] [[Programmer_Guide/Command_Reference_Options/-|/-]] <var>table</var> <var>startentry</var> <var>field</var> <var>querystring</var>
+<code>QUERY [ /i ] [ /t ] [ /m=<var>matchtype</var> ] /- <var>table startentry</var> <var>field</var> <var>querystring</var></code>
- QUERY /m=find <var>table</var> <var>startentry</var> <var>cepr</var> [ <var>copr</var> <var>cexpr</var> ... ] [ /t ] // works like <code>[[Programmer_Guide/Shell_Items/Table/SET_TABLE#FINDEXPR|SET table FIND]]</code>
+:The search will be case insensitive (by default, it is case sensitive).
-;<var>matchtype</var>: one of the keywords <code>regular</code>, <code>wildcard</code>, <code>substring</code>, <code>full</code>, and <code>find</code>.
+;<var>/t</var>
 :<var>querystring</var> will be considered a POSIX regular expression.
-;<code>/m=wildcard</code>
-:<var>querystring</var> will be considered an {{STX}} wildcard expression (just like <code>[[Programmer Guide/Command Reference/FIND|FIND]]</code>).
+;<var>/m=wildcard</var>
-;<code>/m=substring</code>: All characters in <var>querystring</var> will be considered autonomous, i.e. naming themselves. The <code>[[Programmer Guide/Command Reference/FIND|FIND]]</code> command will find the first entry of which <var>querystring</var> is a substring.
-;<code>/m=full</code>:All characters in <var>querystring</var> will be considered autonomous, i.e. naming themselves. The <code>[[Programmer Guide/Command Reference/FIND|FIND]]</code> command will find the first entry whose content is exactly identical to <var>querystring</var> (with the possible exception of case).
+:<var>querystring</var> will be considered an S_TOOLS-STx wildcard expression (just like <code>[[Programmer Guide/Command Reference/FIND|FIND]]</code>).
-;<code>[[Programmer_Guide/Command_Reference_Options/-|/-]]</code>: You should always use the [[Programmer_Guide/Command_Reference_Options/-|/-]] "non-option" option before the first argument in order not to cause arguments to be mistaken for options.

Christian at 13:42, 28 April 2014

2014-04-28T13:42:21Z

← Older revision		Revision as of 15:42, 28 April 2014
Line 12:		Line 12:
	;<var>field</var>: the table field to search.		;<var>field</var>: the table field to search.
	;<var>querystring</var>: the string to search for.		;<var>querystring</var>: the string to search for.
	;<var>cexpr</var>, <var>copr</var> <var>cexpr</var>: ~~see <code>[[~~Programmer_Guide/~~Shell_Items~~/~~Table/SET_TABLE#FINDEXPR\|SET table FIND]]</code>.~~		;<var>cexpr</var>, <var>copr</var> <var>cexpr</var>: {{:Programmer_Guide/General_Descriptions/Find_Expressions}}
	;<code>/i</code>: The search will be case insensitive (by default, it is case sensitive).		;<code>/i</code>: The search will be case insensitive (by default, it is case sensitive).
	;<code>/t</code>: only tagged table entries will be considered.		;<code>/t</code>: only tagged table entries will be considered.

Christian at 13:38, 28 April 2014

2014-04-28T13:38:35Z

← Older revision		Revision as of 15:38, 28 April 2014
Line 12:		Line 12:
	;<var>field</var>: the table field to search.		;<var>field</var>: the table field to search.
	;<var>querystring</var>: the string to search for.		;<var>querystring</var>: the string to search for.
	;<var>cexpr</var>, <var>copr</var> <var>cexpr</var>: see <code>[[Programmer_Guide/Shell_Items/Table/SET_TABLE#~~FIND~~\|SET table FIND]]</code>.		;<var>cexpr</var>, <var>copr</var> <var>cexpr</var>: see <code>[[Programmer_Guide/Shell_Items/Table/SET_TABLE#FINDEXPR\|SET table FIND]]</code>.
	;<code>/i</code>: The search will be case insensitive (by default, it is case sensitive).		;<code>/i</code>: The search will be case insensitive (by default, it is case sensitive).
	;<code>/t</code>: only tagged table entries will be considered.		;<code>/t</code>: only tagged table entries will be considered.

Christian at 13:37, 28 April 2014

2014-04-28T13:37:02Z

← Older revision		Revision as of 15:37, 28 April 2014
Line 4:		Line 4:
	QUERY [ /i ] [ /t ] [ /m=<var>matchtype</var> ] [[Programmer_Guide/Command_Reference_Options/-\|/-]] <var>table</var> <var>startentry</var> <var>field</var> <var>querystring</var>		QUERY [ /i ] [ /t ] [ /m=<var>matchtype</var> ] [[Programmer_Guide/Command_Reference_Options/-\|/-]] <var>table</var> <var>startentry</var> <var>field</var> <var>querystring</var>

	QUERY /m=find <var>table</var> <var>startentry</var> <var>cepr</var> [ <var>copr</var> <var>cexpr</var> ... ] [ /t ] // works like <code>[[Programmer_Guide/Shell_Items/Table/SET_TABLE#~~FIND~~\|SET table FIND]]</code>		QUERY /m=find <var>table</var> <var>startentry</var> <var>cepr</var> [ <var>copr</var> <var>cexpr</var> ... ] [ /t ] // works like <code>[[Programmer_Guide/Shell_Items/Table/SET_TABLE#FINDEXPR\|SET table FIND]]</code>

	;<var>matchtype</var>: one of the keywords <code>regular</code>, <code>wildcard</code>, <code>substring</code>, <code>full</code>, and <code>find</code>.		;<var>matchtype</var>: one of the keywords <code>regular</code>, <code>wildcard</code>, <code>substring</code>, <code>full</code>, and <code>find</code>.

Christian at 13:34, 28 April 2014

2014-04-28T13:34:35Z

← Older revision		Revision as of 15:34, 28 April 2014
Line 13:		Line 13:
	;<var>querystring</var>: the string to search for.		;<var>querystring</var>: the string to search for.
	;<var>cexpr</var>, <var>copr</var> <var>cexpr</var>: see <code>[[Programmer_Guide/Shell_Items/Table/SET_TABLE#FIND\|SET table FIND]]</code>.		;<var>cexpr</var>, <var>copr</var> <var>cexpr</var>: see <code>[[Programmer_Guide/Shell_Items/Table/SET_TABLE#FIND\|SET table FIND]]</code>.
	;<~~var~~>/i</~~var~~>: The search will be case insensitive (by default, it is case sensitive).		;<code>/i</code>: The search will be case insensitive (by default, it is case sensitive).
	;<~~var~~>/t</~~var~~>: only tagged table entries will be considered.		;<code>/t</code>: only tagged table entries will be considered.
	;<~~var~~>/m=regular</~~var~~>		;<code>/m=regular</code>
	:<var>querystring</var> will be considered a POSIX regular expression.		:<var>querystring</var> will be considered a POSIX regular expression.
	;<~~var~~>/m=wildcard</~~var~~>		;<code>/m=wildcard</code>
	:<var>querystring</var> will be considered an {{STX}} wildcard expression (just like <code>[[Programmer Guide/Command Reference/FIND\|FIND]]</code>).		:<var>querystring</var> will be considered an {{STX}} wildcard expression (just like <code>[[Programmer Guide/Command Reference/FIND\|FIND]]</code>).
	;<~~var~~>/m=substring</~~var~~>: All characters in <var>querystring</var> will be considered autonomous, i.e. naming themselves. The <code>[[Programmer Guide/Command Reference/FIND\|FIND]]</code> command will find the first entry of which <var>querystring</var> is a substring.		;<code>/m=substring</code>: All characters in <var>querystring</var> will be considered autonomous, i.e. naming themselves. The <code>[[Programmer Guide/Command Reference/FIND\|FIND]]</code> command will find the first entry of which <var>querystring</var> is a substring.
	;<~~var~~>/m=full</~~var~~>:All characters in <var>querystring</var> will be considered autonomous, i.e. naming themselves. The <code>[[Programmer Guide/Command Reference/FIND\|FIND]]</code> command will find the first entry whose content is exactly identical to <var>querystring</var> (with the possible exception of case).		;<code>/m=full</code>:All characters in <var>querystring</var> will be considered autonomous, i.e. naming themselves. The <code>[[Programmer Guide/Command Reference/FIND\|FIND]]</code> command will find the first entry whose content is exactly identical to <var>querystring</var> (with the possible exception of case).
	;<~~var~~>[[Programmer_Guide/Command_Reference_Options/-\|/-]]</~~var~~>: You should always use the [[Programmer_Guide/Command_Reference_Options/-\|/-]] "non-option" option before the first argument in order not to cause arguments to be mistaken for options.		;<code>[[Programmer_Guide/Command_Reference_Options/-\|/-]]</code>: You should always use the [[Programmer_Guide/Command_Reference_Options/-\|/-]] "non-option" option before the first argument in order not to cause arguments to be mistaken for options.

Christian at 16:48, 25 April 2014

2014-04-25T16:48:56Z

← Older revision		Revision as of 18:48, 25 April 2014
Line 12:		Line 12:
	;<var>field</var>: the table field to search.		;<var>field</var>: the table field to search.
	;<var>querystring</var>: the string to search for.		;<var>querystring</var>: the string to search for.
	;<var>cexpr, copr cexpr</var>: see <code>[[Programmer_Guide/Shell_Items/Table/SET_TABLE#FIND\|SET table FIND]]</code>.		;<var>cexpr</var>, <var>copr</var> <var>cexpr</var>: see <code>[[Programmer_Guide/Shell_Items/Table/SET_TABLE#FIND\|SET table FIND]]</code>.
	;<var>/i</var>: The search will be case insensitive (by default, it is case sensitive).		;<var>/i</var>: The search will be case insensitive (by default, it is case sensitive).
	;<var>/t</var>: only tagged table entries will be considered.		;<var>/t</var>: only tagged table entries will be considered.

Christian at 16:47, 25 April 2014

2014-04-25T16:47:02Z

← Older revision		Revision as of 18:47, 25 April 2014
Line 2:		Line 2:
	The <code>QUERY</code> command, although similar to the <code>[[Programmer Guide/Command Reference/FIND\|FIND]]</code> command, offers the programmer more choice in how to search.		The <code>QUERY</code> command, although similar to the <code>[[Programmer Guide/Command Reference/FIND\|FIND]]</code> command, offers the programmer more choice in how to search.

	QUERY [ /i ] [ /t ] [ /m=<var>matchtype</var> ] [[Programmer_Guide/Command_Reference_Options/-\|/-]] <var>table startentry</var> <var>field</var> <var>querystring</var>		QUERY [ /i ] [ /t ] [ /m=<var>matchtype</var> ] [[Programmer_Guide/Command_Reference_Options/-\|/-]] <var>table</var> <var>startentry</var> <var>field</var> <var>querystring</var>

	QUERY /m=find <var>table</var> <var>startentry</var> <var>cepr</var> [ <var>copr</var> <var>cexpr</var> ... ] [ /t ] // works like <code>[[Programmer_Guide/Shell_Items/Table/SET_TABLE#FIND\|SET table FIND]]</code>		QUERY /m=find <var>table</var> <var>startentry</var> <var>cepr</var> [ <var>copr</var> <var>cexpr</var> ... ] [ /t ] // works like <code>[[Programmer_Guide/Shell_Items/Table/SET_TABLE#FIND\|SET table FIND]]</code>