This function is intended only for power users who know SQL (Structured
Query Language)! Because you have full control over the database using
this interface, it is easy to inadvertently corrupt the database. You cannot
"undo" any action.
Lotto Sorcerer's SQL database is a SQLite database; see the SQLite web
site (at www.sqlite.org) for full information and syntax.
How to Invoke
Use the menu item "Utilities > Database Utilities > SQL Interface" .
- Select the lottery you want to work with from the top dropdown menu.
- Enter valid SQL statements in the text box at the bottom.
- Click the "Execute" button.
"Select Lottery" dropdown menu
Use this dropdown to select the lottery that you want to work with.
If you executed a SQL command that changed the data, clicking this button
will refresh the view of the table.
"SQL Command" combo box
Enter the SQL command or statement you want to execute in this box.
This will export the results as a Microsoft Excel spreadsheet.
This will copy the results to your System Clipboard.
This will save the results to a text file.
This will execute the SQL command you typed in the command box.
This will paste all text from your System Clipboard into the SQL Command
When you select the lottery in the top dropdown, the name of the table
will be shown at the top-right of the window.
Successfully executed SQL statements will be "remembered" and displayed in
the SQL Command text box as long as you have Lotto Sorcerer running. Use the
dropdown to recall these statements.