:SQLQUERY
Sql>IP 192.192.192.17
Sql>Co Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\program files\SqlLink3000\db\GUISALES.mdb
Sql>Connected to database!
Sql>Help
The following commands are available:-
COnnect  - Connects to your database using the connection string entered
CSv    - Display output in CSV format
DIsconnect - Disconnect from the database
Exit    - Disconnect and end the program
FIle    - Reports to the file. Designator is SQLLIST
HD     - Toggle headings
HElp    - Shows this screen
IP     - Selects the IP address where SqlLink3000 is running
REdo    - Redo last command
RePort   - Display output in 'Query' format
SCreen   - Display to Screen
SHow    - Show current settings
TI     - Toggle elapsed time display
or enter any valid SQL statements
Sql>
Sql>CS
SQL>Set to 'CSV' report
Sql>FI
SQL>Output to file SQLLIST
Sql>SELECT Customers.Company_Name, Orders.Required_Date, Sum(Order_Details.Unit_Price * Order_Details.Quantity) AS Order_Value, Count(Order_Details.Product_Id) AS CountOfProduct_Id FROM (Customers INNER JOIN Orders ON Customers.Customer_Id = Orders.Customer_Id) INNER JOIN Order_Details ON Orders.Order_Id = Order_Details.Order_Id GROUP BY Customers.Company_Name, Orders.Required_Date ORDER BY Orders.Required_Date DESC

    823 records reported

Start time: 09:49:47:90
End time : 09:49:57:10
Sql>
:LISTFTEMP,2

TEMPORARY FILES FOR MGR.SOCKETS,SQL

ACCOUNT= SOCKETS   GROUP= SQL  

FILENAME CODE ------------LOGICAL RECORD----------- ----SPACE----

         SIZE TYP    EOF   LIMIT R/B SECTORS #X MX

SQLLIST      512W VB     824   10000  1   512 2 * (TEMP)