Navigation: Reference by Menu Options > Advanced Menu > SQL Command >
SQL Command Window
|Top Previous Next|
Quick Summary: Allows you to use SQL to select what is displayed in Time Logger's main window
How to Get There: Advanced/SQL Command
Enter your SQL command into the edit box and click OK. This is an advanced window for users familiar with SQL.
Here's an example of how incredibly powerful this command is. Let's say you are a writer and you use the Mileage field for the number of words you typed. If you want to display this value, as well as the number of words typed per hour, you could use the SQL command:
Select StartDate, StartTime, EndTime, Duration, Key, Mileage as Words, Mileage*3600/Duration as WordsPerHour from TimeRecords
For more on SQL, and links to SQL resources, please visit the SQL page on our web site, http://www.ResponsiveSoftware.com/sql.htm.