Great Engine Studio - Website database develop tools,Database document server,VB develop tools
Great Engine Studio - Website database develop tools,Database document server,VB develop tools
Home
Donwload
Documents
FAQ
Friends
 
Great Engine Studio->Documents->Great Engine Web DB Browser 2007-->[1][2][3][4][5]{6}[7]
 

Browse database objects and input remark information

There are Database object browse box tree in the left side of Great Engine Web DB Browser, the level is:

Web DB

This level is Database connect, you can start the Web DB upload guide, create new database connect, browse database connect by click right key.

Database Connection

This level is database, you can start new connect, browse database by click right key.

Databases

This level is system table, table, view, Stored Procedures; you can start browse system table, table, view, Stored Procedures and so on by click right key.

System Tables

This level is columns structure; you can start browse table (view) contents, table (view) structure by click right key.

Tables

This level is columns, key, index, reference, referenced. The next level is Columns structure, Index, Primary key and foreign key in reference; you can start operation of copy SQL sentences to clipboard and view table (view) contents, table (view) structure, key and index by click right key.

Views

This level is columns; you can start view table (view) contents, table (view) structure by click right key.

Stored Procedures

This level is parameter of Stored Procedures, you can start enter parameter Stored Procedure¡¯s by click right key.

 

 

Great Engine Web DB Browser - Browse database objects and input remark information

 


Copy name or remark information to clipboard

To the information of table, view, columns of table and view ,Stored Procedures, parameter of Stored Procedures, you can copy to clipboard by click right key menu.

 

Property

Use the right key menu you can start the dialog box of database property to check the detail and remark it.

Great Engine Web DB Browser - Database Object Property

Operator Tables

You can start to view table (view) contents by click right key menu in table object; you can start to insert new record, edit current record, delete record and sort ascending by selected columns, sort descending by selected columns.

Provide a multi-lines text box to edit the text which new line character.

Use Toolbar

You can use toolbar to run some operation by shortcut. The function button including :Web DB Server Script upload guide ,Add new script ,Open script, Save script, Property, Cut, Copy, Paste, Delete, Undo, Find, Refresh, Browse table content, Add new row, Change edit mode, enter SELECT, enter UPDATE, enter INSERT, enter DELETE, Convert to capital, Convert to lowercase, Convert to first letter capital, Execute SQL, Pause Execute SQL, View next record set ,help.

Great Engine Web DB Browser - Toolsbar

ʹÓÃÈȼü

Ctrl-S

Set the edit mode between browse and edit rows

Ctrl-N

Insert the new row

Ctrl-Y

Delete current row

Ctrl-M

Change to Multi-Rows edit or view mode

Ctrl-U

Convert to capital

Ctrl-I

Convert to lowercase

Ctrl-O

Convert to first letter capital

Useing command box and operator SQL script file

You can use command box to write SQL, each connection has an independent SQL enter box, you can start to execute SQL by select some SQL sentences or all of them in text box. You can save or open these SQL by operation of create new script, save script, script saves as. 5 SQL scripts open recently will be show in the lower of the file menu.

Operator query result

View the database documents, contents of table and execute SQL will return a result of query. The result will be show in grid. And to all the result you can copy the row name and column name, copy multi-rows and multi-columns .For the result of view and execute SQL you can show it in multi-pages. If the result has more record set, you can choose to show next record set.

Running Messages

The information of event during the running of software, success operation and fail operation will be mark in message text box. For each operation will show the operation time and others.

Great Engine Web DB Browser - Running Messages

Multi-language Version

There are many connections build in software to support multi-language, each information about this language will be save in the file *.ml. On the menu of "File-language" you can change the language of current interface.

The way to create multi-language file is check the language district code in LangFileName.txt under Lang directory. For example, the language district code of China if 2052, then the multi-language file of China is WebDB_2052.ml and help file is WebDB_2052.chm.

The way to create help file is select the language file you know, then use the HTML Help of Microsoft to recompile CHM help file, after translate it then compile to CHM help file. About the operation of HTML Help, please read the documents of Microsoft.


Anyone can make and upload the multi-language file and help file of this software, but you must keep the name of this software, the author and Great Engine Studio.