🚀 go-pugleaf

We are happy to announce our Oberon/F Sql component. Sql is an add-on
subsystem for the component framework Oberon/F. Sql provides a simple and
scalable way to build cross-platform database components. It allows to build
client/server or royalty-free single user applications. Sql comes with the
highly efficient dtF SQL libraries of theta group, Germany.

Sql provides an easy to use yet powerful programming interface to SQL
databases. The interface is identical and fully portable over all supported
platforms, in both single user and multi-user environments. Using Oberon/F's
metaprogramming facilities, Sql provides Embedded SQL convenience without
static preprocessors. Sql supports full access to the SQL language. To
guarantee maintainability, Sql is designed to work without special
database-aware controls. Sql is fully extensible in order to allow access to
arbitrary databases or database middleware.

Sql comes standard with the dtF database libraries, either in a single user
version or in a client/server version. dtF is a powerful relational database
system, for developers who want to create high powered database-centered
applications with no performance trade-offs. dtF features SQL, full
transaction control, error recovery, client/server architecture and
multiplatform support. dtF is designed for personal computers in single user
and client/server environments, so applications created with dtF are compact,
requiring minimal hard disk space and main memory. Applications built with
dtF are scalable from notebooks to large client/server systems without the
need for additional middleware software.


Features
========

o Easy to use programming interface
o Cross-Platform
o Scalable from single user to client/server environments
o Embedded SQL convenience without static preprocessors
o Full access to the SQL language
o Can be used with any controls, not only with database-aware controls
o Extensible in order to allow access to various databases or middleware
  software
o dtF is fast, due to proprietary query optimization and caching schemes
o dtF is safe; it provides full transaction control, error recovery,
  compression and encryption
o No middleware needed for single user solutions, no inefficient file sharing
  used for multi-user solutions
o Standalone database components based on Sql and dtF are royalty-free.


Code Sample
===========

MODULE SqlSample;

  IMPORT SqlDB;

  VAR
    (* user interface controls are linked directly to company and searchId *)
    company*: RECORD (SqlDB.Row)   (* one row of result table *)
      id*: LONGINT;
      name*: ARRAY 32 OF CHAR
    END;
    searchId*: LONGINT;   (* parameter for Find *)
    d: SqlDB.Database;

  PROCEDURE Open*;
  BEGIN SqlDB.OpenDatabase("DtfDrvr", "", "", "", d)
  END Open;

  PROCEDURE Find*;
  BEGIN   (* select row where id = searchId, and assign it to company *)
    SqlDB.Assign(d, "SqlSample.company",
      "SELECT * FROM Companies WHERE id = :SqlSample.searchId")
  END Find;

END SqlSample.


Ordering Information
====================

of sqlsu win / mac  CHF 1340.-
Sql subsystem with dtF single user libraries.

of sqlcs win / mac  CHF 3460.-
Sql subsystem with dtF client/server libraries.

of sqlrt win / mac  CHF 1420.-
Sql and dtF client/server runtime libraries. Licence for one LAN
installation.

Customers who order before September 1996 will get a free update to the next
release. For further information contact us at marketing@oberon.ch or look at
http://www.oberon.ch/customers/omi/prod/sql.html.


Best wishes,

The Oberon microsystems crew

====================================================================
                                           Oberon microsystems, Inc.
oberon@oberon.ch                                 Technoparkstrasse 1
voice ++41-1-445-1751                                 CH-8005 Zurich
fax   ++41-1-445-1752             http://www.oberon.ch/customers/omi
====================================================================