Active Table Editor User Manual
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Active Table Editor User Manual as PDF for free.
More details
- Words: 2,702
- Pages: 36
Active Table Editor User manual
© DB Software Laboratory 2008 www.dbsoftlab.com
Active Table Editor User Manual
Contents Contents....................................................................................................................................... 2 1. Introduction ............................................................................................................................. 3 2. Requirements........................................................................................................................... 3 3. Key features............................................................................................................................. 4 4. Active Table Editor Architecture ............................................................................................ 5 5. Getting Started......................................................................................................................... 6 6. Options .................................................................................................................................... 7 7. User Interface .......................................................................................................................... 9 Main window........................................................................................................................... 9 Outlook Bar ........................................................................................................................... 10 8. Connections ........................................................................................................................... 11 9. Menu Items............................................................................................................................ 12 Table Item.............................................................................................................................. 15 Record Item ........................................................................................................................... 16 Table/Record Item................................................................................................................. 17 10. Forms Designer ................................................................................................................... 18 Designer Screen Overview.................................................................................................... 19 11. Menu Designer .................................................................................................................... 20 Creating a new Menu ............................................................................................................ 21 Creating new Menu Item....................................................................................................... 22 Speeding up Menu creation................................................................................................... 23 12. Users .................................................................................................................................... 24 13. Groups ................................................................................................................................. 27 Access Rights ........................................................................................................................ 29 14. SQL ..................................................................................................................................... 31 Screen Overview ................................................................................................................... 31 SQL Toolbar.......................................................................................................................... 32 Side toolbar............................................................................................................................ 32 15. Support Procedure ............................................................................................................... 33 16. License Agreement.............................................................................................................. 34
DB Software Laboratory
2 of 36
Active Table Editor User Manual
1. Introduction Active Table Editor is software utility designed to give end user ability edit data quickly in any database.
2. Requirements Below is the list of Software that must be installed before the installation of Active Table Editor:
Software Microsoft Windows MDAC
Version 98 or higher 2.6 or higher
Microsoft Jet 4.0
Service pack 5 or higher 3.51.12 or higher
www.mysql.com
8.01.01 or higher
www.postgresql.com
1.02.00 or higher
www.ibphenix.com
7.3.4 or higher
Provided by Oracle
MySql ODBC Driver PostgreSql ODBC Driver Firebird ODBC Driver Oracle Client
Notes Part of OS on W2K and XP For MS Access repository For MySql repository For PostgreSql repository For Interbase/FireFox repository Only to connect to Oracle repository
Note: Depending on the Requirements you may or may not need to have all components installed
DB Software Laboratory
3 of 36
Active Table Editor User Manual
3. Key features This product features: • • • • • • • • • •
Easy Tables editing Comprehensive security management User definable Menus User definable Input Forms Unlimited number of Users and Groups Repository Creation Wizard Easy Repository switching Repository Import and Export SQL Editor Integrated SQL Builder
Active Table Editor uses repository to store following information • • • • •
Users Groups Access Rights Menus Database Connections
Repository Creation scripts are provided for following databases: • • • • • •
MS Access Oracle MS Sql Server Interbase/Firebird MySQL PostgreSQL
Note: Once installation is completed you may find all the scripts in C:\Program Files\DB Software Laboratory\Active Table Editor Folder.
DB Software Laboratory
4 of 36
Active Table Editor User Manual
4. Active Table Editor Architecture
Active Table Editor
Any List of M Database
Connections Menu Items Forms Designer Menu Designer Security SQL Editor
ODBC
End Users
Data Sources
Oracle, MS SQL Server. MS ACCESS, MySQL, PostgreSQL or Interbase
DB Software Laboratory
5 of 36
Active Table Editor User Manual
5. Getting Started Repository creation Use wizard provided to create the repository or alternatively you may use default MS Access Repository. To Start Active Table Editor Click Start -> All Programs -> DB Software Laboratory -> Active Table Editor-> Active Table Editor Login Box will appear Change Repository Connection Options
Enter user name and password to login Notes: Default password for user Administrator is Administrator You may bypass login screen by running application as follows ATEditor.exe User=Administrator;Password=Administrator
DB Software Laboratory
6 of 36
Active Table Editor User Manual
6. Options To change Active Table Editor Settings click System menu-> File-> Options. Dialog box will appear. Change Repository Connection
Delete Repository Connection
Create new Repository Connection
DB Software Laboratory
7 of 36
Active Table Editor User Manual
DB Software Laboratory
8 of 36
Active Table Editor User Manual
7. User Interface Main window System Menu
Outlook Bar Status bar
DB Software Laboratory
9 of 36
Active Table Editor User Manual
Outlook Bar Active Table Editor uses Outlook bar to provide the user with an easy access to the main functions of application. Below is a list of Outlook bar items with the short descriptions:
Connections
Defines connections to Data Sources
Menu Items
Defines Menu Items
Menu Designer
Defines Application Menu
Users
Defines list of Active Table Editor Users
Groups
Defines list of Active Table Editor Groups
SQL Scripts
Provides functionality to run SQL statements against target Data Sources and quick way to browse and edit data
Notes: All Outlook bar items above are available only to the members of Administrators group.
DB Software Laboratory
10 of 36
Active Table Editor User Manual
8. Connections In order to edit data Active Table Editor must be able to connect to one or more Data sources. To create a new connection Click Outlook Bar-> Management-> Connections->Plus Icon.
• • • •
Dialog box will appear. In the Name Text Box type in a new name for the connection you are about to create Select a ODBC DSN Name from the Drop Down List Fill in Username/Password for the database you wish to connect to a. You may use ODBC admin to create/modify ODBC data sources.
•
Click Test to ensure the details you have provided are correct DB Software Laboratory
11 of 36
Active Table Editor User Manual
9. Menu Items Menu Items are the construction blocks we use to design user menus. In another words Menu item is a result of execution of SQL statement associated with Icon and appropriate Description. List of Menu Items
List of Menu Items available to current user
DB Software Laboratory
12 of 36
Active Table Editor User Manual
SQL Builder
DB Software Laboratory
13 of 36
Active Table Editor User Manual
DB Software Laboratory
14 of 36
Active Table Editor User Manual
There three types of items end user can use 1. Table 2. Record 3. Table/Record Table Item Item Description
Menu Item Icon
Data Grid populated with results of SQL execution
List of available actions is defined by the user security rights
DB Software Laboratory
15 of 36
Active Table Editor User Manual
Record Item
Designer Button is available only to Ad i i t t
Navigation Buttons
Once logged in as an Administrator you are able to change this form layout by modifying existing objects and adding/deleting the old ones
DB Software Laboratory
16 of 36
Active Table Editor User Manual
Table/Record Item Press to switch from table to record view
DB Software Laboratory
17 of 36
Active Table Editor User Manual
10. Forms Designer Once logged in as an Administrator it is possible change Record and Table/Record item layout by modifying existing objects and adding/deleting the old ones. Press to show Forms Designer
DB Software Laboratory
18 of 36
Active Table Editor User Manual
Designer Screen Overview Select an Object, than click on the panel to add it
Select an objects to modify its’ Properties
Select a field to link the object to
You may move objects and resize then by using mouse
DB Software Laboratory
19 of 36
Active Table Editor User Manual
11. Menu Designer Every user has a menu assigned. List of items accessible by the user is defined by its access rights. Every menu consists of a root folder subfolders and items. Menu
List of Menus
Drag and Drop Items
Note: Administrator’s Menu is populated automatically when new Menu item is created.
DB Software Laboratory
20 of 36
Active Table Editor User Manual
Creating a new Menu
• • •
To create a new Menu click Pop up menu-> Add. Fill in Menu Name you are about to create. Click OK to finish creation of Menu.
DB Software Laboratory
21 of 36
Active Table Editor User Manual
Creating new Menu Item
• • • •
To create a new Menu Item click Pop up menu-> Add. Choose appropitate Item Type from Radio Group Fill in Item Name or choose it from drop down box. Click OK to finish creation of Menu Item.
DB Software Laboratory
22 of 36
Active Table Editor User Manual
Speeding up Menu creation. It is also possible to use drug and drop for menu design and creation.
List of Menu Items
List of folders Press this button to see how menu will look like
DB Software Laboratory
23 of 36
Active Table Editor User Manual
12. Users Active Table Editor uses roles based security model. Every user must be a member at list one of the users groups and have menu assigned. Combination of group access rights and user group membership defines list of documents user can get access to.
• • • • • • • •
To create a new User click Outlook bar Users and than click Add. Dialog box will appear Fill in User Name you are about to create. Specify if user login is disabled Fill in user password and confirm password Select a User Menu from drop down box Click Advanced tab and fill in additional information about user Click OK to finish creation of an User. DB Software Laboratory
24 of 36
Active Table Editor User Manual
Note: All Fields on Advanced tab are not mandatory.
DB Software Laboratory
25 of 36
Active Table Editor User Manual
Once user is created it is possible to modify Group membership.
DB Software Laboratory
26 of 36
Active Table Editor User Manual
13. Groups Active Table Editor uses roles based security model. Every user must be a member at list one of the users groups and have menu assigned. Combination of group access rights and user group membership defines list of Menu Items user can get access to.
• • • •
To create a new Group click Outlook bar -> Groups and than click Add. Dialog box will appear Fill in Group Name you are about to create Click OK to finish creation of an Group DB Software Laboratory
27 of 36
Active Table Editor User Manual
Once Group is created it is possible to modify list of Group members.
DB Software Laboratory
28 of 36
Active Table Editor User Manual
Access Rights Access rights tabs defines list of objects available for group members. Permission No Access View Insert Update Delete
Comment Blocks access to the Menu Item regardless of group membership Group members can view the data Group members can insert records Group members can update records Group members can delete records
Hint: To add several objects hold ctrl or shift key and select objects using mouse.
DB Software Laboratory
29 of 36
Active Table Editor User Manual
DB Software Laboratory
30 of 36
Active Table Editor User Manual
14. SQL SQL Screen is a tool to run a free hand SQL or SQL scripts. Screen Overview SQL Toolbar
Connections List
SQL Window
SQL Builder
SQL Execution Log
List of available tables Data Grid
DB Software Laboratory
31 of 36
Active Table Editor User Manual
SQL Toolbar 1
2 3 1. 2. 3. 4.
4
Show/hide SQL Statement Show/hide connection panel Show/hide log panel Show/hide system tables
Side toolbar
1. Previous SQL Statement 2. Next SQL Statement 3. Select SQL Statement to execute
DB Software Laboratory
32 of 36
Active Table Editor User Manual
15. Support Procedure Should you require any support please send the following information to [email protected] 1. Version number 2. Example of data 3. Script to create table 4. Database version 5. Operation system version 6. Repository 7. Description of the problem
DB Software Laboratory
33 of 36
Active Table Editor User Manual
16. License Agreement Active Table Editor by DB Software Laboratory www.dbsoftlab.com [email protected] END-USER LICENSE AGREEMENT FOR THIS SOFTWARE IMPORTANT - READ CAREFULLY: This End-User License Agreement ("EULA") is a legal agreement between you (either an individual or a single entity) and DB Software Laboratory for the SOFTWARE PRODUCT identified above, which includes computer software and may include associated media, printed materials, and "online" or electronic documentation. By installing, copying, or otherwise using the SOFTWARE PRODUCT, you agree to be bound by the terms of this EULA. If you do not agree to the terms of this EULA, you may be subject to civil liability if you install and use this SOFTWARE PRODUCT. SOFTWARE PRODUCT LICENSE The SOFTWARE PRODUCT is protected by copyright laws and international copyright treaties, as well as other intellectual property laws and treaties. The SOFTWARE PRODUCT is licensed, not sold. INSTALLATION AND USAGE Once SOFTWARE PRODUCT is installed you may use it for 30 days. After evaluation period ends, you have to purchase a license or stop using the SOFTWARE PRODUCT. If this is an EVALUATION VERSION of the SOFTWARE PRODUCT, you may copy and distribute an unlimited number of copies of the SOFTWARE PRODUCT; provided that each copy shall be a true and complete copy, including all copyright and trademark notices, and shall be accompanied by a copy of this EULA. If this is a REGISTERED VERSION of the SOFTWARE PRODUCT, you may install and use it for your personal use only. You may not reproduce or distribute the SOFTWARE PRODUCT for use by others.
DB Software Laboratory
34 of 36
Active Table Editor User Manual
LICENSING There are two types of licenses available 1. A single computer usage license. The user purchases one license to use the SOFTWARE PRODUCT on one computer.
2. A SITE usage license. The user purchases a single usage license, authorising the use of SOFTWARE PRODUCT, by the purchaser, the purchaser's employees or accredited agents, on an unlimited number of computers at the same physical site location. This site location would normally be defined as a single building, but could be considered to be a number of buildings within the same, general, geographical location, such as an industrial estate or small town. OTHER RIGHTS AND LIMITATIONS You may not reverse engineer, decompile, or disassemble the SOFTWARE PRODUCT, except and only to the extent that such activity is expressly permitted by applicable law notwithstanding this limitation. Any such unauthorized use shall result in immediate and automatic termination of this license and may result in criminal and/or civil prosecution. All rights not expressly granted here are reserved by DB Software Laboratory. The SOFTWARE PRODUCT is licensed as a single product. Its component parts may not be separated for use on more than one computer. You may permanently transfer all of your rights under this EULA, provided the recipient agrees to the terms of this EULA. SEVERABILITY In the event of invalidity of any provision of this license, the parties agree that such invalidity shall not affect the validity of the remaining portions of this license. COPYRIGHT The SOFTWARE PRODUCT is protected by copyright laws and international treaty provisions. All title and copyrights related to the SOFTWARE PRODUCT (including but not limited to any images, photographs, animations, video, audio, music, text, and "applets" incorporated into the SOFTWARE PRODUCT), the accompanying printed materials, and any copies of the SOFTWARE PRODUCT are owned by DB Software Laboratory. MISCELLANEOUS Should you have any questions concerning this EULA, or if you desire to contact the author of this Software for any reason, please contact DB Software Laboratory (see contact information at the top of this EULA). DB Software Laboratory
35 of 36
Active Table Editor User Manual
LIMITED WARRANTY DB Software Laboratory expressly disclaims any warranty for the SOFTWARE PRODUCT. The SOFTWARE PRODUCT and any related documentation is provided "as is" without warranty of any kind, either express or implied, including, without limitation, the implied warranties or merchantability, fitness for a particular purpose, or no infringement. The entire risk arising out of use or performance of the SOFTWARE PRODUCT remains with you. In no event shall DB Software Laboratory be liable for any damages whatsoever or refund any money (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or any other pecuniary loss) arising out of the use of or inability to use this product, even if DB Software Laboratory has been advised of the possibility of such damages. Because some states/jurisdictions do not allow the exclusion or limitation of liability for consequential or incidental damages, the above limitation may not apply to you. ENTIRE AGREEMENT This is the entire agreement between you and DB Software Laboratory which supersedes any prior agreement or understanding, whether written or oral, relating to the subject matter of this license. Thank you for using the Active Table Editor DB Software Laboratory
DB Software Laboratory
36 of 36
© DB Software Laboratory 2008 www.dbsoftlab.com
Active Table Editor User Manual
Contents Contents....................................................................................................................................... 2 1. Introduction ............................................................................................................................. 3 2. Requirements........................................................................................................................... 3 3. Key features............................................................................................................................. 4 4. Active Table Editor Architecture ............................................................................................ 5 5. Getting Started......................................................................................................................... 6 6. Options .................................................................................................................................... 7 7. User Interface .......................................................................................................................... 9 Main window........................................................................................................................... 9 Outlook Bar ........................................................................................................................... 10 8. Connections ........................................................................................................................... 11 9. Menu Items............................................................................................................................ 12 Table Item.............................................................................................................................. 15 Record Item ........................................................................................................................... 16 Table/Record Item................................................................................................................. 17 10. Forms Designer ................................................................................................................... 18 Designer Screen Overview.................................................................................................... 19 11. Menu Designer .................................................................................................................... 20 Creating a new Menu ............................................................................................................ 21 Creating new Menu Item....................................................................................................... 22 Speeding up Menu creation................................................................................................... 23 12. Users .................................................................................................................................... 24 13. Groups ................................................................................................................................. 27 Access Rights ........................................................................................................................ 29 14. SQL ..................................................................................................................................... 31 Screen Overview ................................................................................................................... 31 SQL Toolbar.......................................................................................................................... 32 Side toolbar............................................................................................................................ 32 15. Support Procedure ............................................................................................................... 33 16. License Agreement.............................................................................................................. 34
DB Software Laboratory
2 of 36
Active Table Editor User Manual
1. Introduction Active Table Editor is software utility designed to give end user ability edit data quickly in any database.
2. Requirements Below is the list of Software that must be installed before the installation of Active Table Editor:
Software Microsoft Windows MDAC
Version 98 or higher 2.6 or higher
Microsoft Jet 4.0
Service pack 5 or higher 3.51.12 or higher
www.mysql.com
8.01.01 or higher
www.postgresql.com
1.02.00 or higher
www.ibphenix.com
7.3.4 or higher
Provided by Oracle
MySql ODBC Driver PostgreSql ODBC Driver Firebird ODBC Driver Oracle Client
Notes Part of OS on W2K and XP For MS Access repository For MySql repository For PostgreSql repository For Interbase/FireFox repository Only to connect to Oracle repository
Note: Depending on the Requirements you may or may not need to have all components installed
DB Software Laboratory
3 of 36
Active Table Editor User Manual
3. Key features This product features: • • • • • • • • • •
Easy Tables editing Comprehensive security management User definable Menus User definable Input Forms Unlimited number of Users and Groups Repository Creation Wizard Easy Repository switching Repository Import and Export SQL Editor Integrated SQL Builder
Active Table Editor uses repository to store following information • • • • •
Users Groups Access Rights Menus Database Connections
Repository Creation scripts are provided for following databases: • • • • • •
MS Access Oracle MS Sql Server Interbase/Firebird MySQL PostgreSQL
Note: Once installation is completed you may find all the scripts in C:\Program Files\DB Software Laboratory\Active Table Editor Folder.
DB Software Laboratory
4 of 36
Active Table Editor User Manual
4. Active Table Editor Architecture
Active Table Editor
Any List of M Database
Connections Menu Items Forms Designer Menu Designer Security SQL Editor
ODBC
End Users
Data Sources
Oracle, MS SQL Server. MS ACCESS, MySQL, PostgreSQL or Interbase
DB Software Laboratory
5 of 36
Active Table Editor User Manual
5. Getting Started Repository creation Use wizard provided to create the repository or alternatively you may use default MS Access Repository. To Start Active Table Editor Click Start -> All Programs -> DB Software Laboratory -> Active Table Editor-> Active Table Editor Login Box will appear Change Repository Connection Options
Enter user name and password to login Notes: Default password for user Administrator is Administrator You may bypass login screen by running application as follows ATEditor.exe User=Administrator;Password=Administrator
DB Software Laboratory
6 of 36
Active Table Editor User Manual
6. Options To change Active Table Editor Settings click System menu-> File-> Options. Dialog box will appear. Change Repository Connection
Delete Repository Connection
Create new Repository Connection
DB Software Laboratory
7 of 36
Active Table Editor User Manual
DB Software Laboratory
8 of 36
Active Table Editor User Manual
7. User Interface Main window System Menu
Outlook Bar Status bar
DB Software Laboratory
9 of 36
Active Table Editor User Manual
Outlook Bar Active Table Editor uses Outlook bar to provide the user with an easy access to the main functions of application. Below is a list of Outlook bar items with the short descriptions:
Connections
Defines connections to Data Sources
Menu Items
Defines Menu Items
Menu Designer
Defines Application Menu
Users
Defines list of Active Table Editor Users
Groups
Defines list of Active Table Editor Groups
SQL Scripts
Provides functionality to run SQL statements against target Data Sources and quick way to browse and edit data
Notes: All Outlook bar items above are available only to the members of Administrators group.
DB Software Laboratory
10 of 36
Active Table Editor User Manual
8. Connections In order to edit data Active Table Editor must be able to connect to one or more Data sources. To create a new connection Click Outlook Bar-> Management-> Connections->Plus Icon.
• • • •
Dialog box will appear. In the Name Text Box type in a new name for the connection you are about to create Select a ODBC DSN Name from the Drop Down List Fill in Username/Password for the database you wish to connect to a. You may use ODBC admin to create/modify ODBC data sources.
•
Click Test to ensure the details you have provided are correct DB Software Laboratory
11 of 36
Active Table Editor User Manual
9. Menu Items Menu Items are the construction blocks we use to design user menus. In another words Menu item is a result of execution of SQL statement associated with Icon and appropriate Description. List of Menu Items
List of Menu Items available to current user
DB Software Laboratory
12 of 36
Active Table Editor User Manual
SQL Builder
DB Software Laboratory
13 of 36
Active Table Editor User Manual
DB Software Laboratory
14 of 36
Active Table Editor User Manual
There three types of items end user can use 1. Table 2. Record 3. Table/Record Table Item Item Description
Menu Item Icon
Data Grid populated with results of SQL execution
List of available actions is defined by the user security rights
DB Software Laboratory
15 of 36
Active Table Editor User Manual
Record Item
Designer Button is available only to Ad i i t t
Navigation Buttons
Once logged in as an Administrator you are able to change this form layout by modifying existing objects and adding/deleting the old ones
DB Software Laboratory
16 of 36
Active Table Editor User Manual
Table/Record Item Press to switch from table to record view
DB Software Laboratory
17 of 36
Active Table Editor User Manual
10. Forms Designer Once logged in as an Administrator it is possible change Record and Table/Record item layout by modifying existing objects and adding/deleting the old ones. Press to show Forms Designer
DB Software Laboratory
18 of 36
Active Table Editor User Manual
Designer Screen Overview Select an Object, than click on the panel to add it
Select an objects to modify its’ Properties
Select a field to link the object to
You may move objects and resize then by using mouse
DB Software Laboratory
19 of 36
Active Table Editor User Manual
11. Menu Designer Every user has a menu assigned. List of items accessible by the user is defined by its access rights. Every menu consists of a root folder subfolders and items. Menu
List of Menus
Drag and Drop Items
Note: Administrator’s Menu is populated automatically when new Menu item is created.
DB Software Laboratory
20 of 36
Active Table Editor User Manual
Creating a new Menu
• • •
To create a new Menu click Pop up menu-> Add. Fill in Menu Name you are about to create. Click OK to finish creation of Menu.
DB Software Laboratory
21 of 36
Active Table Editor User Manual
Creating new Menu Item
• • • •
To create a new Menu Item click Pop up menu-> Add. Choose appropitate Item Type from Radio Group Fill in Item Name or choose it from drop down box. Click OK to finish creation of Menu Item.
DB Software Laboratory
22 of 36
Active Table Editor User Manual
Speeding up Menu creation. It is also possible to use drug and drop for menu design and creation.
List of Menu Items
List of folders Press this button to see how menu will look like
DB Software Laboratory
23 of 36
Active Table Editor User Manual
12. Users Active Table Editor uses roles based security model. Every user must be a member at list one of the users groups and have menu assigned. Combination of group access rights and user group membership defines list of documents user can get access to.
• • • • • • • •
To create a new User click Outlook bar Users and than click Add. Dialog box will appear Fill in User Name you are about to create. Specify if user login is disabled Fill in user password and confirm password Select a User Menu from drop down box Click Advanced tab and fill in additional information about user Click OK to finish creation of an User. DB Software Laboratory
24 of 36
Active Table Editor User Manual
Note: All Fields on Advanced tab are not mandatory.
DB Software Laboratory
25 of 36
Active Table Editor User Manual
Once user is created it is possible to modify Group membership.
DB Software Laboratory
26 of 36
Active Table Editor User Manual
13. Groups Active Table Editor uses roles based security model. Every user must be a member at list one of the users groups and have menu assigned. Combination of group access rights and user group membership defines list of Menu Items user can get access to.
• • • •
To create a new Group click Outlook bar -> Groups and than click Add. Dialog box will appear Fill in Group Name you are about to create Click OK to finish creation of an Group DB Software Laboratory
27 of 36
Active Table Editor User Manual
Once Group is created it is possible to modify list of Group members.
DB Software Laboratory
28 of 36
Active Table Editor User Manual
Access Rights Access rights tabs defines list of objects available for group members. Permission No Access View Insert Update Delete
Comment Blocks access to the Menu Item regardless of group membership Group members can view the data Group members can insert records Group members can update records Group members can delete records
Hint: To add several objects hold ctrl or shift key and select objects using mouse.
DB Software Laboratory
29 of 36
Active Table Editor User Manual
DB Software Laboratory
30 of 36
Active Table Editor User Manual
14. SQL SQL Screen is a tool to run a free hand SQL or SQL scripts. Screen Overview SQL Toolbar
Connections List
SQL Window
SQL Builder
SQL Execution Log
List of available tables Data Grid
DB Software Laboratory
31 of 36
Active Table Editor User Manual
SQL Toolbar 1
2 3 1. 2. 3. 4.
4
Show/hide SQL Statement Show/hide connection panel Show/hide log panel Show/hide system tables
Side toolbar
1. Previous SQL Statement 2. Next SQL Statement 3. Select SQL Statement to execute
DB Software Laboratory
32 of 36
Active Table Editor User Manual
15. Support Procedure Should you require any support please send the following information to [email protected] 1. Version number 2. Example of data 3. Script to create table 4. Database version 5. Operation system version 6. Repository 7. Description of the problem
DB Software Laboratory
33 of 36
Active Table Editor User Manual
16. License Agreement Active Table Editor by DB Software Laboratory www.dbsoftlab.com [email protected] END-USER LICENSE AGREEMENT FOR THIS SOFTWARE IMPORTANT - READ CAREFULLY: This End-User License Agreement ("EULA") is a legal agreement between you (either an individual or a single entity) and DB Software Laboratory for the SOFTWARE PRODUCT identified above, which includes computer software and may include associated media, printed materials, and "online" or electronic documentation. By installing, copying, or otherwise using the SOFTWARE PRODUCT, you agree to be bound by the terms of this EULA. If you do not agree to the terms of this EULA, you may be subject to civil liability if you install and use this SOFTWARE PRODUCT. SOFTWARE PRODUCT LICENSE The SOFTWARE PRODUCT is protected by copyright laws and international copyright treaties, as well as other intellectual property laws and treaties. The SOFTWARE PRODUCT is licensed, not sold. INSTALLATION AND USAGE Once SOFTWARE PRODUCT is installed you may use it for 30 days. After evaluation period ends, you have to purchase a license or stop using the SOFTWARE PRODUCT. If this is an EVALUATION VERSION of the SOFTWARE PRODUCT, you may copy and distribute an unlimited number of copies of the SOFTWARE PRODUCT; provided that each copy shall be a true and complete copy, including all copyright and trademark notices, and shall be accompanied by a copy of this EULA. If this is a REGISTERED VERSION of the SOFTWARE PRODUCT, you may install and use it for your personal use only. You may not reproduce or distribute the SOFTWARE PRODUCT for use by others.
DB Software Laboratory
34 of 36
Active Table Editor User Manual
LICENSING There are two types of licenses available 1. A single computer usage license. The user purchases one license to use the SOFTWARE PRODUCT on one computer.
2. A SITE usage license. The user purchases a single usage license, authorising the use of SOFTWARE PRODUCT, by the purchaser, the purchaser's employees or accredited agents, on an unlimited number of computers at the same physical site location. This site location would normally be defined as a single building, but could be considered to be a number of buildings within the same, general, geographical location, such as an industrial estate or small town. OTHER RIGHTS AND LIMITATIONS You may not reverse engineer, decompile, or disassemble the SOFTWARE PRODUCT, except and only to the extent that such activity is expressly permitted by applicable law notwithstanding this limitation. Any such unauthorized use shall result in immediate and automatic termination of this license and may result in criminal and/or civil prosecution. All rights not expressly granted here are reserved by DB Software Laboratory. The SOFTWARE PRODUCT is licensed as a single product. Its component parts may not be separated for use on more than one computer. You may permanently transfer all of your rights under this EULA, provided the recipient agrees to the terms of this EULA. SEVERABILITY In the event of invalidity of any provision of this license, the parties agree that such invalidity shall not affect the validity of the remaining portions of this license. COPYRIGHT The SOFTWARE PRODUCT is protected by copyright laws and international treaty provisions. All title and copyrights related to the SOFTWARE PRODUCT (including but not limited to any images, photographs, animations, video, audio, music, text, and "applets" incorporated into the SOFTWARE PRODUCT), the accompanying printed materials, and any copies of the SOFTWARE PRODUCT are owned by DB Software Laboratory. MISCELLANEOUS Should you have any questions concerning this EULA, or if you desire to contact the author of this Software for any reason, please contact DB Software Laboratory (see contact information at the top of this EULA). DB Software Laboratory
35 of 36
Active Table Editor User Manual
LIMITED WARRANTY DB Software Laboratory expressly disclaims any warranty for the SOFTWARE PRODUCT. The SOFTWARE PRODUCT and any related documentation is provided "as is" without warranty of any kind, either express or implied, including, without limitation, the implied warranties or merchantability, fitness for a particular purpose, or no infringement. The entire risk arising out of use or performance of the SOFTWARE PRODUCT remains with you. In no event shall DB Software Laboratory be liable for any damages whatsoever or refund any money (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or any other pecuniary loss) arising out of the use of or inability to use this product, even if DB Software Laboratory has been advised of the possibility of such damages. Because some states/jurisdictions do not allow the exclusion or limitation of liability for consequential or incidental damages, the above limitation may not apply to you. ENTIRE AGREEMENT This is the entire agreement between you and DB Software Laboratory which supersedes any prior agreement or understanding, whether written or oral, relating to the subject matter of this license. Thank you for using the Active Table Editor DB Software Laboratory
DB Software Laboratory
36 of 36
Related Documents
Active Table Editor User Manual
June 2020 0
Active Business Intelligence Portal User Manual
June 2020 0
User Manual
May 2020 23
User Manual
June 2020 28
User Manual
October 2019 45