Direct access to Sybase Anywhere. Components doesn't use
BDE, ODBC, ADO, etc. Standart installation of Sybase Anywhere
is not required. Just some system libraries from Sybase
Anywhere are needed to be placed on local or network disk.
Nothing is reading and writing to Windows Registry.
SaVcl is free (no charge for using) with source included.
SaVcl has SQL-monitor. SQL-monitor helps to inspect SQL
queries that components send to database (unprepared and
prepared statements with displayed values of the parameters
and host variables).
SaVcl can work with tables (like TTable - table mode) and
queries (like TQuery - query mode).
Multithreading support.
Result sets are not fetched fully to the client application
while scrolling records.
In table mode it's possible to open several tables
simultaneously, join them by any keys, and specify field
names in result set.
Correct sorting of the fields with NULL values. According to SQL
standart NULL values are placed to the top of result set in
ordering of any direction. SaVcl allows to specify for each
field values that will be substituted instead NULL values.
Full support of the cached updates including NewValue, OldValue
properties of TField.
All types of cursors are supported (DYNAMIC SCROLL, NO
SCROLL, INSENSITIVE).
Inserting records into opened cursor with getting really
inserted values of fields. This feature can be used in case
of inserting records into master-details tables when values
of foreing keys in master table are calculates as result of
autoincrement or triggers' firing.
Supports the transactions.
Supports Sybase Anywhere Database callbacks.
Supports the bookmarks.
Possibility to open queries and tables for inserting
records with getting only structure of result set
without fetching rows and values.
Getting and putting values of any sizes ( >32Kb ).
Supports the Bcd and Largeint fields.
Provides the work with external filters (for searching and
filtering records) with nesting levels of any depth.
Extended searching including the "find forward", "find backward",
etc.
Supports the host variables and parameters of any types.
Changing ordering and refreshing without reopen tables and
queries.
Component TSaDs is a descendant of the TDataset so has full
compatibility with Delphi Database Control components.
Etc.
2. Parts.
Components and classes:
TSaDb - analog of component TDatabase. Provides connection to Sybase
Anyhwere databases.
TSaDs - component-descendant of TDataset. Provides direct working with
tables, queries, stored procedures, etc.
TSaFlt - class for creating external filters for searching and filters
for filtering rows in result sets.
TSaDb - analog of component TDatabase. Provides connection to Sybase
Anyhwere databases.
TSaDs - component-descendant of TDataset. Provides direct working with
tables, queries, stored procedures, etc.
SaMon.exe - SQL monitor.
savcl.rar
(~250Kb). Library SaVcl.