Help On Line MySQL Connectus 0.3
Index
>>MenuFile
>>MenuOptions
>>MenuHelp
>>Query | Modification window
>>Table window
>> Tree
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.
Choosing this voice will appear a window in which you can insert a query
text and execute it.
Updein is a shorthand for Update/Insert/Delete . In this window you can
write and execute your modifications.
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.
Like Open query but for insert/delete/update with ".mod" extension.
Open a table with ".dat" extension. If file is corrupted an error message
will be shown.
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.
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 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 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 the program and save current settings if AutoConfig is enabled.
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.............)
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.This are a collections of styles available in every Java sdk provided Swing framework (1.4 or above).
A set of amazing themes with which you can custom your program.
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.
This html page will appear.
About the program author contact.
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.
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.
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.
A file choosing window will appear and there you can save your query.
Cancel the text and caret color is set to red indicating that the text is not reordered .
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.
Here you can save your table in a .dat file.
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