BEST DB Editor Products
-----
 /
BEST DB Editor
*Who's It For?
<Examples
*Tutorial 
*Buy Online
*For More Information
*Engineering Solutions
*Ask about this page
*Print this page
*Give us feedback
*Sign up for the Wolfram Insider

Example Images

Adding a New Record
This is a screen shot of BEST DB Editor in use while adding a new record to the HSQL database table SALESDETAILS.

Screen shot of BEST DB Editor interface to add a new record


Editing a Table
This is a screen shot of BEST DB Editor editing the table EDITORS for which a TableTemplate has been designed by the user. Customization includes such changes as: putting required fields on the first line, adding an image, showing only the latest edited record, and relocating the Save button.

Screen shot of BEST DB Editor interface editing a table


Table with Several Data Types
This is a screen shot of BEST DB Editor editing a table with a several data types: real and integer numbers, strings, dates, graphics, 3D graphics, images, 3D images, binary expressions, held expressions, and sound.

Screen shot of BEST DB Editor interface editing several data types


Export
To export data, select the database table, define a filter to extract data, and use the Save or Export menu options in the data viewer as shown below.

Screen shot of BEST DB Editor interface exporting data


Working Session Preferences
The image below shows that Working Session preferences can be modified individually for each field or in a general way for all fields.

Screen shot of BEST DB Editor interface modifying working session preferences


Create Table
To create a table, the process is as follows: select reference tables (optional) and the desired fields from each selected table. In the First Fields and Last Fields tabs, new field names can be typed, separated by commas. Each selected or newly defined field can be modified with the following properties: Nullable, PrimaryKey, DataType, and DataLength (when applicable). Once the fields have been set and the new table named, press the button Create Table in Database to create the new table.

Screen shot of how to create a table in BEST DB Editor


Import Data into New Table
To initiate the process, select the file and proceed to Import the data. If the data headers of the data imported does not match those of the selected table, a warning message will be generated. The data types of the fields to be created can be individually selected by the user, or the Guess button can be used to select the data type based on the Heads of the imported data. Note that field names can be Excluded by selecting that option in the data type menu.

Screen shot of how to import data in BEST DB Editor

Any questions about topics on this page? Click here to get an individual response.