| Description: |
a TDataset-descendant component to access MS SQL
Server through the DBLIB API
|
| Deployment: |
TSQLQuery compiles into the EXE. It requires the SQL
Server DB-LIB; specifically ntwdblib.dll
|
Modes of
Operation:
Check indicates
primary intended
use(s). |
Local: |
|
| Multiuser File Server: |
|
| Multiuser Client/Server: |
 Yes
|
| Web Server: |
|
| Package(s) Available: |
Price: |
| 1 developer license |
$249 |
| 5 developer license |
$649 |
| 10 developer license |
$1199 |
| Site License, with source |
$2900 |
| Database/File Format Supported |
Native? |
Via |
Notes |
| Microsoft SQL Server |
Yes |
|
TSQLQuery uses DB-LIB, the older native SQL Server library. ODBC is also now considered a native interface to SQL Server. |
| Third Party Tool Compatibility: |
Compatible? |
| (Delphi) Database Explorer |
Unknown |
| Ace Reporter |
Yes |
| InfoPower |
Yes |
| Orpheus (TurboPower) |
Unknown |
| QuickReports |
Unknown |
| RAVE Reports |
Unknown |
| ReportBuilder Pro |
Unknown |
Vendor's Description (from Readme files, web site, etc.):
Summary
- TDataSet descendant (use all database-controls)
- Replaces BDE
- Commit control
- TSQLQuery always returns a read-only result set
- Implicit row based posting of updates via
TSQLUpdate
- Minimizes use of SQL Server connections
- Retains most properties/methods of TQuery and
TUpdateSQL
- No OCX:s or DLL:s (except for MS SQL Servers driver
ntwdblib.dll and protocol drivers).
- Minimizes application footprint and startup times.
- Uses Delphis:s fields editor.
- High performance!
- Works with D3 Standard and Professional as well as
Client Server version.
VCL-classes:
TSQLServer - connects the queries to a MS SQL Server.
Methods for commit control.
TSQLQuery - A query component that executes passthru
SQL-statements. It can also cache all records in the record set
and drop the server connection thus making it an ideal solution
for applications with a large number of clients. The dataset is
read-only and updates are performed thru the TSQLUpdate
component.
TSQLUpdate - Updates tables on the server. The updates are
triggered on every post event on the corresponding TSQLQuery
component.
Some of our largest customers have used SQLQuery when
building large scale web applications. We have done it here
also in some customer projects. The reason our customers choose
SQLQuery was that there are some memory leak problems with BDE,
requiring them to restart the server at regular intervals. This
problems hasn't been reported with SQLQuery.
BDE Alternatives Guide Comments:
Although I generally prefer middleware-based solutions, in
testing TSQLQuery has been very fast and easy to work with. It
presents a very light deployment burden (a few DLLs), and the
developers are very eager to fix any bugs as soon as they are
reported. If your application will only need to work with MS
SQL Server,
try this product!
Is this data old or incomplete? Visit the
How To Contribute page. You
will also need to download the XML version of the data on this page
here.
Note that you need to right-click and download the file,
not view it in your browser.
|
