Optimized server access



The SQLRoots components connect directly to a
database server using its API.
Using SQLRoots does not require an other level (SQLLinks, BDE, etc.) offering
thus great advantages such as speed and an easy utilization.



SQLRoots components are derived from TComponent, so they
can be used with any Delphi edition
. SRDBGate makes the link between SQLRoots and the standard Delphi
components (the visual component for data access and for reports).



All SQLRoots based applications are implicitly optimized
in point of data access speed
for the following reasons:


the data access components use local
buffers
 
the lookup fields are populated using a
single SQL statement (the same statement as the
basetable fields). For example, for a 10 records table with 10 lookups
SQLRoots components need only one select statement, instead of 1 statement for
the basetable plus other 10 statements for each of the lookups in each rows
(adding up to a total of 101 statements) as other dataset components would
need. Moreover, these lookup fields are read-write fields

.



Built-in functionality and advanced visual controls



The query mode replaces all the necessary filter forms.
The filtering operation can now be done in the same form
with all the other operations by simply
pressing a key for changing the dataset mode.



All the SQLRoots datasets use the minimum number
of fetch operations: SRBlock and SRQuery
have local buffers
furnished only with the records being displayed, SRCursor and SRCommand retrieve the
records only when the Fetch method is explicitly called. This traffic min

• SQLRoots Database Components - site license
  Optimized server access The SQLRoots components connect directly to a database server using its API. Using SQLRoots does not...

• SQLRoots Database Components - 1 developer license
  Optimized server access The SQLRoots components connect directly to a database server using its API

• SQLRoots Database Components - 10 developers licen
  Optimized server access The SQLRoots components connect directly to a database server using its API. Using SQLRoots does not require an other level (SQLLinks, BDE, etc.) offering thus great...

• pcpmSqlGenComp 1.0
  pcpmSqlGen Component generates SQL INSERT statements from SELECT statements and runs SQL Scripts from within your application

• TMS Component Pack Pro 2.
  All TMS components for Delphi and C++Builder in one money and time saving pack All components with full source + free updates ! Consists of TADVSTRINGGRID : the stringgrid with tons of extra features TDBADVSTRINGGRID : read-only data aware version of TAdvStringGrid TADVLISTVIEW : report mode listview control with...

• ScriptC ActiveX Control 2.
  ScriptC is small and effectual programming C-like language

• Auto-Error 1.
  Auto-Error is actually 2 applications in one. The Auto Error VB Error Scripting Application is designed to process VB project files (forms, modules, etc.) to include line numbers on every line of code and add VB error headers and footers to every...

• pcpmSqlGen 1.0
  pcpmSqlGen generates SQL INSERT statements from SELECT statements

• GM - SQL Script Processor 1.
  Simple but effective SQL Script execution Tool

• Aachen/Berlin Fibu - Finanzbuchhaltung 7.1.
  Fibu Aachen/Berlin Bookkeeping