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.
|
