Software solutions for a mobile world

: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)

Contact

M: +44 (0)7860 907493

pete@gui-innovations.com

More

Connections

   

Twitter Feed