SQL .mode line command

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

.mode line command

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

This is an example of the .mode line command.

Use an overlay named Mastermap.gz to find Items with a feature code of 10172 and list found items one value per line enter the following at the SQL> prompt:

.mode line

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

In this example the following will be shown:

The following will be shown for each found item:

---