Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.

ID: 18968, SQLRoots

by Leo Nistor Email:

Direct connection to server API (Oracle, Interbase, Firebird, PostgreSQL, ODBC), transaction management, query- and filtering-mode in the same form, automatic Lists Of Values
Download Details
FTP  download also available 0 bytes
CDN Login Required to Download. (You will be redirected to the login page if you click on the Download Link)
To download this, you must have registered:
A free membership

For Delphi, Version 1.0  to 2.0 11 downloads
Copyright: Commercial use requires permission

Size: 0 bytes
Updated on Sun, 13 Oct 2002 04:30:21 GMT
Originally uploaded on Sun, 13 Oct 2002 04:30:21 GMT
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. Supported servers: Oracle, Interbase, Firebird, ODBC, PostgreSQL

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 minimization enables the use of the database server to its full capacity, even over low bandwidth connections.

All the visual controls (SREditColumns, SRComboColumns, SRCheckBoxColumns, SRMemoColumns) can be used as single items, a column of items or can be grouped to form a mixed grid. Each SREditColumn item can have a different appearance depending on its value.

SQLRoots offers automatically generated forms for lookup list of values, replaceable with customized forms when necessary.

Visit for:
- fully-functional demo
- sample and demo applications
- on-line documentation
- support services

For more information, see

   Latest Comments  View All Add New

Move mouse over comment to see the full text

Could not retrieve comments. Please try again later.

Server Response from: ETNACDC03