...
- In the Servoy Developer Solution Explorer tab, expand the Database Servers node (under Resources) and right click on a SQL Anywhere database (all the example databases provided by Servoy are SQL Anywhere) to show the popup menu.
- Select Create Sybase Database.
- Enter a name for the database in the dialog window.
- A dialog will appear indicating a Sybase database restart is required.
- A dialog will recommend to restart Servoy Developer. Click OK. and close Servoy Developer.
- Close Sybase SQLAnywhere.
- On Windows - Look for the orange lighting bolt in the system tray, right click, and select Shut down "servoy_repository"
- On Mac and Linux - find the dbsrv11 process and shut it down.
- Restart Servoy Developer.
- Your database will appear in the Database Servers node.
...
To create a table in Servoy Developer.
...
Creating Columns
...
:
- Right click on the database name in the Database Servers node and select
Wiki Markup |
---|
*Create Table*{color) *OR* With the database name selected, click on the create table button in toolbar of the list view in Solution Explorer.
# A dialog will ask for the name for a new table. Enter the name and click OK.
# The table editor view will appear allowing new columns to be entered.
{note:title=NOTE} When a new table is created, Servoy will add a column in the table editor for the primary key. All tables used in Servoy must have a primary key or a row identifier. {note}
h6. Creating Columns
To create columns in Servoy Developer:
# Open the table editor by selecting the database server in the Solution Explorer and doing one of the following in the list view:
* Double clicking on the table name.
* Right clicking on the table name and selecting {color:#008000}*Edit table/view* |
.
- Select the table and click on the edit table button in the list view toolbar.
- The table editor will appear allowing editing of the columns for the table.
- To add a column, click on the Add button. Change the name from "type here" to your desired name, the column type, and size (if applicable). Be sure to save when finished.
- To remove a column, click on the Remove button.