SQL Control Bar

Check or uncheck View > Show/Hide > SQL to toggle the visibility of the SQL Control Bar.

.mode list command

The ".mode" command is used to switch between the output formats shown above.

This is an example of the .mode list command.

Values delimited by .separator strings

Use an overlay named Mastermap.gz to find Items with a feature code of 10172 and create a list of values delimited by separator strings enter the following at the SQL> prompt:

.mode list

select * from "Mastermap.gz" where featurecode=10172;

In this example the following will be shown:

The separator for columns and rows can be changed with the .separator command, ie:

.separator * -

will make * the column separator and - the row separator.

---