List All Pages
Using ActualODBC
Many common desktop applications allow you to directly access data in your database by using ODBC technology. Whether you want to create a report using FileMakerPro, perform...
Notifying Administrators of Error Conditions
OpenBase has a built in notification system that allows applications and stored procedures to send messages to system administrators via a central...
REALbasic Stored Procedures
OpenBase SQL makes it easy to write server-side REALbasic stored procedures to implement business logic. By centralizing business logic inside the database, OpenBase SQL...
Built-in Stored Procedures
The OpenBase SQL database comes with a number of built-in stored procedures to assist you with application development.
Video: Built-In Stored Procedures
Remote...
The Espresso API offers a superset of the OpenBase API to insulate developers from having to always construct SQL. The Espresso API layer takes care of all the SQL, record locking, data encoding...
Java Object Persistence with OpenBase & Cayenne
Introduction
Reading/Writing Java Objects From/To OpenBase
• Object Relational Mapping (ORM)
• Cayenne Architecture
• Cayenne In...
SHOW STATS & ABORT
Show stats returns a result set showing all of the sessions that are connected to a database. The first line contains statistic totals and the first column provides the...
This guide is intended for software developers and system administrators who are using OpenBase on MacOS X, Windows and Linux. Each of these sections describe ways of connecting to OpenBase.
Please change this page according to your needs
CREATE VIEW
CREATE VIEW statements provide a way to specify database views. A database view is a phantom table which includes data from one or more tables. Views are normally used to provide a way...
OpenBase offers 5 different types of indexes using SQL syntax and one index type using stored procedures (described in the stored procedure section). Indexes are used to speed up searching and are...
Viewing Database Information
The OpenBase Manager allows you to view and edit database table information using the Database Browser. To do this select a started database (one with a green dot) and...
Server Management
OpenBase Manager provides options for managing server information. This includes Network access, License information, and Security. These settings are accessed by clicking File on...
Synchronization Manager
OpenBase provides full two-way synchronization of databases. This means that you can make changes to any database in a group of synchronized databases and those changes will...
Delete Database Records
DELETE FROM provides a way to remove records from a table. Deleting records from a table works similarly to updating in that the WHERE clause specifies which records will be...
Requirements for Embedding OpenBase SQL
OpenBase SQL is embedded in a variety of “shrink-wrapped” and vertical-market products, which often need to co-exist on the same customer computer....
GUI SQL makes interacting directly with SQL easier. It provides a graphical interface to the openisql program .
Starting GUI ISQL
Using the OpenBase Manager you click on the icon next to the...
If you are allowed to edit pages in this Site, simply click on edit button at the bottom of the page. This will open an editor.
To create a link to a new page, use syntax: [[[new page name]]] or...
OpenBase offers two variations of the insert SQL syntax: INSERT INTO and REPLACE INTO. The SQL standard specifies that INSERT INTO will insert values into a table as a new record. If it is unable...
Interactive SQL
OpenISQL allows you to execute SQL from a terminal window. Clicking the Interactive SQL Terminal icon or selecting SQL Terminal from the Action menu or Action icon will launch the...
Java Stored Procedures
OpenBase SQL makes it easy to write server-side Java stored procedures (Java SP) that take advantage of existing Java solutions to add functionality to applications and...
Using JDBC with OpenBase Application with JDBC
OpenBase comes with a standard JDBC driver which will work for most applications. For examples on how to use JDBC we recommend visiting the sun.com...
Please change this page according to your policy (configure first using Site Manager) and remove this note.
Who can join?
You can write here who can become a member of this site.
Join!
So you...
Change User Access
The OpenBase Manager includes graphical tools that make it easy to manage database users. But for those who need to manage users programmatically, this section offers some...
Backup, Restore and Script Functions
The OpenBase Manager provides some tools for transferring database information to and from a bulk saved ASCII format. The Backup to ASCII and Restore from ASCII...
Notable Features & Technical Details
Welcome to OpenBase! This document highlights some notable feature you should be aware of.
Always-on encryption
Now OpenBase SQL delivers always-on...
OpenBase offers a C and Objective-C API for communicating with databases and retrieving results. This section describes the API calls that are common to both versions of the communications...
This section focuses on the low-level OpenBase Objective-C interface through the OpenBase object. The OpenBase object provides the basis for all communication to OpenBase databases and is...
The Espresso API offers a superset of objects which can be combined with the OpenBase API to offer a higher level of access which insulates program logic from SQL. The Espresso API layer takes care...
This section focuses on building OpenBase stored procedures in Objective-C using the OpenBase Espresso API. Example project code can be found in the OpenBase Developer download which will help you...
The OpenBase DAMs provide connectivity between Omnis Studio 3.2 (or later) or Omnis 7.3.8.1 (or later) and OpenBase SQL. This section describes the requirements, installation procedures, and basic...
OpenBase Manager
The OpenBase Manager application provides graphicaltools for managing database servers across your local areanetwork. It also includes tools for viewing database tables,editing...
OpenBase Manager Overview
The OpenBase Manager application provides graphical tools for managing database servers across your local area network. It also includes tools for viewing database tables,...
This guide covers the Standard Query Language (SQL), the means by which client applications communicate with database server programs. This guide is only meant to give you a basic understanding of...
What is OpenBase SQL?
OpenBase SQL is a database server application that provides high-speed access to structured data. SQL stands for Structured Query Language and is the mechanism by which client...
#header {
background:url(http://newsite.openbase.com/openbasesmall.jpg) top left no-repeat #e5e6e4;
height:65px;
position:relative;
}
#header h1 span {
display:none;
}
Here are some helpful tips to help you take full advantage of unique strengths and features of the OpenBase SQL database when building your software.
Video: Performance Optimization Techniques
SQL...
OpenScript Stored Procedures
OpenBase SQL makes it easy to write server-side OpenScript stored procedures (OpenScript SP) to implement business logic. By centralizing business logic inside the...
When you are dealing with slow connections, the biggest bottleneck is transferring a large volume of data all at once. There are some techniques that can be used to increase the performance...
These instructions allow access to up-to-date DBI functionality through the extremely well supported JDBC driver for OpenBase. This set of instructions shows you how to connect to an OpenBase...
OpenBase PHP
The PHP archive contains the files necessary to add OpenBase support to PHP. The module source has been recently modified in January 2009 to support MacOS X leopard, 64 bit...
The REALbasic Connectivity Module for OpenBase allows clients written in REALbasic to connect with OpenBase databases. Since the connectivity module is written in 100% REALbasic, applications that...
The RealBasic Database Admin Interface Reference
In addition to accessing database data, the RealBasic Module for OpenBase provides administration classes for creating and controlling OpenBase...
Editing the Database Schema
The Database Schema Editor allows administrators and database developers to view and change the database schema (the design of data tables and relationships). The...
CREATE TABLE
The CREATE TABLE keyword at the beginning of an SQL statement tells OpenBase that you want to create a new table. Creating new tables can also be accomplished by using the graphical...
Introduction to Select Statements
Select statements can be the most complicated of all SQL statements. It is important to note that select statements are the only statements that will operate on...
OpenBase provides server-side global variables to make it easy to coordinate between stored procedures and database clients. The variables are thread-safe and can be safely incremented and...
OpenBase Overview
Important Articles
OpenBase Manager
OpenBase SQL
OpenBase Tools
Stored Procedures
Connectivity APIs
OpenBase Forms
Recent changes
List all pages
Page Tags
Site Manager
Page...
Members:
Moderators
Admins
Server-Side SQL Cursors
Server-side Cursors in OpenBase SQL enable clients to perform a select or stored procedure call and cache a snapshot of the results on the server. This allows clients to...
Functions can be embedded SQL, used in formulas or called separately. This section covers the variety of functions that are supported by OpenBase.
Calling Functions Separately
For those times when...
SQL Standards
These days a lot of emphasis is placed on SQL syntax standards. The problem is that the standardization stops with the easiest part — the SQL syntax.
Every database server uses...
In this section we will discuss the OpenBase SQL syntax for transactions, and the concepts and principles for them.
Video: Transactions & OpenBase Record Locking
Transaction...
Triggers are a mechanism that allows you to perform an action when someone modifies a table. The trigger mechanism in OpenBase allows you to perform different actions depending on whether the table...
OpenBase Home
Topics
OpenBase Tips
Embedding OpenBase
contact
Generating Unique Keys
To insert a new unique key into your record, you first need to generate a unique key value using the NEWID command.Or you can use one of the API calls and then insert it into...
The UPDATE statement is used to update values in the database. UPDATE statements have the ability to update multiple records at a time depending on the search constraints given.
Here is an example...
User Manager
The OpenBase Manager has a built in facility for managing database users. A database user is simply a login/password combination that gives a person access to a database. Databases are...
OpenBase Forms Visual Programming
OpenBase Forms is a database interface that makes it easy for you to organize complex database information on functional data input screens, so users can find what...
WebObjects
WebObjects is a powerful rapid application development environment for building powerful web sites and web services. Built on a three-tier architechure, WebObjects allows you to insulate...
According to Wikipedia, the world largest wiki site:
A Wiki ([ˈwiː.kiː] <wee-kee> or [ˈwɪ.kiː] <wick-ey>) is a type of website that allows users to add, remove, or otherwise edit...
The Hypertext Transfer Protocol (HTTP) is the most ubiquitous of the Internet protocols. Although seen primarily as a means to fetch pages of Hypertext Markup Language (HTML) content for display in...
