The DBbrowser notebook


sql-log area Home toolbar


The Dbbrowser notebook can hold different kind of pages , we will start with the most important one the dbbrowser page

The Dbbrowser :

After starting gmyclient the dbbrowser list is holding a list of the databases existing on your host
this is the databases view
double click on a database or return while a database is selected will move
the view one step deeper to the tables view.
double click on a table or return while a table is selected will move
the view one step deeper to the records view.

Depends on the current view of your dbbrowser the tool-bar provides you different action that could be performed

Tools
Databases View
Tables View
Records View
new row
create a new database
create a new table
insert a new data record in the current table
delete a row
delete database(s)
delete the selected table(s)
delete the selected data record(s)
edit
X
edit the selected table(s)
edit the selected data record(s)  
copy
X
copy  table(s)
copy record(s)
paste
X
paste table(s)
paste record(s)
filter
set database filter
set tables filter
set Records filter
save as
quick saves your data in the dbbrowser list as a tab separated file for more specified export use the the exporter (dumpout tool)


Filter dialog :

by clicking the filter icon filter the filter dialog will popup

filter

the filter icon at the top-right corner will appear if the any filter are set for the selected view. by clicking this icon you can disable/enable
the filter set .

you can set different filter for each table and for each database ,

global filter are used as default . if u change them this will affect every view , except if the view has a user specified filter .




sql-log area Home toolbar