|
Featured Reviews
|
 SqlSpec |
|
Includes a comment editor supporting SQL Server, Oracle, and more.
|
|
| Universal SQL Editor |
|
Support Oracle, DB2, SQL Server, Sybase and other ODBC databases.
|
|
| Softerra LDAP Browser |
|
A premier explorer like LDAP client designed for Windows and admins.
|
|
| Secure Auditor |
|
IT security assessment software which performs database auditing.
|
|
| DBA Easy Control |
|
A unique versatile database management suite for Oracle DBA.
|
|
| Secure Bytes |
|
Solution for conducting automated audits on Windows, Oracle and SQL.
|
|
|
Apollo SQL is a high-speed local SQL engine add-on that provides database management for CA-Clipper (.DBF/.DBT/.NTX/.NSX), FoxPro (.DBF/.FPT/.IDX/.CDX), as well as HiPer-SIx (.DBF/.SMT/.NSX) index and memo data files. The following are some sample supported Apollo SQL statements:
SELECT * FROM mydata WHERE (state = CA)
SELECT (fname, lname, age) FROM cust WHERE (age
21)
GROUP BY lname ORDER BY fname
INSERT INTO CUST (fname, lname, email)
VALUES ( John, Smith, js@abc.com)
INSERT INTO CUST (fname, lname, email)
VALUES ( John, Smith, js@abc.com)
UPDATE cust SET fname = Joseph WHERE (ssn = 123-12-1234)
Apollo SQL works as an add-on engine for Apollo .NET, Apollo ASP, Apollo VCL, Apollo OLE DB, Apollo COM and Apollo Data Control that allows developers to use SQL-92 with these engines. The Apollo SQL add-on allows Apollo engines to use SQL in local or on a shared network, without having to connect to the Apollo Server.
Apollo SQL is an ideal solution for developers that want to use SQL in their stand-alone database applications. Developers with applications deployed in a peer-to-peer environment should consider moving to Apollo Database Server. Apollo SQL makes migration to client/server computing seamless since the Apollo Server has Apollo SQL built-in.
Features
Apollo SQL sports many powerful features such as aggregate functions, nested SELECTs, JOINs, DISTINCT clause and even cross-tab queries (columns defined by table data). Apollo SQL is very fast and it very easy to use for developers with a basic understanding of SQL. |
|
|
|
|