About Us  |  My Account  |  

Developer Tools

OpenBase Forms offers a full range of development tools. The OpenBase Form Wizard will take any table or group of related tables and generate a fully functional input form which can be used to edit and search data. More advanced users can edit those forms using OpenBase Form Designer to create full-featured business applications.

For Cocoa developers, we also offer the source code to the OpenBase Forms client application so that it can be integrated into any Cocoa application. This capability enables your users to extend your application and make it more specific to their needs. You can advertise this benefit simply by including the framework. There are no runtime fees.

Using OpenBase Form Designer Application To Modify Existing Forms

The OpenBase Form Designer enables advanced users to view and edit panels containing forms.


The style selection pop-up is located at the top left of the main window. Panel styles determine the size of panels and will ultimately determine the dimensions of your story board. Choosing a style allows you to see all of the panels that belong to that style in your application. Double clicking on a panel will give you the GUI design tool shown below.




The GUI design tool in OpenBase Form Designer enables new screen widgets to be dragged off the palette and dropped onto the panel. You can reposition the screen element and resize it using familiar interface controls. You can use the drag-and-drop interface to connect the database columns on the left with the new widgets on the panel.


The palette window provides a wide choice of widgets for building your applications.

The inspector provides a wide range of functions to adjust attributes and alignment for each object. Extensive control is provided.

To align a set of objects, select the group using shift-click, then bring up the inspector. Choose the operations which best fits how you want to the set of objects to be aligned.

The inspector provides a wide range of functions to adjust attributes and alignment for each object. Extensive control is provided.

To align a set of objects, select the group using shift-click, then bring up the inspector. Choose the operations which best fits how you want to the set of objects to be aligned.



Every object on a window responds to initialize, before, during and after scripts. Scripts are automatically called as users interact with fields and other screen objects. This allows programmers to add business logic to implement specific business processes and controls. Below is a more comprehensive example.



In this example, we have created a search script that responds to the during() event of a search field. As the user types, the input is used to perform searches on the database to narrow down the result in the selection chooser.


This example shows the logic behind a checkbox. Checkboxes also respond to Checked and Unchecked methods. In this example, we used a checkbox to set another field called "shipDate" to today's date.


Sometimes, you may want your OpenScript to perform database operations. In addition to full support for SQL, OpenScript is fully integrated with the OpenBase API, which automatically manages updatable result sets and provides an easy mechanism for accessing rows through OpenScript.

The above example also shows exception handling using a TRY... CATCH exception handler. If one of the save operations fail, an exception is triggered and the transaction is rolled back.



OpenScript also offers full integration of the ALERT error reporting mechanism, allowing you to access the alert system in OpenBase. Errors logged using the ALERT system are automatically logged on the server and can be scripted to trigger alarms for administrators who are monitoring the operation of your information system.

For a complete tutorial on OpenBase Forms and OpenBase Forms
Development tools, please see our documentation.