Original Author Paul Laughton, 2011
Page 153
De Re BASIC!
The formation of the Where string is exactly the same as described in the Sql.query command. Both
Where and Count are optional. If the Where string is omitted all rows are deleted, and the Count
variable must be omitted, too.
Sql.update <DB_pointer_nvar>, <table_name_sexp>, C1$, V1$, C2$, V2$,...,CN$, VN${:
<where_sexp>}
In the named table of a previously opened database, change column values in specific rows selected by
the Where$ parameter <where_sexp>. The C$,V$ parameters must be in pairs. The colon character
terminates the C$,V$ list and must precede the Where$ in this command. The Where$ parameter and
preceding colon are optional.
BASIC! also uses the colon character to separate multiple commands on a single line. The use of a colon
in this command conflicts with that feature. Use caution when using both together.
If you put a colon on a line after this command, the preprocessor always assumes the colon is part of
the command and not a command separator. If you are not certain of the outcome, the safest action is
to put the Sql.update command on a line by itself, or at the end of a multi-command line.
Sql.exec <DB_pointer_nvar>, <command_sexp>
Execute ANY non-query SQL command string ("CREATE TABLE", "DELETE", "INSERT", etc.) using a
previously opened database.
Sql.raw_query <cursor_nvar>, <DB_pointer_nvar>, <query_sexp>
Execute ANY SQL Query command using a previously opened database and return a Cursor for the
results.
Graphics
Introduction
The Graphics Screen and Graphics Mode
Graphics are displayed on a new screen that is different from the BASIC! Text Output Screen. The Text
Output Screen still exists and can still be written to. You can be returned to the text screen using the
BACK key or by having the program execute the Gr.front command.
The Gr.open command opens the graphics screen and puts BASIC! into the graphics mode. BASIC! must
be in graphics mode before any other graphics commands can be executed. Attempting to execute any
graphics command when not in the graphics mode will result in a run-time error. The Gr.close command
closes the graphics screen and turns off graphics mode. The graphics mode automatically turns off when
the BACK key or MENU key is tapped. BASIC! will continue to run after the BACK key or MENU key is
tapped when in graphics mode but the Output Console will be shown.
The BASIC! Output Console is hidden when the graphics screen is being displayed. No run-time error
messages will be observable. A haptic feedback alert signals a run-time error. This haptic feedback will