44
45
46
47
48
49
50
51
|
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
|
+
+
+
+
+
+
+
+
+
|
Executes the given command and waits for it to return.
<h2>SQL statement</h2>
Consists of a single SQL statement (which must not begin with a comment). Only one SQL statement is allowed; you are not allowed more than one. The statement is prepared when Free Hero Mesh starts. The statement should be [http://sqlite.org/lang_analyze.html|ANALYZE], [http://sqlite.org/lang_delete.html|DELETE], [http://sqlite.org/lang_insert.html|INSERT], [http://sqlite.org/lang_select.html|SELECT], [http://sqlite.org/lang_update.html|UPDATE], or [http://sqlite.org/lang_vacuum.html|VACUUM]; use the sqlInit resource if you need to execute other statements.
The SQL statement will be executed when the key/mouse is pushed. If there are any result rows, they are interpreted as follows: The first column is a string consisting of exactly two characters, telling what operation should be performed; the rest of the columns are the arguments. Any extra arguments are ignored, although since later versions of Free Hero Mesh might use them for something, it is recommended to use null values in the extra columns for compatibility with future.
If there any host parameters, they are interpreted as follows (all case case-insensitive):
* $X = X coordinate in playfield
* $Y = Y coordinate in playfield
* $LEVEL = Level order number (same as LEVEL() function)
* $LEVEL_ID = Level ID number (same as LEVEL_ID() function)
* :anything = Any host parameter name that starts with a colon means it will ask you when the key is pushed. If you push ctrl+C at the prompt then the command is cancelled.
Note that $LEVEL and $LEVEL_ID keep the same values for the entire statement, even though LEVEL() and LEVEL_ID() may give a different value if a different level is selected half way in between.
See also [SQL tables] and [SQL functions]. Extensions may define additional tables/functions that can be used.
|