By: Lance Devin
Abstract: Delphi Client /Server Suite incorporates integrated technologies that help solve your business needs.
The SQL Monitor enables the developer to trace calls between the
client and server. This information allows the developer to find
problematic SQL statements and then optimize the SQL transactions.
A series of trace options lets the developer customize the amount
and type of information that is reported on. The SQL Monitor helps
the developer know that the SQL in the application is being performed
optimally, what is the SQL generated by the Borland Database Engine,
if the Database Client Libraries are functioning properly, and
if the database server is executing a run-away query. The additional
capabilities to save and print the session log enables more thorough
The SQL Explorer, unique to Delphi, makes database administration
easier and more intuitive than having to use a separate non-integrated
tool. A simple to use graphical interface is a perfect way to
represent the complex relationships that exist in a database server.
The SQL Explorer presents schema information from Oracle, Sybase,
InterBase, Informix, DB2 and others. The developer can drag and
drop fields, tables, and stored procedures onto the Delphi application
form to build Client / Server database applications
quickly. The developer can also issue SQL statements directed
to multiple servers and multiple databases.
InterBase is Borland's high performance, cross platform SQL Server.
InterBase is available on over 15 operating systems, including:
Windows 3.1, Windows 95, Windows NT, NetWare, SCO, Sun OS, Sun
Solaris, HP-UX, IBM AIX, SGI IRIX, etc. InterBase is ANSI SQL
92 entry level conformant, supports server events for event driven
programming, and has an exceptional concurrency model for multiuser
access. InterBase offers record level locking and due to its
Multi-Generational Architecture delivers superior performance
because database read operations do not block database write operations.
Local InterBase, also available in Client / Server Suite 2.0,
provides Delphi developers with their own single user ANSI 92
SQL conformant server for prototyping and development of true
client/server applications on Windows 95 or Windows NT. Local
InterBase has all of the same functionality as the multiuser versions
of InterBase available for NT and Unix, including transaction
control, stored procedures, triggers, and even event alerters,
which enable event driven programming. This means that development
can occur on a laptop while on the train, airplane, or at the
customer site, and that the final database to be used can be changed
when the application is ready to be deployed.
Using Delphi Client/Server Suite 2.0, developers can design, prototype,
and test their Delphi/InterBase applications on one machine. InterBase
offers an exceptional Windows 95 GUI interface including configurable
property sheets, native 32 bit tools like the Server Manager and
Interactive SQL tools, and the complete documentation in Windows
InterBase ensure that data is always available due to their excellent
multiuser performance, high security, and fast recovery features.
InterBase is used in the aeronautical industries by companies
like Boeing and Lockheed for manufacturing, by the Money Store
and many other banking institutions, and in financial trading
centers like the Philadelphia, Boston, and Russian Stock Exchanges.
The common thread among all these customers is the need for excellent
multiuser performance, high security, and fast recovery when system
Delphi's Database Component Architecture is a high level object
oriented encapsulation of the Borland Database Engine Architecture.
The object oriented architecture offers a simple application
programming interface with three benefits.
The Database component can also maintain a persistent connection
to a server so that a server connection operation does not have
to be re-established each time. This speeds up applications.
There exist three different types of connectivity maintained by
The flexibility offered by programatically choosing the type of
connection means that the developer can chose to optimize for
performance, for minimal contentions, for cost and/or for the
amount of server control.
Because of the componentization of the Borland Database architecture
business logic can be applied to Tables, Stored Procedures, and
Queries by creating methods on Before and/or After events such
as posts, deletes, inserts and edits. This allows you to create
new objects for flexibility.
Filter expressions are easily written in the Object Pascal language
and have no limitations that are inherent in 4GL languages with
respect to scope and breadth of function creation.
Filters facilitate the way people work by allowing users to scan
through data more effectively. Being able to drill into a result
set is one way to turn data into information by mapping to the
way people work.
When a user posts an update, Delphi uses the original record values
to find the record in the database. This approach is called optimistic
locking. The Update Mode specifies which table columns Delphi
uses to find the record. In SQL terms, Update Mode specifies
which columns are included in the WHERE clause of an UPDATE statement.
If Delphi cannot find a record with the original values in the
columns specified (if another user has changed the values in the
database), Delphi will not make the update and will generate an
exception, so that the application can implement custom behavior,
perhaps logging the results.
The Update Mode property may have the following values:
Using the Object Inspector to visually change the Update Mode
provides easy control for updating records in database servers.
The Update Mode reduces the conflicts that arise in large, heavily
used Client / Server applications which results in higher
Download Delphi 10 now!
Webinars on demand!
More social media choices:
Delphi on Google+
@RADTools on Twitter
Server Response from: ETNASC03