If you select more than 1 character on the line where a CallTip was displayed, it will be closed. If you type a close parenthesis at any time while a CallTip is open, it will close. There are a few limitations: A calltip will display if you type a function name and open parenthesis inside a string literal. Initial implementation of CallTips when writing queries in the main editor.Modified Scintilla class from AutoGUI to work with AHK v2 and eliminated global variables and functions. New version that uses Scintilla for all Edit controls that display SQLite statements.Double clicking a snippet will overwrite the query editor with the contents of the snippet (may change this to just insert at the current cursor position)įor now, the query editor starts off with a single tab with "+" as the text because positioning is different if you add a Tab control without any tabs. If you hover over a snippet, a Tooltip is used to display the snippet contents. Select one to view the full query in the Edit to the right History tab keeps track of recently ran queries, grouped by the database file they were ran against.StatusBar shows the last SQL ran, the DB that it ran against, and the number of rows returned (also shows the number of rows displayed out of the total if you are filtering).You can filter the results by typing into the corresponding column's filter Edit and typing Results are displayed in a lower ListView.When the query editor is focused, you can run with Ctrl + Enter also.Drag any item from the Database treeview and drop into the query editor.This site has a great sample database to play with -> Source and a release has now been uploaded to GitHub. Let me know if you have any issues with it. ![]() Only handles SELECT and PRAGMA statements!Ĭreated using ahk v2-a100 and not tested with any other versions. I had to make a few adjustments to his class to work with AHK v2 and I also wanted some additional functionality. ![]() ![]() It inspired me to make my own database viewer GUI for SQLite using his class. There was some recent activity in the thread for Class_SQLiteDB by just me.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |