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.

SQLCommand

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
Order By Start

For more on SQL, and links to SQL resources, please visit the SQL page on our web site, http://www.ResponsiveSoftware.com/sql.htm.