Servoy 2020 Documentation
Child pages
  • Managing Database Connections

Versions Compared

Old Version 10

changes.mady.by.user Sean Devlin

Saved on

compared with

New Version 11

changes.mady.by.user Jason Meunier

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. 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.
  2. Select Create Sybase Database.
  3. Enter a name for the database in the dialog window.
  4. A dialog will appear indicating a Sybase database restart is required.
  5. A dialog will recommend to restart Servoy Developer.  Click OK. and close Servoy Developer.
  6. Close Sybase SQLAnywhere.
    1. On Windows - Look for the orange lighting bolt in the system tray, right click, and select Shut down "servoy_repository"
    2. On Mac and Linux - find the dbsrv11 process and shut it down.
  7. Restart Servoy Developer.
  8. Your database will appear in the Database Servers node.

...

To create a table in Servoy Developer.

...

Creating Columns

...

:

  1. 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.
  1. The table editor will appear allowing editing of the columns for the table.
  2. 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.
  3. To remove a column, click on the Remove button.