Help On Line MySQL Connectus 0.3

 

 

Index   

>>MenuFile

>>MenuOptions

>>MenuHelp

>>Query | Modification window

>>Table window

>> Tree

 

 Menu File

Log in

Here you have to insert your user name and password to log in .

If you didn’t previously choose a password let it blank and press OK button.

If your user name or password are incorrect ,or you don’t have the necessary 

privileges  to access the selected DB, a message window will appear.

New query

Choosing this voice will appear a window in which you can insert a query

text and execute it.

New updein

Updein is a shorthand  for Update/Insert/Delete . In this window you can

write and execute your modifications.

Open query

Here you can open a file in which there is the text of a query. The file should be

with ".qry" extension but you can always load a ".txt" , an extentionless file

or however a file where a text is present.

Open updein

Like Open query but for insert/delete/update with ".mod" extension.

Open tables

Open a table with ".dat" extension. If file is corrupted an error message

will be shown.

 

Load and Execute Connection Script

This feauture allows you to load and execute a script file in a single step.

A well formed script file is as down here:

USER->username

PASSWORD->password

DBNAME->dbname

If you try loading a bad formed script this will be rejected and no connection made.

You may not to write the dbname , the program will show you that you didn't insert it but the

connection will be regularly enabled.

Change database

Pressing this button a dialog window will be shown asking you the name of the

DB you want to connect. If you're not logged in an error message will be

shown.

Show databases

Show databases present in the system accordingly to the access privileges of the user.

If the user is not logged in, a error window will be thrown .

Show relations

Show relations present in the db accordingly to the access privileges of the user.

If the user is not logged in, a error window will be thrown .

Exit

Exit the program and save current settings if AutoConfig is enabled.

 

 Menu Options

SubMenu LookAndFeel!

Windows Style

Selecting this option the program will be set in a ms windows fashion. If this theme

is not present on your sdk , the program won’t change its appearance. (WINDOWS theme is

affected by a little BUG.............)

Motif Style

This will set the program in a Motif fashion. If this theme

is not present on your sdk , the program won’t change its appearance.

SubMenu Java Styles

This are a collections of styles available in every Java sdk provided Swing framework (1.4 or above).

Ruby/Emerald/Aqua/Charcoal/Contrast themes

A set of amazing themes with which you can custom your program.

Auto Configuration

This feature allows you to choose if you want that the program would remember or not

your preferences selected in the running instance of the program.

Preferences are : running theme , and last selected script file.

For instance imagine you open the program then load a script and change theme

to Motif style : if autoconfig is enabled on the next start of the program Motif style

will be applied and the connection script will be automatically loaded.

This feature is based on config.txt file in \bin .

If config.txt is corrupted or an invalid fields is written or is absent an error message will be displayed ,

default parameters will be applied and when you choose exit to quit the program  config.txt

will be fixed up.

 Menu Help

Help On Line

This html page will appear.

About

About the program author contact.

 

 Query | Modification window

 

In this window you can insert your query | modification text.

By clicking right button you'll be prompted to a menu

in which you can choose to print ,cut,copy or paste the

selected text. If you choose print and there is no

selected text all the doc will be printed. The cut,paste,copy

features are at OS level and not internal so you can cut and paste

between other applications.

Well form

This button will reorder your query text . ( Available since ver. 0.2 )

The caret is changed red -->>  blue color indicating that the query has been reordered

at least once. The window is resized bigger.

WARNING : This is only an alfa version feauture so,if you found any unrecognised word

or in general an error , put one or more spaces between the uncorrect words then 

press "Well form"  button again. Now correctness of recognition is granted  only for query

and modifications and partial for tables,views,triggers,assertions,procedures,functions

absent for PSM and transactions.

Execute

Pushing this button the query will be executed and the results shown.

If no DB has been previously selected an error window will appear.

If any other SQL error is present in your query this will been shown by a

 message  window that will inform you of your error.

Save

A file choosing window will appear and there you can save your query.

Cancel

Cancel the text and caret color is set to red indicating that the text is not reordered .

 

 

 Table window

Print

By pressing this button you can print your table.

As you push this button a dialog window will appear asking you about

the columns spacing size. If you choose to close the window 90 dots will

be applied . If you don't have a printer an error message will be shown.  

Save

Here you can save your table in a .dat file.

 Tree

By double clicking on folders you can directly connect to your DBs.

By double clicking on relations a "SELECT * FROM relation" query

will be performed and the results shown. The table that you're showing

must be consistent with the current DB selected. If you show relation b

of DB A and than you connect to DB B  and press show realtions | databases 

button ,  relation b will be deleted because it's not consistent with

the current connection .

 

  For more information look at \MySQLConnectus\Docs\Index.htm