SQL .mode add command

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

.mode add command

The ".mode" command is used to switch between the output formats shown above. This is an example to show the use of the .mode add command.

Use an overlay named Mastermap.gz to add Items with a feature code of 10172 to the current editable overlay enter the following at the SQL> prompt:

.mode add

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

---