Profile Window

The Main Profile Window is intended for representing the database and profile objects and provides all main functions for working with them. This window is opened automatically on creating a new profile, opening a profile file, or connecting to a database from the Quick Connect group of the Getting Started Pane. Closing the profile window closes all profile-related windows (e.g. Table Designer, Data Grid, Relationships Manager, etc).

The main toolbar and the popup menu of the Main Profile Window provides the following functions:

Connect to Database

Connects to the profile database, using the connection and authorization properties, specified within the Profile Properties dialog.

Disconnect from Database

Disconnects from the profile database.

Refresh

Refreshes the object list on the current page (e.g tables or users).

Open

Opens the selected object for data viewing (table, query, or form) or opens the selected user for editing.

Design

Opens the selected object for editing in design view.

New

Opens the New Object Dialog, which allows you to create a new table, query, form, or user within the appropriate wizard, designer, or in some other way.

Delete

Deletes the selected object from the database (table, user) or from the profile (query, form).

Cut

Copies the selected object into the clipboard and deletes it from the database/profile.

Copy

Copies the selected object into the clipboard, allowing you to paste it into the same database/profile with another name, or into another database/profile.

Paste

Pastes an object from the clipboard (a table, a query, a form, or a user) into the database/profile.

The view buttons (Large Icons, Small Icons, List, Details) allow you to switch the view mode for the list of object.

The Main Profile Window consist of several pages: Tables, Queries, Forms, Users, and Favorites. Pages can be switched using the appropriate headers on the left side of the window.

These pages are briefly described below.

Tables

This page contains list of database tables. Double click on a table name to open the table data grid. To edit table select required table and click Design button at the window toolbar or double-click the table with the Ctrl button pressed. Please examine the Table in Main Profile Window section for detailed information.

Queries

This page contains list of queries, stored in a profile. Query is an SQL statement or a number of statements, which can be called at any time for data viewing or modification. Double click on a query name to run it and view data grid with query execution result. To edit query, click the Design button at the window toolbar or double-click the query with the Ctrl button pressed. Please examine the Queries Page in Profile Window section for detailed information.

Forms

This page contains list of data forms, stored in a profile. Forms provide a quick and easy way to view, modify and insert records into your database tables. They are constructed using standard controls, which are linked to table columns or SQL queries. To open the form, double click on its name. To modify the form, select it and click Design button at the window toolbar or double-click the form with the Ctrl button pressed. Please examine the Forms Page in Profile Window section for detailed information.

Users

In this page you can view the list of your MySQL server users, and if you have enough rights, modify the security policy of your server. To edit user, double click on its name. Please examine the Users Page in Profile Window section for detailed information.

Favorites

The Favorites page is intended for storing links to database table and profile objects. These links allow you to access your "favorite" objects faster. To add a table, a query, a form or a user to your favorites, drag it from appropriate list and drop onto the Favorites page. Double-clicking the Favorites item opens the appropriate table, query, or form data, or opens a user for editing.

Database Profile: Database Profiles